Extended Systems OneBridge 4.1 Guía de usuario descargar pdf (Pagina 37)

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.

1 2 ... 32 33 34 35 36 37 38 39 40 41 42 ... 221 222

Sin comentarios

Extended Systems OneBridge 4.1 Guía de usuario Pagina 37