Use the Salesforce Destination component to store the output of your package into a Salesforce object.
To define the Salesforce destination:
- Add a Salesforce Destination component at the end of your dataflow.
- Open the component and name it.
- Define the parameters for connecting to your Salesforce as follows:
- salesforce connection - either click the drop-down arrow and select an existing connection, or click (create new) to create a new connection.
- destination object - select the target object in your Salesforce org.
- operation type - the method of data manipulation in Salesforce:
- Insert - appends data into the object. Note that you can't insert data into the id field.
- Upsert - inserts new data into the object and updates existing data according to the selected upsert key
- Delete - deletes data in the destination object by Salesforce ID.
- upsert key - when operation type is upsert, you must map a key field and select it as the upsert key. This can be either the internal id field, or an external key field. The external key should not allow duplicate values.
- salesforce fields - select fields from the target object to map data-flow fields into, or click "auto fill fields" to map fields automatically (see below).
- batch size - number of records that are inserted to Salesforce in each batch (default 1000).
- max errors - maximum number of errors to tolerate when inserting data into Salesforce. Note that the actual number of errors may be greater than the maximum due to the parallel nature of the process.
- Map fields from your dataflow to fields in the target object. You can click the Auto-fill fields icon to automatically map data-flow fields to object fields according to name. When mapping fields to table columns, take into consideration the mapping of data types. If you map mismatched data types, the job will fail. When you map a data-flow field into a relation field, you should also select the relation field in the reference object. This can be either the internal Salesforce id field, or an external key. The external key in the referenced object should not allow duplicate values.