Information icon IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5
space Feedback

Creating a Data Connection object from a metadata import

When you import metadata from a data source you can choose to save the connection information that you used to connect to that data source as a data connection object.

You can choose to do this when performing the following types of metadata import:

  • Import via connectors
  • Import via supplementary stages (Import > Table Definitions > Plug-in Metadata Definitions)
  • Import via ODBC definitions (Import > Table Definitions > ODBC Table Definitions)
  • Import from UniVerse table (Import > Table Definitions > UniVerse Table Definitions)
  • Import from UniData® 6 table (Import > Table Definitions > UniData 6 Table Definitions)
  • Import from Orchestrate® Schema (Import > Table Definitions > Orchestrate Schema Definitions)

In some of these cases IBM® InfoSphere® DataStage® provides a wizard to guide you through the import, in others the import is via a simple dialog box. The method for creating a data connection object from the import varies according to the import type.

  • Importing via connectors
    When you import metadata via a connector, a wizard guides you through the process. The wizard offers different properties depending on which connector you are using for the import.
  • Importing via supplementary stages
    When you import via a supplementary stage, a wizard guides you through the process. The wizard is slightly different depending on which supplementary stage you are using for the import.
  • Importing via ODBC Definitions or from UniVerse or UniData 6 tables
    You import table definitions from all three of these sources by filling in a dialog box. The dialog box is similar in all three cases.
  • Importing via Orchestrate schemas
    When you choose to import table definitions using the Import > Table Definitions > Orchestrate Schema Definitions, a wizard offer you the choice of importing from an Orchestrate schema file, or using a parallel job stage to make a connection to one of the following types of database:
Parent topic: Creating a data connection object

PDFThis topic is also in the IBM InfoSphere DataStage and QualityStage Designer Client Guide.

Update timestamp Last updated: 2011-12-8