Oracle Data Repository

In order to use an Oracle 9i, 10g or 11g data repository, you must connect to it in Enterprise Architect first. You can connect using either OLE DB or ODBC.

Using Oracle OLE DB Provider

To connect to your Oracle data repository using the Oracle OLE DB Provider, 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.
    
   
    
3. Select Oracle Provider for OLE DB from the list.

4. Click on the Next button. The Connection tab displays.
    
   
    
5. Enter the Data Source name (the service name of the Oracle database), the database User Name and the Password. The Location field is not required.
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 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. This means that a 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.

Using Oracle ODBC Driver

This process has two stages:

• Create ODBC Driver connection in Windows
• Connect to Repository in Enterprise Architect.

Create ODBC Driver Connection

1. Select the WindowsTM Control Panel | Administrative Tools | Data Sources (ODBC) option. The ODBC Data Source Administrator window displays.
    
   
    
2. Click on the Add button. The Create New Data Source dialog displays, enabling you to add a new DSN.
    
   
    
3. Select Oracle in OraDB11g_home1 (or similar, depending on the ODBC installation).
4. Click on the Finish button. The Oracle ODBC Driver Configuration dialog displays.
    
   
    
5. Enter the following configuration details:

• A data source name for the connection
• A description (optional)
• The TNS Service Name (click on the drop-down arrow and select from the list)
• The User ID.

6. Click on the Test Connection button and enter the Oracle user password to confirm that the details are correct.
7. Click on the OK button to complete the ODBC connection.

Connect To Repository

1. In Enterprise Architect, select the File | Open Project menu option. The Open Project dialog displays.
    
   
    
2. Select the Connect to Server checkbox.
3. 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.
    
   
    
4. Select Microsoft OLE DB Provider for ODBC Drivers from the list.
5. Click on the Next button. The Connection tab displays.
    
   
    
6. Select the Data Source name from the drop-down list, and type in the database User Name and Password.
7. Click on the Test Connection button to confirm that the details are correct.
8. If your test succeeded, click on the OK button; if your test did not succeed, revise your settings.
9. After you have clicked on the OK button, Oracle prompts you for the password. Enter this. 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. This means that a 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.