Create an Oracle Data 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.

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

• Registered Corporate edition 'Resources' page (Registered users), or
• Corporate edition 'Resources' page (Trial users)

When you eventually connect to the Oracle database from Enterprise Architect, you can do so using either OLE DB or ODBC; if you intent to use ODBC, after creating the Oracle data repository you set up the Oracle ODBC driver.

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.

Notes

• This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions
• With Windows 7 the OLE/ODBC connection is set using the 32 bit ODBC driver, installed using C:\Windows\SysWOW64\odbcad32.exe; the connection can be set using either ODBC or OLE
• If you intend to connect via the OLE connection, download the 32-bit ODBC driver from here
• Set the collation to the alphabet you use, such as Latin or Cyrillic

Learn more

• Create a project in an Oracle database
• Registered User's Scripts page
• Trial User's Scripts Page
• Set up an Oracle ODBC Driver
• Connect to an Oracle Data Repository (ODBC)
• Connect to an Oracle Data Repository (OLE DB)