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

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