Use Vantage with ODBC on Ubuntu

Author: Adam Tworkiewicz
Last updated: January 5th, 2022


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 new instance of Vantage, you can install a free version called Vantage Express in the cloud on Google Cloud, Azure, and AWS. You can also run Vantage Express on your local machine using VMware, VirtualBox, or UTM.
  • 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.

Did this page help?