Connect to Teradata from ArcGIS

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

• Teradata ICU library
• Teradata GSS client package
• Teradata ODBC driver

Note:

The Teradata ICU library and GSS client must be installed before you install the Teradata ODBC driver. When you run the setup.exe to install the Teradata 15.0 client on Windows, files are installed in the required order.

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

• For Windows, see http://downloads.teradata.com/download/connectivity/odbc-driver/windows.
• For Linux, see http://downloads.teradata.com/download/connectivity/odbc-driver/linux.

Note:

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. When you run the executable to install the client on Windows, both the 64-bit and 32-bit client files are installed on 64-bit operating systems.

It is recommended that you install 32- and 64-bit applications and, consequently, Teradata client files and drivers on separate machines to avoid issues that arise when different versions of the same Teradata client files are installed on the same machine.

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

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 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 connecting from an ArcGIS client on Linux, be sure a Linux ODBC driver manager is installed on the client machine.
5. 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 ODBC driver manager, set export LIB_ODBC_DRIVER_MANAGER=/OPT/TERADATA/LIBODBC.SO.

   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.

   Note:

   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.

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

7. On Windows, set the PATH environment variable to the directory where the Teradata ODBC driver is installed.