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:

About this task

  • DB2®
  • Informix®
  • Informix XPS
  • Oracle

If you choose to import from a database, you can save the connection details you use to a data connection object by using the following procedure.

Procedure

  1. Supply the required database connection details and click the Save Data Connection button. The Data Connection dialog box appears with connection details already filled in.
  2. Fill in the remaining details such as name and description, and folder to store the object in.
  3. Click OK to close the Data Connection dialog box, and continue with the import wizard.