Skip to main content

Create and Configure an ODBC entry for use with Enterprise Architect

  • warning: Illegal string offset 'files' in /home/cintegri/public_html/modules/upload/upload.module on line 281.
  • warning: Illegal string offset 'files' in /home/cintegri/public_html/modules/upload/upload.module on line 281.
Printer-friendly version

The following assumes that Enterprise Architect is being used on a Windows platform.

1. Select the Windows Control Panel | Administrative Tools | Data Sources (ODBC) option. The ODBC Data Sources Administrator window displays. Select the System DSN tab.

2. Click on the Add button. The Create New Data Source dialog displays, enabling you to add a new DSN.

3. Select the DataDirect/OpenEdge SQL or other appropriate Progress driver from the list. The name varies by version.

4. Click on the Finish button. The DSN Configuration dialog displays.

5. Enter the following configuration details:

· The Data Source Name

· The Description (optional)

· The Host Name and Port Number of the DBMS server

· The Database Name on the selected server

· The User ID.

Note, you must use the service/port number and not the name.

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.

8. If the test does not succeed, review your settings.

9. Click OK to exit until no longer in the tool.

Note that there is further detail on this process in the Help for EA under the topic "Set up a Progress OpenEdge ODBC Driver".

Performance of this connection with large models is problematic at the moment and is being researched. Tentative partial recommendations include running update statistics on the database and setting the Fetch Array Size in the ODBC connection to a much larger value. I am currently using 5000. I am setting the default isolation level to blank since setting to read uncommitted seems to produce errors.