Oracle Data Repository

Before creating an Oracle data repository, you must have the appropriate version of Oracle (9i, 10g or 11g) and MDAC 2.6 or higher installed, and access permission to create a new database. Creating an Oracle database is beyond the scope of this User Guide - refer to your Oracle documentation for assistance.

Having created your Oracle database, use the SQL script provided by Sparx Systems to create the required table definitions and indexes for Enterprise Architect. You can obtain the scripts from the Sparx Systems website, on the:

  • Registered Corporate edition Resources page (Registered users)
  • Corporate edition Resources page (Trial users)

Third Party Tools:

If you are unfamiliar with Oracle and DBMS systems in general, you might want to consider a suitable front end tool. You could connect to the database and execute the scripts with a program such as Oracle SQL*Plus or SQL Plus Worksheet.


  • This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions
  • Ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic

Learn More: