Teradata

The recommended connector library is teradatasqlalchemy.

The connection string for Teradata looks like this:

  1. teradata://{user}:{password}@{host}

ODBC Driver

There’s also an older connector named sqlalchemy-teradata that requires the installation of ODBC drivers. The Teradata ODBC Drivers are available here: https://downloads.teradata.com/download/connectivity/odbc-driver/linux

Here are the required environment variables:

  1. export ODBCINI=/.../teradata/client/ODBC_64/odbc.ini
  2. export ODBCINST=/.../teradata/client/ODBC_64/odbcinst.ini

We recommend using the first library because of the lack of requirement around ODBC drivers and because it’s more regularly updated.