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.
- 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).
- 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
- 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.
- batch size - number of records that are inserted to Salesforce in each batch (default 1000).
- 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.