SSIS and Informatica

ssis informatica-powercenter sql-server-2012-datatools sql-server-2014
user1254579 picture user1254579 · Feb 26, 2014 · Viewed 9.4k times · Source

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.

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

Answer

Maciejg picture Maciejg · Feb 26, 2014

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) 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
  • PC can run on Unix
  • allows Real Time integration
  • allow data lineage from underlying database up to reporting layer
  • allows assigning memory per component
  • allows to easily see number of rows passing each transformation

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

Related questions

How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More
SSIS Convert Between Unicode and Non-Unicode Error

I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am using an Excel destination and using a SQL statement to create the sheet …

Read More
What is the SSIS package and what does it do?

Can someone tell me what the SSIS package is all about? I am totally new to data-warehousing and I am going crazy with the terms SSIS, DTL, ETL and so on. I am looking for a big picture and how …

Read More