Adding a Target in a Flow


Once a data flow contains all of the fields you need, you can load it to a target data store. 

  • To add a new target, click New Target at the top of the flow canvas, as shown in the following image.

  • To add an existing target, click Existing Target at the top of the flow canvas, as shown in the following image.

    A file picker opens, so you can select the existing target.

Setting Load Options

Right-click the target, and select Load Options to select or enter the target DBMS, application, synonym and table name. 

For example, the following load options for a new target load the data into a Microsoft SQL Server table, to an application named ibisamp, with synonym and table name dminv01.

You can change the selections and enter new names, then click OK

Click OK.

For an existing target, you can select how you want the new records merged into the existing target, as shown in the following image.

 

You can replace the target records, merge the new records into the target, or append the new records into the target.

In addition, you can use the Merge Editor to customize the merge process.