Skip to main content

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

Note

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.

Also of interest