Adding DB Data Sink Insert 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 DB Data Sink Insert
Add the component to the project and connect the ports to adjacent components.
Enter the Connection Parameters as described in “Entering database connection parameters”.
Create a destination table. If the destination table you are going to use already exists, continue with step 5.
Right-click the component and select either Add Destination Table from Input, or Add Destination Table from Port. Optionally, the command lets you create the destination table based on the IN-port structure of the component or the structure of any other port within the project. However, you might also create the destination table with your own toolset.
Click Destination Table, and select the table to be used from the list of available tables.
