Adding a data provider

Use one of these methods to add DB Data Provider Full Load to your project:

Drag the component from the Source 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.

When you add a component to the Design window, the default configuration of the component is displayed.

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_US from the Host Name drop-down list.

When you confirm the initial component settings, the settings appear in the Properties window.
To define the information to retrieve from the data source, click the query icon in the Query field.
Click the Query Designer icon to generate the query.

You can also enter the SQL query manually.

The left pane of the Query Designer window lets you navigate the table catalog of the connected database.
To add one or more tables, drag the table name onto the Design window, or right-click the table name and select Add Object to Query.
Click and drag the PRODUCTS table to the Design window.
Click Save to close Query Designer and return to the Query window. The select query is automatically generated.
Click Execute the Query icon to run or test the query.
Click Save to close the Query window.

When you have successfully configured a component, the color of the ports associated with it change from red or yellow to green.