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

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

Posted on 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

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.


Comments are disabled in preview mode.

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation