SSIS和Informatica [英] SSIS and Informatica

问题描述

SQL SERVER 2014 SSIS已发布，我们在SQL SERVER 2012 SSIS中已经有了很多功能.有人可以将SSIS 2014/SSIS2012与Informatica Power Center进行比较吗?除了SSIS 2012/2014，Informatica新版本还有哪些其他功能?还是SSIS 2014/20122中有功能，而Informatica中没有这些功能.

SQL SERVER 2014 SSIS has been released,we have already got lot of facilities in SQL SERVER 2012 SSIS.Can anybody compare SSIS 2014/SSIS2012 with Informatica Power center ? What are the additional fetures are there in the Informatica new version than SSIS 2012/2014? Or are there functions in SSIS 2014/20122 ,which are not available in Informatica.

如果我们拥有诸如ssis之类的可靠有效的工具，我仍然不明白为什么客户会在诸如Informatica之类的非常昂贵的工具上进行投资. 专家请对此进行讨论

I still can not understand why clients are investing in very expensive tools like Informatica,If we have reliable and effective tool like ssis. Experts Please have a discussion on this

推荐答案

这将花费一些时间来命名所有差异.乍一看，这些产品非常相似，但我将尝试列举一些可以区分它们的功能. (我已经多年没有使用SSIS了，所以请随时列举我犯的任何错误.)这是这样的:

This would take some time to name all the differences. These products are quite similar at the first glance, but I'll try to name few features that would distinguish them. (I haven't been working with SSIS for many years now so please feel free to name any mistakes I make.) Here goes:

• PowerCenter(PC)可以在网格上运行，从而在节点之间分配工作
• PC能够连接到:
  • 消息传递平台(例如Tibco)
  • Salesforce
  • 社交媒体来源
  • Hadoop
  • SAP
  • PowerCenter (PC) can run on grid distributing work across nodes
  • PC is able to connect to:
    • Messaging platforms (e.g. Tibco)
    • Salesforce
    • social media sources
    • Hadoop
    • SAP

    仅举几例.随时添加/评论.

    This is just to name a few. Feel free to add / comment.

    这篇关于SSIS和Informatica的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！