Required. Used to uniquely identify this sink for lineage, annotating metadata, etc.
Use Connection (yes/no toggle)
Optional. Use an existing connection. If a connection is used, you do not need to provide the credentials.
Optional. Name of the connection to use. Object Names information will be provided by the connection.
You also can use the following macro function:
Required. Salesforce username.
Required. Salesforce password.
Optional. Salesforce security token. If the password does not contain the security token the plugin will append the token before authenticating with Salesforce.
Required. Application Consumer Key. This is also known as the OAuth client ID. A Salesforce connected application must be created in order to get a consumer key.
Required. Application Consumer Secret. This is also known as the OAuth client secret. A Salesforce connected application must be created in order to get a client secret.
Required. Salesforce OAuth2 login URL.
Default is https://login.salesforce.com/services/oauth2/token
Optional. Maximum time in milliseconds to wait for connection initialization before it times out.
Default is 30000 milliseconds.
Optional. Proxy URL. Must contain a protocol, address and port.
Required. Salesforce object name to insert records into.
There are also sObjects that are not supported in the Bulk API of Salesforce. When a job is created using an object that is not supported in the Bulk API, “Entity is not supported by the Bulk API“ is thrown. These objects are also not supported by Einstein Analytics as it also uses Bulk API for querying data.
Below is a non-comprehensive list of sObjects that are not currently available in the Bulk API:
*Feed (e.g. AccountFeed, AssetFeed, …)
*Share (e.g. AccountBrandShare, ChannelProgramLevelShare, …)
*History (e.g. AccountHistory, ActivityHistory, …)
*EventRelation (e.g. AcceptedEventRelation, DeclinedEventRelation, …)
Required. Operation used for writing data into Salesforce.
Default is Insert.
Upsert External ID Field
Optional. External ID field name. It is used only if operation is upsert or update. The field specified can be either ‘Id’ or any custom field, which has external ID attribute set.
Job Concurrency Mode
Optional. The Salesforce job concurrency mode for the bulk job. Select one of the following options:
Parallel. Process batches in parallel mode.
Serial. Process batches in serial mode. Processing in parallel can cause lock contention. When this is severe, the Salesforce job can fail. If you’re experiencing this issue, in the Salesforce sink, change Job Concurrency Mode to
Serial and run the pipeline again. This mode guarantees that batches are processed one at a time, but can significantly increase the processing time.
Default is Parallel.
Max Records Per Batch
Required. Maximum number of records to include in a batch when writing to Salesforce. This value cannot be greater than 10,000.
Default is 10000.
Max Bytes Per Batch
Required. Maximum size in bytes of a batch of records when writing to Salesforce. This value cannot be greater than 10,000,000.
Default it 10000000.
Required. Strategy used to handle erroneous records.
Default is Skip on error.