You can also use the OpenEdge tools to connect to a non-OpenEdge database.

To connect to a non-OpenEdge database:

  1. Create an OpenEdge RDBMS. This database stores the target database's structure as an OpenEdge schema; it is a schema holder. A schema that corresponds to a non-OpenEdge database is a DataServer schema.
  2. Connect the schema holder.
  3. Use the appropriate Create Schema parameter from the Data Dictionary's database menu to create the DataServer schema in the schema holder. This parameter:
    • Creates a _Db table record (auto-connect entry) for the non-OpenEdge database in the schema holder database
    • Connects to the non-OpenEdge schema (through a DataServer)
    • Displays the menu so that you can choose the tables that you want to include in the OpenEdge schema
  4. Connect the DataServer schema.

    For complete information about connecting and using non-OpenEdge databases, see the OpenEdge DataServer guides (Use the Microsoft SQL Data Server or Use the Oracle Data Server).