Topic
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: Set up the ODBC Driver (if required; you can connect to an Oracle repository using either OLE DB or an ODBC driver; if you intend to connect through the ODBC driver, you must first set it up)
  • 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 both the ODBC and 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

managmenet console of choice (ie Oracle SQL Developer)

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

3

Run the script to create the required database schema.

Set Up the ODBC DSN

Step

Action

See also

1

Create a suitable ODBC Data Source to point to your new database.

Set up an Oracle ODBC Driver

Perform Project Integrity Check

Step

Action

See also

1

Open the file-based project or template.

2

Select and run 'Project | Data Management | Project Integrity Check'.

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 'Project | Data Management | Project Transfer' menu option.

The 'Project Transfer' dialog displays.

3

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

4

In the 'Source Project' field, type the name of the project file to copy to Oracle.

If the .EAP 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) Connect to an Oracle Data Repository (ODBC)

Notes

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

Learn more