Use one of these methods to 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.
Properties shown in bold in
any configuration window are required.
Select ODBC from the Interface drop-down list. See “Database connection settings” for information about the different interface types.
Select ETLDEMO_DWH from the Host Name drop-down list.
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 on the OUT-port and drag it onto the IN-port of the data sink to create it.
The outgoing port (OUT-port) of the DB Data Provider Full Load component and the ingoing port (IN-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.
Reviewing and defining attribute mappings
Right-click the link between the components. The color of the link changes to green.
Select Mapping.
The mapping between the data source and the target source is created automatically. To change mappings, select the connecting line and attach it to another connection point.
You can map only to an unassigned target connection
point. If all target connection points are already assigned, unassign
a connection point by deleting the mapping line that is currently
linking to it. Select the mapping line and press the Delete key,
or right-click and select Delete.
