Try OpenEdge Now
skip to main content
Managing ABL Applications
ABL and R-code Deployment and Management : Managing Client Access to Databases : Connecting clients to databases : Connecting to a non-OpenEdge database
 
Connecting to a non-OpenEdge database
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 (OpenEdge Data Management: DataServer for Microsoft SQL Server or OpenEdge Data Management: DataServer for Oracle).