To create a relational target definition, use the Target Designer to import target metadata.
To import a relational target definition:
In the Target Designer, click Targets > Import from Database.
Select the ODBC data source used to connect to the target database.
If you need to create or modify an ODBC data source first, click the Browse button to open the ODBC Administrator. After creating or modifying the ODBC source, continue with the following steps.
Enter the user name and password needed to open a connection to the database, and click Connect.
If you are not the owner of the table you want to use as a target, specify the owner name.
Drill down through the list of database objects to view the available tables as targets.
Select the relational table or tables to import the definitions into the repository.
You can hold down the Shift key to select a block of tables, or hold down the Ctrl key to make non-contiguous selections. You can also use the Select All and Select None buttons to select or clear all available targets.
Click OK.
The selected target definitions now appear in the Navigator under the Targets icon.