Connect To Oracle Via 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.
  1. Click on the Test Connection button and enter the Oracle user password to confirm that the details are correct.
  2. Click on the OK button to complete the ODBC connection.

Connect To Repository

  1. In the Open Project dialog, select the Connect to Server checkbox or, on the Start Page, click on the Connect to Server link.
  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. Select the Data Source name from the drop-down list, and type in the database User Name and Password.
  6. Click on the Test Connection button to confirm that the details are correct.
  7. If your test did not succeed, revise your settings. If your test succeeded, click on the OK button; Oracle prompts you for the password.
  8. Enter the password and click on the OK button; the Connection Name & Type dialog displays. Complete the connection process as described in the Define Connection Name and Type procedure.