Update Action

This action updates existing records in the data source.

Action Settings

Setting	Description
Table	The target table to update records in.
Keys	The target table fields, by which input records and target table records are matched. This parameter is optional, if you don’t set it up, the primary key fields are used for matching.

Action Parameters

Update action parameters correspond to the target table fields that allow updating data, primary key, and Keys fields. You must map the parameters corresponding to the following fields:

• Keys fields if Keys are specified
• primary key fields if Keys are not set
• the fields that you want to update

Result

The action updates a record with the matching Keys in the specified table.

Example

Here is an example of the Update action in the Target component of Data Flow. This example shows the Update action that updates Accounts in Salesforce.