Table of Contents

Search

  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
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Importing Relational Source Definitions

Importing Relational Source Definitions

To create a relational source definition, use the Source Analyzer to import source metadata.
To import a relational source definition:
  1. In the Source Analyzer, click
    Sources
    Import from Database.
  2. Select the ODBC data source used to connect to the source database.
    If you need to create or modify an ODBC data source, click the
    Browse
    to open the ODBC Administrator. Create the data source, and click
    OK
    . Select the new ODBC data source.
  3. Enter a database user name and password to connect to the database.
    You 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.
  4. Optionally, use the search field to limit the number of tables that appear.
    To enable case-sensitive search for a table, enclose the search string in double quotes.
  5. Click
    Connect.
    If no table names appear, or if the table you want to import does not appear, click
    All.
  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 new source definition appears in the
    Sources node
    of the active repository folder, under the source database name.


Updated June 25, 2018