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

Create an Oracle Repository

Creating an Oracle database is fully documented in the product information provided with your Oracle installer.

Before creating an Oracle data repository, install the appropriate version of Oracle (9i, 10g, 11g or 12c) and MDAC 2.6 or higher, and obtain access permission to create a new database.

There are many ways to create a new Oracle repository; a common method is to use a SQL-based Management Console such as SQL Developer, which provides a convenient graphical user interface for creating databases, executing scripts, and making backups and restores.  However, the exact method used is not important to this discussion, and you can use the most convenient or familiar method at your disposal.

Having created your Oracle repository, use the SQL script provided by Sparx Systems to create the required table definitions and indexes for Enterprise Architect. The  EASchema_1220_Oracle.sql is freely available on the DBMS Based Repositories page on the Sparx Systems website.


  • Enterprise Architect only supports the 32-bit versions of Oracle's OLE/DB and ODBC drivers
  • For performance reasons, Sparx Systems recommends the use of the Oracle's OLE/DB driver over the Oracle ODBC driver
  • Enterprise Architect is not compatible with the Microsoft OLE DB Provider for Oracle driver
  • Set the collation to the alphabet you use, such as Latin or Cyrillic

Learn more