dwhwrapper - cli wrapper for Teradata data warehouse utilities (BTEQ,etc..)

Third Party Software
Enthusiast

dwhwrapper - cli wrapper for Teradata data warehouse utilities (BTEQ,etc..)

Hi All

We wanted to share a python tool we've developed recently which provides a cli to teradata bteq and other utilities to allow:

* easy execution of scripts/SQL queries from the command line

* download to csv (and binary) format without third-party conversion tools

* upload from csv (and binary) format without third-party conversion tools

The full package and more details are available at the following site https://github.com/xlfe/dwhwrapper

Requires: python 2.6, Teradata linux_cliv2, Teradata BTEQ

Optional: Teradata fastexp, fastld and mload

Tested using Teradata utilities version 13

2 REPLIES
Enthusiast

Re: dwhwrapper - cli wrapper for Teradata data warehouse utilities (BTEQ,etc..)

Thanks Felix,

I'll love to take a look.  I'm doing some things at the moment with Teradata and Python, but using pyodbc to connect.  

Enthusiast

Re: dwhwrapper - cli wrapper for Teradata data warehouse utilities (BTEQ,etc..)

Hi Felix,

Any plans for a windows version ?  I've started to modify the code but I stopped at the type_mappings ;  not my area of expertise I'm afraid.  I'll have another go at it later.