Set up a Progress OpenEdge ODBC Driver

After you have created a repository on your Progress OpenEdge database, you set up the Progress OpenEdge ODBC driver so that you can connect to a project on that repository from Enterprise Architect.

Prerequisites

Install:

OpenEdge DBMS (10.1C) and repository
DataDirect ODBC driver for OpenEdge software (version 4.20 or later)
 

Set up the ODBC driver

Step

Action

1

If you are using a 32-bit operating system:

Select the WindowsTM Control Panel | Administrative Tools | Data Sources (ODBC) option
 

If you are using a 64-bit operating system:

Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC; to set up the ODBC configuration on 64-bit clients, run the 32-bit ODBC Data Source Administrator from C:\Windows\SysWOW64\odbcad32.exe
You can quickly load the correct 32-bit ODBC Data Source Administrator by selecting Tools |  ODBC Data Sources in the Enterprise Architect menu bar
 

The ODBC Data Source Administrator window displays.

 

2

Click on the Add button.

The Create New Data Source dialog displays, enabling you to add a new DSN.

 

3

Select DataDirect/OpenEdge SQL Driver from the list.

 

4

Click on the Finish button.

The DSN Configuration dialog displays.

 

5

Enter the following configuration details:

A data source name for the connection
A description (optional)
The host name and port number of the DBMS server
The database name on the selected server
The User ID

 

6

Click on the Test Connect button to confirm that the details are correct.

 

7

If the test succeeds, click on the OK button to complete the configuration.

If the test does not succeed, review your settings.

 

 

Your OpenEdge connection is now available to connect to the repository from Enterprise Architect.

Learn more