domino logo
Latest (5.7)
  • Get started
  • Tech ecosystem
  • Domino Cloud
  • Develop models
  • Work with data
  • Model governance
  • Deploy models, apps, launchers
  • Model Monitoring
  • Code Assist
  • Security and credentials
  • Organizations
  • Collaborate
  • Projects
  • Workspaces
  • Environments
  • Data planes
  • Executions
  • Additional Resources
  • Domino CLI
  • Troubleshooting
  • Get help
  • Send feedback
domino logo
About Domino
Domino Data LabKnowledge BaseData Science BlogTraining
>
User Guide
>
Work with data
>
Access external data
>
Data Source connectors
>
Connect to Teradata

Connect to Teradata

This topic describes how to connect to Teradata from Domino.

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

The easiest way to connect to Teradata from Domino is to create a Domino data source as described below.

Create a Teradata data source

Administrators can create a data source for Teradata that Domino users can access. Domino recommends this method. See the Admin Guide for details.

After your administrator has created the data source, you can query it as usual.

Note

Next steps

  • Get code snippets for accessing this data source in your workspace.

  • Share this data source with your collaborators.

Alternate way to connect to a Teradata data source

Warning

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 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 for Teradata SQL Driver

Python:

  • Official documentation

  • Repository

  • Package

R:

  • Official documentation

  • Repository

  • Packages

Domino Data Lab
Knowledge Base
Data Science Blog
Training
Copyright © 2022 Domino Data Lab. All rights reserved.