使用SSIS作为Teradata的ETL工具,而不是像Informatica等其他工具 [英] Using SSIS as ETL Tool for Teradata instead of other tools like Informatica etc
问题描述
我想知道我是否可以使用SSIS连接到Teradata数据库并执行类似的ETL和SQL DB一样吗?
Informatica,Ab Initio中有一些工具,它们是Teradata的标准ETL工具。但SSIS工具箱可以用来处理Teradata吗?
与此相关的利弊是什么?
非常感谢您的反馈!
是的,你可以,但你只需要安装一个连接器
我建议你按照这篇不错的博客文章
http://kosmisch.net/Blog/DataAndBusinessIntelligence/Archive /2015/5/31/create-etl-project-with-teradata-through-ssis.html
Hi,
I would like to know if I can connect to Teradata DBs using SSIS and perform ETL in the similar way as I do with SQL DBs ?
There are tools in Informatica, Ab Initio which are standard ETL tools for Teradata. But can SSIS Toolbox be used to work with Teradata ?
What are the pros and cons linked to this?
Thanks a lot for your feedbacks!
Hi,
Yes, you can, but you just need to install a connector
I suggest you follow this nice blog post http://kosmisch.net/Blog/DataAndBusinessIntelligence/Archive/2015/5/31/create-etl-project-with-teradata-through-ssis.html
It explains in just enough details how to get there, good luck!
这篇关于使用SSIS作为Teradata的ETL工具,而不是像Informatica等其他工具的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!