Drag the DB Data Sink Insert component onto the Design window.
In the Database Configuration window, add the connection parameters for the target database.
See the “DB Data Sink Insert properties list” for specific field requirements.
Select or enter the Destination table.
You can write to an existing table or add a table based on existing ports in the project. If you want to add a table based on an existing port structure, skip this step. See “Adding a Destination table” for additional information.
Click Finish.
Specify any other optional properties in the Properties window.
To update the port structure with changes made to the database:
Right-click the DB Data Sink Insert component.
Select Reconfigure.
The Reconfigure option updates the component configuration when there is a change in the database schema. It closes the current connection, opens a new connection to the database, reads the metadata of the query, and applies the updates to the port structure.
To load data currently available at the input port to a database or a text file:
Right-click the DB Data Sink Insert component.
Select Flush Buffer.
The Flush Buffer option writes out the buffered rows to the target. All components for which a write block size has been specified, can buffer data until the write block size is reached. At any time during simulation, if there is data in the buffer, the Flush Buffer option will display along with the number of rows that are yet to be written to the target. If the buffer is empty, the option will be grayed out.
Updating port structure