Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Oracle Data Repository (ODBC)

This topic explains how to connect to an Oracle 9i, 10g or 11g data repository in Enterprise Architect using an Oracle ODBC driver.

You can also connect to the Oracle repository using OLE DB.

Access:    File | Open Project   ( Ctrl+O )

Use to:

  • Connect to the data repository so that you can open a project held in the repository

Prerequisites:

  • Create an Oracle Repository
  • Set up an Oracle ODBC driver

How to:

Step

Action

1

In the Open Project dialog, select the Connect to Server checkbox

2

Click on the (  ...  )  (Browse) button

The Data Link Properties dialog displays

3

Select Microsoft OLE DB Provider for ODBC Drivers from the list

4

Click on the Next>> button

The Connection tab displays

5

In the Data source field, click on the drop-down arrow and select the data source name

6

Type in the User name and Password

7

Click on the Test Connection button to confirm that the details are correct

8

If the test does not succeed, revise your settings

If the test succeeds, click on the OK button; Oracle prompts you for the password

9

Type in the password

The Connection Name and Type dialog displays

10

Give the connection a suitable name so that you can recognize it in the Recent Projects panel on the Open Project dialog

11

If required, select the Encrypt Connection String checkbox

This encrypts and hides the connection details of the database from the users that the connection string is given to

12

If required, select the Lazy Load checkbox to not load the full project view when the model is loaded; instead, only the parts that are necessary to display the visible portion of the tree are loaded

With this setting, the model loads faster and users can begin work sooner, but at the expense of later small delays as Enterprise Architect loads specific portions of the model

13

If required, select the Use WAN Optimization checkbox

To improve performance over a Wide Area Network, remote database calls can be routed through a WAN Optimizer that compresses the data returned from the repository, reducing transfer time

If you select this checkbox, complete the next two fields (see your administrator for the correct values); otherwise go to step 16

14

In the Server field, type the network name or address of the optimizer server

15

In the Port field, type the port on which the server is running on the remote machine

16

Click on the OK button to complete the configuration

Notes:

  • This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions

Learn More: