5.1.6.3. Teradata ODBC setup

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.1. General Parameters used in many actions > 5.1.6. ODBC Connections >

5.1.6.3. Teradata ODBC setup

 

For your convenience, you can go here to download the latest Teradata ODBC drivers:
 

http://download.timi.eu/ODBC/ODBC_drivers_Teradata/

 

At the same URL, you’ll also find the “FastLoad”  Teradata utility: See the section 5.25.19. to know more about this subject.

 

Inside “ODBC Driver Setup for Teradata Database”,  click on the “Options>>” button:

 

ANATEL~2_img90

 

 

After clicking the “Options >>” button, the “Teradata ODBC Driver Options” window opens:

 

ANATEL~2_img91

 

 
Anatella expects the decimal separator for numbers to be the dot (“.”) whatever the Regional Settings inside the server are. Thus, you need to uncheck the option named “Use Regional Settings for Decimal Symbol”. number1

 

When you click the “Advanced” button number2  in the above window, the “Teradata ODBC Driver Advanced Options” window opens.
 

 

Change the parameter named “Maximum Response Buffer Size” to 65000 (instead of the default value: 8192). This will allow better network performances during communication exchanges between TIMi/Anatella/Stardust and the Teradata database:

 

ANATEL~2_img92

 

 

Here is a typical set of parameters to setup an ODBC Connection String (for a “Type 2 ODBC Connection”) for accessing the content of a Teradata database:

 

ANATEL~2_img93

 
 

At the end, you should get a connection string that is similar to:

 

 

 
DRIVER={Teradata};DBCNAME=192.168.95.129;UID=tduser;PWD=xxx;MaxRespSize=65000;DsnOptions=1000101000000100100000111
 

 

 

Unfortunately, the Wizard running inside Anatella (to contruct the Connection-String) does not set the last 2 parameters (named “MaxRespSize” and “DsnOptions”) to the proper value: i.e. You should manually edit the Connection-String and append at the end:

 

 

 
;MaxRespSize=65000;DsnOptions=1000101000000100100000111
 

 

 

To manually edit the ODBC connection-string, Right-click here with your mouse:
 

ANATEL~2_img94

 

 
After the edition of the Connection-String, you should have something that looks like this:

 

ANATEL~2_img95