Skip to main content

Connect to Teradata from ArcGIS

To connect to Teradata from ArcGIS clients, install the following on the ArcGIS client machines:

  • 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 file to install the Teradata client on Microsoft Windows machines, 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.

Next, create a connection file. To publish ArcGIS Server web services that reference data in Teradata, register the database connection file with your ArcGIS Server sites.

Install Teradata files and configure the ODBC driver

Complete the following steps to install the files and configure the driver:

  1. Download the 64-bit Teradata client files from the Teradata website.

  2. Install the Teradata ICU library and GSS client on each machine in your ArcGIS Server site.

  3. Install the Teradata ODBC driver on each machine in your ArcGIS Server site.

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.

  1. Configure the ODBC driver.

Change the session mode setting on the Teradata ODBC Driver Options dialog box to Teradata.

Set the SessionMode parameter in the odbc.ini file to Teradata. The entry will look like the following: SessionMode=Teradata.

  1. Set the PATH environment variable to the directory where the Teradata ODBC driver is installed. Do this on each machine in the site.

Create a database connection

You must have a database connection (.sde file) that authenticates the connection to the database. To use the database connection file with ArcGIS Server, you must save user information with the connection file.

You can call the ArcPy CreateDatabaseConnection function from one of the machines in the ArcGIS Server site that needs to connect to the database. See Create Database Connection in the ArcGIS Pro help for information about running this function.

Edit the init_user_param.sh script

After you install the database client files, alter the init_user_param.sh script installed with ArcGIS Server to reference the client files. You can access this script by browsing to the <ArcGIS Server installation directory>/arcgis/server/usr directory.

You must update the init_user_param.sh on every machine in the ArcGIS Server site.

  1. Ensure that the ArcGIS Server installation owner on each machine has at least read and execute permissions on the database client libraries.

  2. Open the init_user_param.sh script in a text editor.

  3. Remove the comment marks (#) from the lines beginning with export.

    # -----------------------------------------------------------------------
# Modify this section to configure a connection to Teradata.
#
# To make a connection, name the Teradata ODBC configuration files as
# .odbcinst.ini and .odbc.ini and store them in the ArcGIS Server user $HOME directory.
#
# -------------------------------------------------------------------------------------
export LIB_ODBC_DRIVER_MANAGER=<Teradata_InstallDir>/<version>/14.00/odbc_64/lib/libodbc.so
export TDDIR=<Teradata_InstallDir>/client/<version>/odbc_64
export LD_LIBRARY_PATH=$TDDIR/lib:$LD_LIBRARY_PATH
export ODBCINI=<Location_to_.odbc.ini>/.odbc.ini

  4. Modify values to match information for your ODBC driver installation.

  5. Save and close the script.

  6. For the changes you made in the init_user_param.sh file to take effect, you must restart ArcGIS Server.

    To do this, run the stopserver.sh script, then run the startserver.sh script on each machine in the ArcGIS Server site.

    ./stopserver.sh

    ./startserver.sh

Create a database connection

Create a database connection file using the Database Connection dialog box in ArcGIS Pro, as described above.

Alternatively, you can run the Create Database Connection tool in ArcGIS Pro or use Python to run the Create Database Connection command from an ArcGIS Server machine to create a database connection file (.sde) that connects to the database.

To use the connection file with ArcGIS Server, you must save the user information with the connection file.

Register with ArcGIS Server

To allow map services to use the data in the Teradata database rather than using a copy of the data created at the time of publishing, register Teradata with your ArcGIS Server site.

You can use the database connection file you created to register the database with ArcGIS Server from the Manage registered data stores pane in ArcGIS Pro or from ArcGIS Server Manager.