Topics
Prev Next

Create a Project in an Oracle Database

To create a project in a repository on Oracle 9i, 10g, 11g or 12c, you work through these stages:

  • Stage 1: Create an empty database repository and set up the data tables
  • Stage 2: Connect to the Oracle repository; 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
  • Stage 3: Perform a project integrity check on the project file you are using as a base (optional, but recommended)
  • Stage 4: Transfer the data
  • Stage 5: Connect to the repository to open the project

Prerequisites

  • A machine with Oracle 9i, 10g or 11 g installed and running
  • Oracle Client installed on the client machine, please ensure that the OLE/DB drivers are installed

Create Database Repository

Step

Action

See also

1

Create the empty database.

Create an Oracle Data Repository

2

Load the EASchema_1220_Oracle.sql file from the Sparx Systems website into your SQL management console of choice (such as Oracle SQL Developer).

Registered User's Scripts page Trial User's Scripts Page

3

Run the script to create the required database schema.

Perform Project Integrity Check

Step

Action

See also

1

Open the file-based project or template.

2

Select and execute the 'Configure > Model > Check Integrity > Project Integrity' ribbon option.

This ensures your project data is 'clean' before uploading.

Project Integrity Check

Transfer the project data to the repository

Step

Action

See also

1

Open Enterprise Architect.

(If the 'Open Project' dialog displays, click on the Cancel button to open with no project loaded.)

2

Select the 'Configure > Model > Transfer > Project Transfer' ribbon option.

The 'Project Transfer' dialog displays.

3

In the 'Transfer Type' panel, select 'File to DBMS'.

4

At the right of the 'Source Project' field, click on the button and browse for the name of the project file to copy to Oracle.

If the file has Replication enabled, this must be removed before performing the transfer.

Remove Replication

5

At the right of the 'Target Project' field, click on the button.

The 'Datalink Properties' dialog displays.

6

Select 'Oracle Provider for OLE DB' from the list.

Click on the Next button.

7

On the 'Connection' page of the 'Datalink Properties' dialog, enter the Oracle service name in the 'Data Source' field, and the user name and password as required.

Click on the OK button. The 'Project Transfer' dialog redisplays.

8

If required, select the 'Logfile' checkbox and type a path and filename for the data transfer log file.

9

Click on the Transfer button to begin the data transfer process.

10

When the process is complete, you have created a project on a Oracle database and can now connect to it and open it from Enterprise Architect.

Connect to an Oracle Data Repository (OLE DB)

Notes

  • When transferring a project to Oracle you must have access rights to execute the CREATE SEQUENCE command

Learn more