tSalesforceBulkExec
Gains in performance while carrying out the intended data operations into your
Salesforce.com.
The tSalesforceOutputBulk and tSalesforceBulkExec components are used together
in a two step process. In the first step, an output file is generated. In the second
step, this file is used to feed the Salesforce database. These two steps are fused
together in the tSalesforceOutputBulkExec component. The advantage of using two separate
steps is that the data can be transformed before it is loaded in the database.
tSalesforceBulkExec Standard properties
These properties are used to configure tSalesforceBulkExec running in the Standard Job framework.
The Standard
tSalesforceBulkExec component belongs to the Business and the Cloud families.
The component in this framework is generally available.
Basic settings
Property Type |
Select the way the connection details
This property is not available when other connection component is selected |
Connection Component |
Select the component whose connection details |
Connection type |
Select the type of the connection from the drop-down list, either Basic or OAuth.
|
Module Name |
Click the […] button next to the field and in the |
Schema and Edit schema |
A schema is a row description. It defines the number of fields (columns) to Click Edit schema to make changes to the schema.
Click Sync columns to retrieve the schema from This component offers the This dynamic schema |
Output Action |
Select one of the following operations to be
performed from the drop-down list.
|
Bulk File Path |
Specify the path to the file that stores the data to be processed. |
Advanced settings
Salesforce URL |
Enter the Webservice URL required to connect to |
Need compression |
Select this check box to activate SOAP message compression, which can result in increased |
Trace HTTP message |
Select this check box to output the HTTP interactions on the console. |
Client Id |
Enter the ID of the real user to differentiate between those who use the same account and |
Timeout (milliseconds) |
Enter the intended number of query timeout in Salesforce.com. |
Use Proxy |
Select this check box to use a proxy server, and in the Host, Port, User Id, and Password fields displayed, specify |
Concurrency Mode |
Select the concurrency mode for the job.
|
Rows to Commit |
Specify the number of lines per data batch to |
Bytes to Commit |
Specify the number of bytes per data batch to |
Wait Time Check Batch State (milliseconds) |
Specify the wait time for checking whether the |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job level |
Global Variables
Global Variables |
NB_LINE: the number of rows read by an input component or
NB_SUCCESS: the number of rows successfully processed.
NB_REJECT: the number of rows rejected. This is an After
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
This component is more commonly used with the tSalesforceOutputBulk component. Used together, they |
Limitation |
The bulk file to be processed should be .csv Due to license incompatibility, one or more JARs required to use this component are not |
Related Scenario:
For a related scenario, see Scenario: Inserting transformed bulk data into Salesforce.