cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Teradata to Cloud Data warehouse : Teradata to Azure SQL Data Warehouse

pkona
Former Employee

Teradata TPT FastExport Snap enables one to export large amounts of data out of Teradata very efficiently.

On the target side if you are moving data into the Azure SQL Data warehouse, use the Azure polybase bulkload. If you were to move data to Redshift, then use the Redshift Bulkload Snap.

image

Below is an example how you can configure the Teradata TPT fast export snap. The prerequisite is that you need to install the Teradata TPT utilities on every node of your Snaplex.

image

Snaps Used: TPT FastExport, File Reader, CSV Formatter, CSV Formatter, Pipeline Execute, Azure Polybase Bulkload

Download

Teradata to Azure SQL Data Warehouse_2018_06_25.slp (10.0 KB)
This pattern also calls the Pattern described in Reference Pipeline : To get schema details for a Teradata Table

0 REPLIES 0