How to Configure an Oracle 11g Connection

Available in the Enterprise edition only.
To configure a connection to an Oracle 11g server, follow these steps:
  1. Open the Preferences dialog box (Options > Preferences) and go to Data Sources.
  2. In the Connections panel, click the New button.

    The dialog box for configuring a database connection is displayed.

    Figure: Connection Configuration Dialog Box

  3. Enter a unique name for the connection.
  4. Select the Oracle 11g data source in the Data Source drop-down menu.
  5. Enter the connection details.
    1. Enter the URL of the Oracle server.
    2. Enter the user name for the connection to the Oracle server.
    3. Enter the password for the connection to the Oracle server.
  6. Click the OK button to finish the configuration of the database connection.