Connect to an Oracle 9i and 10g Data Repository

Return to Introduction  Previous page  Next page

Note: This feature is available in the Corporate edition only.

In order to use a Oracle 9i and 10g data repository, you must connect to it in Enterprise Architect first.  To connect to your Oracle 9i and 10g data repository in Enterprise Architect, follow the steps below:

1.In the Open Project dialog, select the Connect to Server checkbox.
2.Click on the [...] (Browse) button, as you normally would to browse for a project. As you have selected the Connect to Server checkbox, the Data Link Properties dialog displays instead of the Browse Directories dialog.
 
DataLink-Oracle
 
3.Select Oracle Provider for OLE DB from the list.

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

4.Click on the Next button. The Connection tab displays.
 
DataLink-Oracle-Connection
 
5.Enter the Data Source name, User Name and Password.
6.Click on the Test Connection button to confirm that the details are correct.
7.If your test succeeded, click on the OK button.
8.If your test did not succeed, revise your settings.
9.After you have clicked on the OK button, the Connection Name dialog displays
 
.ConnectionName-Oracle
 
10.Give the connection a suitable name so that you can recognize it in the Recently Opened Projects list on the Open Project dialog.
11.Click on the OK button to complete the configuration.