User`s guide

CHAPTER 3 Getting Started
User’s Guide 23
2 Select ETLDEMO_US from the Host Name drop-down list.
After you confirm the initial component settings, the settings appear in the
Properties section.
3 To define what information should be retrieved from the data source, click
Edit on the Query property.
The Query window appears.
4 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.
5 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.
6 Click the
PRODUCTS table and drag it to the Design section.
7 Click Save to close the Query Designer. You return to the Query window.
The
SELECT query has been generated automatically.
8 Click Execute the Query to run or test the query. You can also modify and
edit the query.
9 Click Save to close the Query Window.
Note When you have successfully configured a component, the color of
the ports associated with it change from red or yellow to green.
Adding a data sink
❖ To add a data sink
1 In the Component Store, go to the Destination tab and select the DB Data
Sink Insert component by dragging it into the project.
2 Select ODBC from the Interface drop-down list.
3 Select ETLDEMO_US from the Host Name drop-down list.
4 Click the selection button of the Destination Table property and select
PRODUCTS from the table catalog.
5 Click Finish to confirm your settings.