Configure an ODBC relational connection

Use the procedure in this topic to configure an ODBC relational connection.

If you use ODBC (Open Database Connectivity), create the DSN (data source name) on the same computer where the Transformation Designer is installed. It also needs to be on any production computer that accesses the ODBC database.

The ODBC 32-bit drivers are supported only. The 32-bit driver is found in the following location:

C:\Windows\SysWOW64\odbcad32.exe.

Ensure that your table or view names do not end with the strings ".txt" or ".csv". This is because these strings are reserved as file extensions and should not be used as part of the name itself.

On the Databases tab, create a connection that is used to link to the ODBC database. When you create a new connection, a window is displayed where you specify the DSN and authentication. You can modify this connection as needed.

Before you begin

Before you can configure a ODBC relational connection, verify that you have already created a connection to a relational database.

Procedure
  1. In the Configure ODBC Connection window, configure the following settings.

    Setting

    Description

    Data source name (DSN)

    This setting provides a list of system and user data source names (DSN) configured on the local computer. If a new DSN is added, select Refresh to update the list.

    The DSNs visible in this list are already present on the local computer. In order for any interaction with this database to work in a production environment, you need to add the same DSN connection on any machine running the Tungsten TotalAgility - Transformation Server, as well as any workstation running a User Interactive Module.

    User Name / Password

    Enter the user name and password for the ODBC user 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 ODBC Connection window closes. If the connection fails, an error is displayed and the Configure ODBC 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.