Adding DB Data Sink Synchronize to a project opens a configuration window and properties section. Use the configuration window and properties section to identify the connection parameters, destination table, and processing options.
To use this component
Add the component to the project and connect the ports to adjacent components.
Enter the Connection Parameters as described in the section Entering Database Connection Parameters.
Click the Destination Table button and select the table to be used from the list of available tables.
Select one or more attributes composing the key. This key will be used to identify the records to be updated in the destination table. If no matching record exists a new record will be inserted.
To enter optional properties
Click the Update Options button to open the Update Options dialog Window. The Update Options apply to all records that are being updated. They do not apply to records that are inserted.
Deselect the attributes you want to exclude from update.
In the SQL UPDATE SET column specify an expression or constant that will be assigned to the record during the update (optional).
In a SQL language notation the contents of the columns will be processed as:
UPDATE customersSET cu_createdate = '2005-02-26'WHERE ….
You can use any comparison operator or expression allowed in the SQL language of the underlying database. Dynamic expression in square brackets will be evaluated during initialization of the component.
Click the Insert Options button to open the Insert Options dialog window. The Insert Options apply to all records that are being inserted. They do not apply to records that are updated.
A record with an identifier that does not exist in the table will be inserted with all the key attribute values plus the attributes selected in the Insert Options dialog window. Select or deselect any of the attributes. You can specify values for attributes that will be inserted, thus overwriting the corresponding value of the incoming attribute.
In the example above, all records that are being inserted will be inserted with the current date in its CU_CREATEDATE attribute.
