Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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: 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
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 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 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 The 'Datalink Properties' dialog displays. |
|
6 |
Select 'Oracle Provider for OLE DB' from the list. Click on the . |
|
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 . 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 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
Learn more