@ofajardo: As noted in other posts, the eventual goal for teradatasql is feature parity with the JDBC driver. Yes, that's a work in progress; but a lot of core functionality is in place already that makes the driver suitable for many applications in place of ODBC (e.g. via pyodbc or the "teradata" Python package).
ANSI mode is now supported, for example, though at the moment only with autocommit off.
Auto-commit is the next feature that we plan to ship for the teradatasql package.
Edit July 31, 2019 -- teradatasql 220.127.116.11 is now available and contains auto-commit and transaction management.
Teradata JDBC Driver development began back in 1998, so it has been in development for over 20 years.
I expect it will take a few years for the teradatasql package to achieve feature parity with the Teradata JDBC Driver.
We are using the Teradata Python module to connect our application to Teradata, and everything works well. However, we are wondering if this module protects against SQL injection attacks, specifically when using parametrized functions.
E.g., when passing parameters using the ? syntax as explained here:
Are these parameters cleaned?
Thanks in advance for your reply!
One newbie question, does the Teradata Python Module (aka teradataml nowadays) work with Teradata Express VM installations? Is it the same with Teradata Pyhon Package (described at https://docs.teradata.com/reader/GsM0pYRZl5Plqjdf9ixmdA/MzdO1q_t80M47qY5lyImOA). Thanks a lot.
The "Teradata Python Package" (teradataml) builds on the earlier "Teradata SQL Driver Dialect for SQLAlchemy" (teradatasqlalchemy) and "Teradata SQL Driver for Python" (teradatasql) packages. They all "work" with Teradata Express, but recognize that (since Express does not include MLE) only a subset of teradataml analytics classes can be used successfully.
Thanks Fred, I alfready understood this but I suggest then to the marketing department of Teradata to change the advert from this page:
from "Try the free Developer Tier to see how Teradata Vantage on VMware works with your private cloud environment."
to "Try the free Developer Tier to see how Teradata Database on VMware works with your private cloud environment."
otherwise being somehow misleading since there is NO version of Teradata Vantage available on Vmware, be it Express or Cevelopment Tier...:(((