Oracle Data Repository (ODBC)

In order to open a project held in an Oracle 9i, 10g or 11g data repository, you first connect to the repository in Enterprise Architect using either:

An Oracle ODBC driver (below) or
OLE DB - see Connect to an Oracle Data Repository (OLE DB)

Access    File | Open Project   ( Ctrl+O )


Create an Oracle Repository
Set up an Oracle ODBC driver

Connect to an Oracle Data Repository using an ODBC Driver



See also


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


Open a Project


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

The Data Link Properties dialog displays.




Select Microsoft OLE DB Provider for ODBC Drivers from the list.


Oracle Data Repository


Click on the Next>> button.

The Connection tab displays.




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




Type in the User name and Password.




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




If the test does not succeed, revise your settings.

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




Type in the password.

The Connection Name and Type dialog displays.




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




If you want to encrypt and hide the connection details of the database from the users that the connection string is given to, select the Encrypt Connection String checkbox.




The Lazy Load facility does not load the full project view when the model is loaded; instead, it loads only the parts that are necessary to display the visible portion of the tree. With this set, 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.

If you want to use the Lazy load facility, select the Lazy Load 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 are using a WAN, and want to apply this facility, select the Use WAN Optimization checkbox; otherwise go to step 16.

If you select this checkbox, complete the next two fields (see your administrator for the correct values).


The WAN Optimizer


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




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




Click on the OK button to complete the configuration.




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

Learn more