Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  17. Datatype Reference
  18. Configure the Web Browser

Importing Relational Target Definitions

Importing Relational Target Definitions

To create a relational target definition, use the Target Designer to import target metadata.
To import a relational target definition:
  1. In the Target Designer, click Targets > Import from Database.
  2. 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.
  3. 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.
  4. Drill down through the list of database objects to view the available tables as targets.
  5. 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.
  6. Click OK.
    The selected target definitions now appear in the Navigator under the Targets icon.

Updated June 25, 2018