Setting up Salesforce Bulk Mode with COZYROC Script Salesforce Bulk Result Transformation
When using COZYROC Salesforce components in Bulk Mode the operations are asynchronous, meaning the results are not immediately available. If needed, the status, identifiers of newly created records, and any error information can be retrieved in an additional step using Script Salesforce Bulk Result Transformation. For example, after initiating a bulk insert, the script can retrieve the IDs of the newly inserted records and any error details. In addition, introducing such a step can be used to ensure the current bulk load is completed before the next set of operations is started.
Step-by-step instructions:
Step 1: Salesforce Connection Setup
- Configure the Salesforce
Connection: Set up your Salesforce connection in COZYROC.
Step 2: Salesforce Destination Component Setup
- Configure Salesforce Destination Component:
- Use the Salesforce Destination Component in Bulk Mode to insert accounts.
- Create a String type variable,
JobId, to capture the job ID.
Step 3: Configure the Salesforce Destination Component
- Setup Salesforce Destination Component:
- Select Bulk Mode in the Salesforce Destination Component.
- Capture the
JobIdusing a String type variable.
Step 4: Setup the COZYROC JavaScript Component
- Add and Configure the JavaScript Component:
- Use the COZYROC JavaScript Component Script Salesforce Bulk Result Transformation
- Set the following parameters:
- Connection: Select the Salesforce Connection Manager.
- JobIdVariable: Choose the
JobIdvariable created earlier. - BatchIdColumn: Select the
Idcolumn holding the batch identifier.
Step 5: Retrieve and View Results
- Execution and Results:
- Run the package. The script processes the results and populates the output columns.
- The
ResultIdcolumn shows the IDs of the newly created account records. - The
Idcolumn shows the batch identifier. - Error information, if any, will appear in the corresponding error columns (error code, description, message).
Note! Please keep in mind that retrieving the results from asynchronous processing could decrease the processing speed.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: Invalid Batch: type is not needed for non polymorphic foreign key references: <Relationship Field>
Action: When I am executing a package that includes Salesforce Destination component in bulk mode I get the following error message: Error Message: Invalid Batch: type is not needed for non polymorphic foreign key references: <Relationship Field> ...Error Message: Invalid Server Host (Salesforce Connection)
Action: When using the Salesforce Connection I am getting the error message below: Error Message: "Invalid Server Host" Solution: Salesforce has sent out notices to their customers that some Salesforce Platform API legacy versions will be deprecated ...Why is the batch size in my Salesforce bulk data load different than the batch size I set?
Scenario: We are doing bulk data load to Salesforce and the default size which we have set is 10000 but when i look at the Salesforce the number of records are processing per batch is 112 records Here is the Salesforce destination configuration Can ...Missing objects or columns when using Salesforce Destination Component
Most likely the reason for object or column to be missing is that you are using older version of Salesforce API. To verify which version of Salesforce API you are using please check what is showing in the Server URL field on the Salesforce Connection ...How to upgrade a script in Script Component Plus from 2005 to 2008
How to upgrade a script from 2005 to 2008 In order for this process to work, you must have both SQL 2005 and 2008 installed side-by-side on the same machine. Most of the scripts published in the public script repository are for SQL 2005. However they ...