Adding and Configuring a Data Sink

Add DB Data Sink Insert to your project.

Drag the component from the Destination tab of the Component Store to the Design window.
In the Component Store, right-click the component that you want to add, and select Add.
In the Component Store, double-click the component you want to add.

As soon as you add a component to the Design window, the component displays its default configuration.

Note:

Properties shown in bold in any configuration window are required.

Select ODBC as the interface.
Select ETLDEMO_DWH as the host.
Enter PRODUCTS in the Destination Table field. Alternatively, click the Destination table icon and select PRODUCTS.
Click Finish to confirm your settings.

Your project now consists of two components. The link between the components is created automatically if you selected Create automatic links when components are added in the File > Preference window. If the line is not automatically created, click the outgoing port and drag it onto the input port of the data sink to create it.

The output port of the DB Data Provider Full Load component and the input port of the DB Data Sink Insert component both display in green. This indicates that both components are configured.

In the Property window for the DB Data Sink Insert component, you can review and set all properties of the selected component.