› Use Transformation Designer › Manage databases › Relational databases › Configure an Oracle database connection

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 the 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

Procedure

  1. If you are creating a new connection, the Configure Oracle Connection is displayed after you complete the Add New Connection window. If you are modifying an existing connection, open the Configure Oracle Connection window by following these steps:
    1. On the Project tab, in the Configuration group, select Project Settings Project Settings icon.
    2. Select the Databases tab to view the databases settings.
    3. Under Relational Connections, select the connection you want to change.
    4. Select Properties.
  2. In the Oracle Server/TNS field, enter the name and TNS (Transport Network Substrate), or IP address and TNS of an Oracle server.
  3. In the Login Information group, enter a User Name and Password if applicable.
  4. Optional. You can review the Connection String field.

    Displays 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.

  5. Select Test Connection to verify the connection works.
  6. 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.

  7. Optional. Select OK to close the Project Settings window.
  8. Save the changes to your project.

More info