See the ODBC Driver for Teradata® User Guide, B035-2526 for detailed information on how to use ODBC.
Use the tdxodbc tool to validate the installation of ODBC Driver for Teradata. It is located in the /Library/Application Support/Teradata/client/TTUversion/bin directory.
- Export the ODBCINI environment variable.
export ODBCINI='Library/Application Support/Teradata/ODBC/odbc.ini'
- Run the command to initiate the tool:
tdxodbdc -c SQLDriverConnect -C "DRIVER={driverName};DBCName=databasename;UID=username;PWD=password;" -t
where the following is true:- driverName is the name of the driver currently installed. The driver name has the format "Teradata Database ODBC Driver XX.YY" where XX points to the Major version and YY points to the minor version. For example, if you have the ODBC 20.00 Driver installed. the driverName would be "Teradata Database ODBC Driver 20.00".
- databasename is the name or IP address of the Vantage system.
- username is the Database username
- password is the Database password
If the ODBC Driver for Teradata is installed correctly, the tool displays information that it successfully connected to the database.