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, probably the most common is to use a SQL based Management Console like SQL Developer, which provides a convenient graphical user interface to enable the creation of databases, the execution of scripts, and backups and restores.  However the exact method used is not important to this discussion, therefore you are free to 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.

Notes

  • 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