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.
  Remarque

  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

• ODBC Driver for Teradata® User Guide

Remarque

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.