Import Relational Source & Target Definitions

To import a relational source definition:

• • 1. In the Source Analyzer, click Sources > Import from Database.

• • 1. Select the ODBC data source used to connect to the source database.

• 1. If you need to create or modify an ODBC data source, click the Browse button to open the ODBC Administrator. Create the data source, and click OK. Select the new ODBC data source.

     1. Enter a database user name and password to connect to the database.

  2. Note: The user name must have the appropriate database permissions to view the object.

  3. You may need to specify the owner name for database objects you want to use as sources.

• • 1. Click Connect.

• 4. If no table names appear or if the table you want to import does not appear, click All.

• • 2. 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.

• 1. 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.

• • 2. Click OK.

• 1. The source definition appears in the Source Analyzer. In the Navigator, the new source definition appears in the Sources node of the active repository folder, under the source database name.

• • 2. Click Repository > Save.