Use Vantage with ODBC on Ubuntu
Overview
This how-to demonstrates how to use the ODBC driver with Teradata Vantage on Ubuntu.
Prerequisites
- Access to a Teradata Vantage instance.
Note
If you need a test instance of Vantage, you can provision one for free at https://clearscape.teradata.com
- Root access to a Ubuntu machine.
Installation
- Install dependencies:
- Install Teradata ODBC driver for Ubuntu:
- Configure ODBC, by creating file
/etc/odbcinst.ini
with the following content:
Use ODBC
We will validate the installation with a sample Python application. Create test.py
file with the following content.
Replace DBCName=192.168.86.33;UID=dbc;PWD=dbc
with the IP address of your Teradata Vantage instance, username and password:
Run the test application:
You should get output similar to:
Summary
This how-to demonstrated how to use ODBC with Teradata Vantage on Ubuntu. The how-to shows how to install the ODBC Teradata driver and the dependencies. It then shows how to configure ODBC and validate connectivity with a simple Python application.
Further reading
If you have any questions or need further assistance, please visit our community forum where you can get support and interact with other community members.