Go Informatica vs SSIS

Transfer from http://blog.csdn.net/thy822/article/details/8489779

This article, I can't agree more, so turn around here.

Here's my thinking after looking in both products ...

First of all-let me-you-I-like about Informatica ....

-inbuilt tool to export mappings to Excel and Visio ... helpful to document Process.
-Reusability of Sources,targets and Mappings (in SSIS No native reusabilty except is Usingbi xPress package Builder)
-Inbuilt Version control:ssis Can give you the after installing VSS, SVN or other products and in Informatica it Nativ e feature to Checkout and Checkin.
-Visibility of Metadata:you can click on any column in Pipeline and it'll show you where it originated from ... Pretty neat:)
-Scalibility out of the box

Now let me go through some main points which would drive your purchase decision.

trialing Software and Cost:

Informatica costs you tons of money. This was where 90% companies drop their decision to buy it ... once you buy it ... it'll cost you even more to maintain it Every good luck with that!!! Every dev license would cost your money ... on the other end dev license of SQL Server is virtually free ($ per Dev editio N License) .... and every SQL Server License comes with SSIS server. trialing Informatica isn't easy ... wont find a place to download it ... on the other end downloading entire BI Studio From Microsoft are click away this itself shows me Informatica wants your all money .... Seriously why are????

Development speed:

What I found after creating simple work flow in Informatica takes twice long than creating workflow in SSIS due to the FAC T Informatica stores Sources, targets and Mappings in seperate locations and then your bring them all together in WorkFlow (Similar as Controlflow in SSIS). One thing I like about this approach, reusabily but from experience I hardly reuse Mappings (Load Customer defined in One Workflow is rarely used in some other Workflow) so it sounds like appealing feature but atleast not for me.

Informatica have too many jumps to Design WorkFlow, Session, Execute WorkFlow and Monitor Progress all feels like I am usin G 3-4 different applications ... while SSIS was all in one compact window ... and very clean and Visual debugging.

Scripting in SSIS was the powerful than Informatica due to the fact SSIS Script Editor is Shell of Visul Studio which Gives breakpoints, Watch, callstack, Intellisense and step by step dbugging .... SSIS Scripting is C # or vb.net ... Informatica is JAVA

Inbuilt Tasks:

SSIS has advantage of have several inbuilt task which is isn't available in Informatica. But on the other end some adapters and Pipeline Features impressed me in Informatica including XML Destination, XML Trans Formation, Upsert capabilty, Visibility of Metadata.

Some of my fav task in SSIS Missing in Informatica:

-ForEach Looping
-Script Task
-File System Task

In SSIS can spent few hundred bucks to buy any missing features .... e.g Sftp/ftps, zip/unzip, Secureemail, Sharepoint , SalesForce Adapter, Upsert Destination, XML Destination

Storage:

informatica-everything is stored in central Repository (Oracle or SQL DB) ... what the means to developer ... You are stored on your machine. You are connected to the Informatica Server all the time. This is very frustrating coz I cant work offline unlike SSIS.

Ssis:you can develop SSIS Packages on your local machine in completely disconnected mode. When you are ready for deploy to production it can be stored in SQL Repository (msdb database) or can be stored on the File System.

Debugging WorkFlow and Pipeline:

SSIS have lots of ways to debug various things ... using breakpoints, Watch Window, Dataviewer. I didnt find similar features in Informatica. Debugging WorkFlow is more difficust in Informatica compared to SSIS.

Community Support:

SSIS Community support are amzing compared to any ETL Product out there. I didnt find a single scenario which are not blogged by community. Se

Extensibility:

Informatica is closed system doesnt allow you to create your own Sources and Targets and Tasks like SSIS Does ... You'll find lots of free tasks and Adapter in SSIS which can fit your custom need or you can create your own using SSIS APIs ... but in the Informatica its impossible or atleast I never found a by-do.

3rd party support:

Informatica keeps tight control what they want inside their products. If you need more functionality in Informatica so you have to pay tons for money to get few more adapters-called "Po Wer Exchange Module ". With the SSIS you'll find plenty of 3rd party products which would fit to your custom ETL need at low cost yet high quality. (e.g.taskfactory)

tagsssis vs Informatica,compare SSIS vs Informatica, ETL tool Compare

Well ... Informatica is pioneer in ETL market ... they came very first in the market they dominated many fortune. Hundred Compani Es... But since then MS seriously invested in BI Segment and current trend are MS bi is the fastest growing trend due to many FAC Ts.

-MS BI attracts many mid-size and Smaller shops because it one stop solution for entire BI (SQL, is, RS and AS) ... it co STS several times less than what other vendors charge.

-Feature Gap is no more issue after SQL Server released.

-Due to the tight budget and economy many companies going towards reducing cost and that's another reason why MS BI is T Rending up.

-MS invested significantly to prove it can scan out (multiple nodes) and scale up (running on powerful hardware with mult I processor and Higer RAM). MS introduced Parallel Datawarehouse and DW Fast track to attract bigger shops.

-The biggest drawback for MS BI right are it only works on Windows Platform ...

Again dont take my word ... read this article ... http://www.informationweek.com/news/206104502

Conclusion:ms BI is the fastest growing trend right now:) ... so if you were concerned about job market then Relax ... you wi ll find plenty of JOBS for MS BI

Go Informatica vs SSIS