SQL Scripts Oracle 9i, 10g and 11g

Before Enterprise Architect can be configured to use Oracle as a Repository the following Software Components must be installed and configured:

  • MDAC 2.6, 2.7 or 2.8 (MDAC 2.8 is pre-installed with Windows XP)
  • Oracle
  • Oracle provider for OLE DB.

Note: You cannot transfer a source .EAP file of a version earlier than 3.5.0

Once these preconditions have been met, the following process should be used to create the Enterprise Architect Oracle repository.

Stage one: Create and configure a database

  1. Create an empty database.
  2. Using a tool such as the SQL*Plus or SQL Plus Worksheet, load the Oracle_EASchema.sql file, ensuring that the new database is selected as the current database.
  3. Run the script to create all of the required data structures.
  4. With the empty database you can now use the data transfer tool to transfer an existing model to the server. Before doing so however, you should run the Project Integrity tool, to ensure the data is 'clean' before uploading. You can do this by opening the existing model in Enterprise Architect and selecting Tools | Data Management | Project Integrity Check.
  5. You now have an empty database and can use the data transfer tool to transfer an existing model to the server.

Stage two: Transfer the data

Note: When transferring a project, you must have permission to execute the CREATE SEQUENCE command.

  1. Open Enterprise Architect and select Tools | Data Management | Project Transfer.
  2. In the Transfer Type panel, select .EAP to DBMS.
  3. In the Source Project field, enter the .EAP file to transfer into the Oracle repository.
  4. In the Target Project field, click the […] (browse) button. The Data Link Properties dialog displays.
  5. Select the Oracle Provider for OLE DB. Then click on the Next button.
  6. On the Connection page of the Data Link Properties dialog, enter the Oracle service name in the Data Source field, and the user name and password as required.
  7. Click on the OK button.
  8. If required, on the Project Transfer dialog, select the Logfile checkbox and type a path and file name for the data transfer log file.
  9. Click on the Transfer button to begin the data transfer process.
  10. Once this process completes, the contents of the .EAP model now exists on the Oracle repository. The repository can be opened from Enterprise Architect, using the "Connect to Server" option.