Book a Demo

Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

Set up an Oracle ODBC Driver

After you have created an Oracle repository, you can either set up an ODBC DSN to the new database in order for Enterprise Architect to connect to it, or configure Enterprise Architect to use the Oracle OLE DB provider in connection strings to the new database.

Notes:

  • For performance reasons, Sparx Systems recommends using Oracle Provider for OLE DB
  • Enterprise Architect does not support the 'Microsoft OLE DB Provider for Oracle' driver

Prerequisites

  • Install the 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 the 'Configure > User Tools > ODBC Data Sources' ribbon option.

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

Prev Next