Set up a connection to Teradata

To use ArcGIS with a Teradata database, you must install the following on the ArcGIS client machine:

NoteNote:

The Teradata ICU library and GSS client must be installed before you install the Teradata ODBC driver.

Teradata ODBC drivers can be downloaded from the Teradata website. The downloadable files include the Teradata GSS client and ICU library.

NoteNote:

If you are connecting from a 32-bit ArcGIS client, you must install 32-bit Teradata files. If you are connecting from a 64-bit ArcGIS client, you must install 64-bit Teradata files.

After the files are installed, configure an ODBC data source name.

Steps:
  1. Install the Teradata ICU library and GSS client on the ArcGIS client machine.
  2. Install the Teradata ODBC driver on the ArcGIS client machine.
  3. Configure the ODBC driver.
    • On Windows operating systems, change the following settings in the set the Teradata ODBC Driver Options dialog box:
      • Set the session mode to Teradata.
      • Select the option to Use Native Large Object Support.
    • On Linux operating systems, set the following parameters in the odbc.ini file:
      • SessionMode=Teradata
      • UseNativeLOBSupport=Yes
  4. If you are connecting from ArcGIS for Server Linux, do the following:
    1. Open the init_user_param.sh script found in the /arcgis/server/usr directory of the ArcGIS Server installation directory.
    2. Uncomment and set the LIB_ODBC_DRIVER_MANAGER, TDDIR, LD_LIBRARY_PATH, and ODBCINI variables under the Teradata section.

      For example, to set the LIB_ODBC_DRIVER_MANAGER variable to the location of the libodbc.so file from the installation location of the Teradata driver, set export LIB_ODBC_DRIVER_MANAGER=/OPT/TERADATA/LIBODBC.SO.2.0.0.

    3. Place the Teradata ODBC connection files in the ArcGIS Server account's $HOME directory. The files must be named .odbc.ini and .odbcinst.ini.
    4. If ArcGIS Server was already running before you set up the Teradata connection, restart ArcGIS Server.
    NoteNote:

    The Teradata ODBC driver only works with the particular version of the Progress DataDirect ODBC Driver Manager that is shipped along with the Teradata ODBC driver package.

  5. After the ODBC driver is installed, set up an ODBC data source name.

    The ODBC data source name is used when connecting to the database from ArcGIS.

    Use the same name when configuring all Teradata ODBC clients that connect to that same database. For example, if you configure a data source name for the Teradata ODBC driver on your ArcGIS for Desktop machine, set the same data source name for the Teradata ODBC driver on your ArcGIS Server machine. If you do not do this, registration of the database with ArcGIS Server will not work properly, as it compares the connection strings of the data being published and the database that is registered.

Related Topics

2/5/2015