SSIS with Teradata Connectors
While Teradata provides 32 and 64 bit OleDB providers, there are other 3rd party connectivity providers for Teradata such as ETI and iWay Software. In addition, there are the Microsoft Connectors for Teradata by Attunity.
Teradata tested ETI's Teradata HPCs again 20 million rows of data at their labs in California test labs. The results showed ETI's HPCs were 2.6x - 50x's faster than the Ole DB provider.
- Teradata's website: http://www.teradata.com/t/page/138328/index.html
- ETI's Teradata connector: http://www.eti.com/microsoft/
- iWay's Teradata connector : http://www.iwaysoftware.com/products/adapters/teradata.html
- Microsoft Connector Version 1.2 for Teradata by Attunity: http://www.microsoft.com/en-us/download/details.aspx?id=29284
The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 Integration Services.
- Microsoft Connector Version 2.0 for Teradata by Attunity: http://www.microsoft.com/en-us/download/details.aspx?id=29283
The component is designed to be used with the Enterprise and Developer editions of SQL Server 2012 Integration Services.
Note: This article has been ported over from http://ssis.wik.is/ Note: If you were the owner of above article, please update it to the latest or with other appropriate information.