Connect to Teradata

This topic describes how to connect to Teradata from Domino.

Warning

Teradata Vantage is a multi-cloud data platform providing access to data lakes, data warehouses, and analytics. To connect successfully, you must have network connectivity between Teradata and your Domino deployment.

Connect to Teradata with Python

Domino recommends the Teradata SQL Driver for Python.

Environment setup

The Teradata SQL driver for Python comes pre-installed in several Domino environments. If your environment does not have it installed by default, you can use the following dockerfile instructions to add it to your environment:

RUN pip install teradatasql

Credential setup

Set the following Domino environment variables to store secure information about your Teradata connection.

TERADATA_USER
TERADATA_PASSWORD
TERADATA_HOST

See Environment variables for secure credential storage to learn more about Domino environment variables.

Usage

See the Teradata SQL Driver for Python documentation for information about how to use the package. The following is an example.

import teradatasql
import os

con = teradatasql.connect(
    user=os.environ['TERADATA_USER'],
    password=os.environ['TERADATA_PASSWORD'],
    host=os.environ['TERADATA_HOST']
    )
cur = con.cursor()
try:
    cur.execute ('{fn teradata_nativesql}Driver version {fn teradata_driver_version}  Database version {fn teradata_database_version}')
    print (cur.fetchone () [0])
finally:
    cur.close()
con.close()

Additional resources:

Teradata SQL Driver for R: