This component adds records to a database table. It lets you control insertion by excluding attributes or assigning default values.
Use this component if you want to add all records from the IN-port of the component to a database table.
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.
To use DB Data Sink Insert