Configure an Oracle database connection

Use the procedure in this topic to configure an oracle database connection.

Before you begin

Before you can configure an Oracle database connection, verify that the following steps are complete:

  • Oracle .NET driver is installed. For more information on installing this driver, refer to the Tungsten TotalAgility Installation Guide

    If this driver is not installed, you are warned and you cannot add an Oracle database. If you upgrade or install the Oracle drivers, restart your server for the changes to take effect.

    You can configure an Oracle connection that connects to a table, view, or a private synonym.

    Limits:

    Synonyms have the following limitations:

    • Only private synonyms are supported.

    • Synonyms are supported for the following objects only:

      • Table

      • View

  • You have already created a connection to a relational database.

Procedure
  1. On the Configure Oracle Connection window, configure the following settings.

    Setting

    Description

    Oracle Server/TNS

    Enter the name and TNS (Transport Network Substrate), or IP address and TNS of an Oracle server.

    User Name / Password

    Enter the user name and password for the Oracle account.

    Connection String

    This string shows the connection to the database and is defined by the other settings in this window. If you have specified a password, it is fully encrypted and cannot be viewed. You can edit the connection string as needed. If you change any of the settings in the window, a new string is generated and overwrites any changes you made.

  2. Select Test Connection to verify the connection works.
  3. Select OK.

    If the connection works, the Configure Oracle Connection window closes. If the connection fails, an error is displayed and the Configure Oracle Connection window remains open until the connection works.

    If you are unable to get the connection to work, select Cancel to close the window without saving the changes.

  4. Optional. Select OK to close the Project Settings window.
  5. Save the changes to your project.