Home Services Partners Company
Teradata Parallel Transporter load/extract from SQL Server, Oracle, DB2, Sybase

Teradata Parallel Transporter load/extract from SQL Server, Oracle, DB2, Sybase

August 24, 2011 0 Comments

I have consulted on several projects to load critical data into the Teradata Data Warehouse from heterogeneous data sources.  These include SQL Server, Oracle, DB2, and Sybase using Progress DataDirect Connect drivers with the Teradata Parallel Transporter (TPT) ODBC operator.  These organizations were capitalizing on their Teradata Data Warehouse investment, and you can hear other TPT success stories at Teradata Partner's Conferences.

What is Teradata Parallel Transporter?

  • TPT is a flexible and high performance load/unload tool for the Teradata Database that supports ODBC source operators.
  • TPT efficiently transports vast amounts of data using core data warehousing fundamentals of parallelism and scalability.
  • From Teradata's website, "Unlike conventional utilities and products in which multiple data sources are usually processed in a serial manner, Teradata Parallel Transporter can access multiple data sources in parallel. This ability can lead to increased throughput. Teradata Parallel Transporter also allows different specifications for different data sources and, if their data is UNION-compatible, merges them together."

Teradata Parallel Transporter with DataDirect Connect

When to use the Teradata Parallel Transporter ODBC operator?

  • When extracting large amounts of data from external non-Teradata databases.
  • ODBC operator is recommended when running TPT scripts and utilities without requirement for a third party ETL/ELT adapter.  TPT does support SQL-like transformations.

Why choose Progress DataDirect to power the Teradata PT?

How much data can I move using Progress DataDirect + TPT?

  • Disclaimer: The answer to this may vary significantly from environment to environment.  Recently, I worked with a Teradata shop running TPT on AIX, and throughput from an Oracle extract was 6 GB/hour using DataDirect Connect for ODBC Oracle Wire Protocol driver.  The project required additional throughput to be a feasible solution.   In working with myself and Teradata, we were able to achieve 30 GB/hour throughput by tuning the ODBC driver, and using parallel processing of the ODBC extract operators.  For additional information, you can read about TPT in the Users, Reference and Programmers guides from Teradata.

Get connected in 15 minutes from your TPT server

1. Download a free DataDirect Connect for ODBC trial to connect an unlimited number of  TPT ODBC producer operators.

2. Test connect using our quick start guide from the Evaluation Help Center.

3. Call us today at 1-800-876-3101 to speak with a live Solutions Consultant to learn how other Teradata shops are making progress with TPT and DataDirect Connect.

Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Read next SAS ODBC Access to Salesforce, SQL Server and Marketo
Comments
Comments are disabled in preview mode.