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 menu. See “Database connection settings” for information about the different interface types.
Select ETLDEMO_DWH from the Host Name menu.
Enter PRODUCTS in the Destination Table field. Alternatively, click the Destination table icon and select PRODUCTS from the list displayed.
Click Finish to confirm your settings.
Your project now consists of two components. The link between the components is created automatically if you selected the Create automatic links when components are added option in the File | Preference window. If the line is not automatically created, click on the output port and drag it onto the input 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
connection point by selecting and deleting the mapping line that
is currently linking to it. To delete, select the mapping line and
press the Delete key, or right-click and select Delete.
