Use Vantage with ODBC on Ubuntu


This how-to demonstrates how to use the ODBC driver with Teradata Vantage on Ubuntu.


  • Access to a Teradata Vantage instance.

    If you need a test instance of Vantage, you can provision one for free at
  • Root access to a Ubuntu machine.


  1. Install dependencies:

    apt update && DEBIAN_FRONTEND=noninteractive apt install -y wget unixodbc unixodbc-dev iodbc python3-pip
  2. Install Teradata ODBC driver for Ubuntu:

    wget \
        && tar -xzf tdodbc1710__ubuntu_x8664. \
        && dpkg -i tdodbc1710/tdodbc1710-
  3. Configure ODBC, by creating file /etc/odbcinst.ini with the following content:

    [ODBC Drivers]
    Teradata Database ODBC Driver 17.10=Installed
    [Teradata Database ODBC Driver 17.10]
    Description=Teradata Database ODBC Driver 17.10


We will validate the installation with a sample Python application. Create file with the following content. Replace DBCName=;UID=dbc;PWD=dbc with the IP address of your Teradata Vantage instance, username and password:

import pyodbc


cnxn = pyodbc.connect('DRIVER={Teradata Database ODBC Driver 17.10};DBCName=;UID=dbc;PWD=dbc;')
cursor = cnxn.cursor()

cursor.execute("SELECT CURRENT_DATE")
for row in cursor.fetchall():

Run the test application:


You should get output similar to:

['ODBC Drivers', 'Teradata Database ODBC Driver 17.10']
(, 1, 5), )


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.
Did this page help?