Set up an Oracle ODBC Driver

After you have created a repository on your Oracle database, you set up the Oracle ODBC driver so that you can connect to a project on that repository from Enterprise Architect (in preference to using an OLE DB connection).

Prerequisites

Install:

  • Oracle DBMS and repository

Set up the Oracle ODBC driver

Your Oracle driver is now available to connect to the repository from Enterprise Architect.

Step

Action

1

Under both 32-bit and 64-bit operating systems, Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC. You can quickly load the correct 32-bit ODBC Data Source Administrator by selecting 'Tools | ODBC Data Sources'.

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 'Oracle in OraDB11g_home1' from the list (or similar, depending on the ODBC installation).

4

Click on the Finish button.

The 'Oracle ODBC Driver Configuration' dialog displays.

5

Enter these configuration details:

  • A data source name for the connection
  • A description (optional)
  • The TNS Service Name (click on the drop down arrow and select from the list)
  • User ID

6

Click on the Test Connection button and enter the Oracle user password 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.

Learn more