ETL vendor products can be used with Teradata PT to generate scripts for load operations or to make API calls:
- Extract, Transform, and Load (ETL) vendors add value by performing:
- Data extractions and transformations prior to loading the database. Teradata PT provides the ability to condition, condense, and filter data from multiple sources through the Teradata PT SELECT statement.
- Data extractions and loading, but leaving all the complex SQL processing of data to occur inside the database itself. Like ETL vendors, Teradata PT can condition, condense, and filter data from multiple sources into files.
- The Teradata PT API provides additional advantages for third-party ETL/ELT vendors. For more information, see Teradata® Tools and Utilities Access Module Programmer Guide, B035-2424.