Adding and Configuring a Data Provider

Add the DB Data Provider Full Load component 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 shown.

Note:

Properties shown in bold in any configuration window are required.

  1. Select ODBC as the interface.
  2. Select ETLDEMO_US as the host.

    When you confirm the initial component settings, the settings appear in the Properties window.

  3. To define the information to retrieve from the datasource, click the Query icon in the Query field.
  4. Click the Query Designer icon to generate the query.
    Note:

    You can also manually enter the SQL query.

    The left pane 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 onto the Design window, or right-click the table name and select Add Object to Query.
  6. Click and drag the PRODUCTS table to the Design window.
  7. Click Save to close Query Designer and return to the Query window. The select query is automatically generated.
  8. Click Execute the Query icon to run or test 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.

Parent topic: Creating and Simulating a Sample ETL Project