PowerExchange for Db2 Warehouse User Guide for PowerCenter

PowerExchange for Db2 Warehouse User Guide for PowerCenter

Importing Db2 Warehouse Source Definitions

Importing Db2 Warehouse Source Definitions

To create a Db2 Warehouse source definition, use the Source Analyzer to import source metadata with the Db2 Warehouse relational data source.
  1. In the Source Analyzer, click
    Sources
    Import from Database.
  2. Select the Db2 Warehouse data source used to connect to the source database.
    If you need to create or modify a Db2 Warehouse data source, click the
    Browse
    button to open the ODBC Administrator. Create the Db2 Warehouse data source and click
    OK.
    Select the new Db2 Warehouse data source.
  3. Enter a database user name and password to connect to the database.
    The user must have the appropriate database permissions to view the object.
    You may need to specify the owner name for database objects you want to use as sources. If you want to import tables for all the owners, click
    All
    .
  4. Optionally, use the search field to limit the number of tables that appear.
  5. Click
    Connect.
  6. Scroll down through the list of sources to find the source you want to import. Select the relational object or objects you want to import.
    You can hold down the Shift key to select a block of sources within one folder or hold down the Ctrl key to make non-consecutive selections within a folder. You can also select all tables within a folder by selecting the folder and clicking
    Select All.
    Use the
    Select None
    button to clear all highlighted selections.
  7. Click
    OK.
The source definition appears in the Source Analyzer. In the Navigator, the source definition appears in the Sources node of the active repository folder under the source database name.

0 COMMENTS

We’d like to hear from you!