Teradata ODBC for Unix OS

To connection between unix machine with teradata environment is needed to install ODBC Driver and some others components (dependencies). All Items can be found in Teradata Downloads site: https://downloads.teradata.com/

Teradata OBDC Driver has 3 dependecies:

1. Shared common components for Internationalization (TDICU)
2. Teradata GSS client package (TeraGSS)
3. Teradata Tools and Utilities Base (TTU)

After download all items, run as root: rpm -ivh “component_name” –nodeps

Eg: rpm -ivh teragss1510-15.10.02.06-1.noarch.rpm --nodeps

Use “–nodeps” only to not need to install in order

All items installed, configure connections in file odbc.ini

cd /opt/teradata
find . -iname odbc.ini

Configure all files you have found, with information of your teradata environment.

If you need to connect your Middleware using JDBC, just download and install the Teradata JDBC driver, to install this component you just need to unzip or untar the downloaded file and move the JAR file to the lib folder in Middleware, and don’t forget to add the path of the lib folder in the user’s PATH.

Advertisements

One thought on “Teradata ODBC for Unix OS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s