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

Prev Next

Connect to an Oracle Repository (OLE DB)

To access your Oracle repository, you must provide the connection details to Enterprise Architect.


  • Oracle Client already installed on the client machine; please ensure that the OLE/DB drivers are installed (you can download the drivers from the Oracle Technology Network web site, as part of the Oracle Data Access Components (ODAC) package -  see Learn more)
  • The Oracle repository and the project already exist
  • You have SELECT, UPDATE, INSERT and DELETE access permissions



Project list: Open Project

Keyboard Shortcuts


Connect to an Oracle Repository using OLE DB




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


Click on the Browse. button.

The 'Data Link Properties' dialog displays.


Select 'Oracle Provider for OLE DB' from the list.

Do not select 'Microsoft OLE DB Provider for Oracle'; Enterprise Architect might not work as expected.


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 (the service name of the Oracle database).


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; 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.


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.


If required, select the 'Use WAN Optimization' checkbox.

Note: this option is only included for historical reasons, the WAN Optimizer product has been replaced by the vastly improved Pro Cloud Server.

The WAN Optimizer was originally created to improve performance over a Wide Area Network by compressing all database requests from Enterprise Architect to reducing transfer times.

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


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


In the 'Port' field, type the number of the Port on which the server is running on the remote machine.


Click on the OK button to complete the configuration and open the project.

This also adds the project name to the 'Recent' list on the Start Page; from now on, you can open the project again just by clicking on this name.


  • This feature is available in the Corporate, Unified and Ultimate Editions of Enterprise Architect

Learn more