PyTd icon indicating copy to clipboard operation
PyTd copied to clipboard

Add optional JDBC support

Open fxstein opened this issue 10 years ago • 5 comments

Allow for optional JDBC support when/if the proper JDBC support packages are installed.

There is an active project called JayDeBeApi that is supposed to support Teradata: https://pypi.python.org/pypi/JayDeBeApi/ https://github.com/baztian/jaydebeapi

Might support a smaller subset of functionality, but could be the preferred deployment for many Cloud environments.

fxstein avatar Aug 25 '15 03:08 fxstein

In addition to simplifying deployments without sacrificing performance, JDBC does provide some features that are not available with either ODBC or REST today like support for FastLoad, FastExport, and installing UDFs which would be nice to be able to support from PyTd.

escheie avatar Aug 26 '15 04:08 escheie

@escheie - So to be clear: Is support for efficient export/import of data via PyTd contingent on JDBC support?

nchammas avatar Mar 14 '16 18:03 nchammas

@nchammas - I was simply enumerating some of the benefits to having JDBC support in addition to ODBC and REST, should someone other than myself choose to contribute that functionality.

I'm sure there are other ways to take advantage of FastLoad or FastExport other than JDBC, but I'm not familiar with these APIs. I know the TPT team has had discussions about supporting TPTAPI via Python but no commitments yet that I'm aware.

escheie avatar Mar 15 '16 04:03 escheie

Okie doke. I just ask because I was considering opening an issue to request FastExport support in PyTd until I came across your comments here. It sounds like that's not being considered in the near term.

nchammas avatar Mar 15 '16 14:03 nchammas

JDBC support is awesome!

dclong avatar Nov 16 '17 23:11 dclong