Connect to Teradata from ArcGIS

You can connect to Teradata from ArcGIS clients. To do so, 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 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 (such as ArcMap), 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 you install the files, configure an ODBC data source name and create a connection file. When connecting from an ArcGIS Server site, register the database connection file with the site.

Connect from ArcMap

To connect from ArcMap to Teradata, install the Teradata client files on each ArcMap machine, configure an ODBC data source name, and create a connection file.

Install Teradata files and configure the ODBC driver

1. Download the 32-bit Teradata client files from the Teradata website.
2. Install the Teradata ICU library and GSS client on each ArcMap machine.
3. Install the Teradata ODBC driver on each ArcMap machine.
4. Configure the ODBC driver by changing the following settings in the Teradata ODBC Driver Options dialog box:
   1. Set the session mode to Teradata.
   2. Select the option to Use Native Large Object Support.
   3. Select the option to Return Output Parameters As ResultSet
5. Optionally, you can configure an ODBC data source name to use when you connect to the database.

   If you configure an ODBC data source name, use the same name for all Teradata ODBC clients you configure for that same database. For example, use the same data source name for the Teradata ODBC driver on all your ArcGIS Desktop machine as you use on your ArcGIS Server sites. 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.

6. Set the PATH environment variable to the directory where the Teradata ODBC driver is installed.

Connect to the database

Add a database connection using the Database Connection dialog box or Create Database Connection tool. The following steps describe using the Database Connection dialog box.

1. Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.
2. Choose Teradata from the Database Platform drop-down list.
3. In the Data source text box, type the data source name you configured for the ODBC driver. If you did not configure an ODBC data source name, type the IP address of the Teradata server. The syntax is as follows:

   dbcName=<IP address>

   For example, if the server has an IPV4 address of 200.30.200.10, type dbcName=200.30.200.10. If the server has an IPV6 address, enclose the address in brackets. For example, for a server with an IPV6 address of 3020:12z3:y4xw:5099:0:v678:u111:ts22, type dbcName=[3020:12z3:y4xw:5099:0:v678:u111:ts22].

4. Choose Database authentication for the Authentication Type.
5. Provide a valid user name and password in the User name and Password text boxes, respectively.
6. Uncheck Save user name and password if you prefer not to save your login information as part of the connection; doing this can help maintain the security of the database. However, if you do this, you will be prompted to provide a user name and password every time you connect. Also note that Save user name and password must be checked for connection files that provide ArcGIS services with access to the database, or if you want to use the Catalog search to locate data accessed through this connection file.
7. Click OK to connect.

A file is created in \\<computer_name>\Users\<user_name>\AppData\Roaming\ESRI\Desktop<release#>\ArcCatalog.

You can move the connection to another location; just be sure users and applications that need to make a connection have read access to the directory where you place the connection file.

If you use the data from this connection as the source for a service, such as a geoprocessing or geocoding service, you may need to place the connection file in a shared location on your network. See Make your data accessible to ArcGIS Server for more information about sharing a connection file.

Connect from ArcGIS Server

You can publish map services that contain data from Teradata. To do this, install the Teradata client files on each machine in your ArcGIS Server sites, configure an ODBC data source name, create a connection file that connects to the database, and use it to register the database with the ArcGIS Server sites. If ArcGIS Server is running on Linux, you also need to configure the init_user_param.sh file to use the Teradata ODBC driver.

Install Teradata files and configure the ODBC 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.

   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.

4. 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
5. If you are connecting from an ArcGIS Server site on Linux, do the following:
   1. Be sure a Linux ODBC driver manager is installed on each machine in the ArcGIS Server site.
   2. Place the Teradata ODBC connection files in the ArcGIS Server account's $HOME directory on each machine in the site. The files must be named .odbc.ini and .odbcinst.ini.

   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. Optionally, you can configure an ODBC data source name to use when you connect to the database.

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

7. If you are connecting from an ArcGIS Server site on Windows, set the PATH environment variable to the directory where the Teradata ODBC driver is installed. Do this on each machine in the site.

Alter the init_user_param.sh script (Linux only)

Once you have installed 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.

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>/client/14.00/odbc_64/lib/libodbc.so
   #export TDDIR=<Teradata_InstallDir>/client/14.00/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. After you have configured the init_user_param.sh on each machine in your ArcGIS Server site, run the startserver.sh script to restart ArcGIS Server.

   ./startserver.sh

Register the database

If you want your map services to use the data in your Teradata database rather than using a copy of the data created at the time of publishing, register Teradata with your ArcGIS Server sites. See Register a Teradata data warehouse appliance with ArcGIS Server in the ArcGIS Server help for instructions.