Set up an Oracle ODBC Driver

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

Note that Sparx Systems recommends using Oracle Provider for OLE DB. Connecting with either Microsoft OLE DB Provider for ODBC or Microsoft OLE DB Provider for Oracle could cause unexpected behavior or performance issues due to known limitations of those drivers.

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.