Database Types for Teradata
tdtypes is a Python library built atop DB API compliant library that provides abstraction layer for Teradata Database objects and utilities.
NOTES:
The latest version of the Python3 series is recommended. Python2 series is no longer supported.
tdtypes can work with either teradata (preferred) or pyodbc. Either of these packages must be installed.
Use Python's pip
utility to install tdtypes
.
$ python -m pip install -U tdtypes[teradata]
or
$ python -m pip install -U tdtypes[pyodbc]
No configuration is required except setting up the needed ODBC connections.
tdtypes provides an easy way to accept a valid ODBC connection string from the command line. If more flexibility is needed, for example, to use Teradata REST interface instead of ODBC, or automatically retrieve database connection information, create tdconn_site.py module and place it in your PYTHONPATH
. The module must define two functions dbconn_args()
and dbconnect()
. Have a look at the default definitions of these functions in tdconn_default.py module to get an idea about the parameters and return values.
If you encounter an issue, report it using issue tracker. I'll try to provide a fix as soon as I can. If you already have a fix, send me a pull request.
Feel free to fork this repository and enhance it in a way you see fit. If you think your changes will benefit more people, send me a pull request.