Use one of the following methods to add a data provider to your project:
Drag the component from the Component Store to the Design section.
Right-click the component that you want to add and select Add from the pop-up menu.
Double click the component.
As soon as you add a component to the Design section, 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 “Entering database connection parameters” for information about all of the Interface types.)
Select ETLDEMO_US from the Host Name drop-down list.
After you confirm the initial component settings, the settings appear in the Properties section.
To define what information should be retrieved from the data source, click Edit on the Query property.
The Query window appears.
Enter a SQL Query or click Query Designer to generate the necessary SQL.
The left section 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 to the Design section, or right-click the table name and select Add Object to Query.
Click the PRODUCTS table and drag it to the Design section.
Click Save to close the Query Designer. You return to the Query window. The SELECT query has been generated automatically.
Click Execute the Query to run or test the query. You can also modify and edit 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.
To configure a data provider