One of the most popular comparisons on IT Central Station is Informatica PowerCenter vs SSIS.
In your opinion, which is better and why?
Hands down Informatica. I've used both. Informatica is system and DB
agnostic and can run on any platform. If set up correctly like I do in my
architecture moving from the platform (Windows) to Linux or AIX would take less
than a day.
Also, Informatica is highly parameterizable and easier to develop in. The
shared objects ability is a huge time-saving advantage. Also, Informatica
has built-in version controls.
Informatica is more powerful than SSIS, But being myself an SSIS, SSRS developer I would recommend SSIS since it is less costly than Informatica and SSIS is more user-friendly and most of the transformations available in Informatica can also be done in SSIS.
It also depends on the project and volume of data you are handling in the project.
For less volume SSIS is compact but for huge volume, you can go with Informatica. In Our current project we are using SSIS and we are handling almost 2 TB data.
I would also recommend Pentaho Kettle as it is an opensource ETL tool that has the future credibility to overtake both SSIS and Informatica. But it is a freeware so you won't get more support until you pay for it.
Like any other technology there is no universal answer to which tool is better, it all depends on your requirements, budget, skill set and other considerations. Having said that if your DW/BI environment is based on the SQL Server stack I would go with SSIS unless there is a good reason to bring in another ETL tool.
Informatica is the more capable tool on paper whilst SSIS is more widely used, less expensive and there is an abundance of expertise available. However, it all comes down to which tool better aligns to a customer's requirements.
Informatica is better because it works not only with MS SQL but also Greenplum, Oracle and other databases
Yes, Informatica is expensive, but has a lot of features and is very easy to learn. That's very important. We use it in very big international projects for insurance and banking projects. Not only data warehousing. If you are interested in smaller projects for middle companies we like to use Talend with its excellent graphically support. If you need more information about the features (multi-platform, easy connecting different sources, very good but old-fashioned looking user interface and so on) and possible performance problems you can contact me.
I have worked on Informatica Power Center and Talend and not SSIS. As per me, Informatica Power Center is better as it is easy to use and performance tune as well.
Informatica power center is more power full than SSIS in respective of all context.I would recommend to go for Informatica power center latest version depends if you have a real projects.
I would go with the tried and tested Informatica tool. Its industrial strength and extensively successful across the globe and been around long enough.
Would have to ask the additional question of what are we trying to do? IPC is much better are larger implementations as SSIS is much better for smaller scale operations because of speed of development and price.
However, ODI is better than both of these tools. Even if its scale is to large for what you are trying to do. the newest version 12c has a better flow based implementation.
If you need high scalability then Information Server will be the way to go, else Informatica Power Center do provide more capabilities compare to SSIS if you can handle the price.
I have never used SSIS so I cannot really compare, I only know that Powercenter is one of the best ETL tools.
Very robust and performant , especially the Linux version …
Connects to a huge number of databases and systems…
Allows to do a lot with a small server with Informatica SE – for many years we ran thousands of sessions per day on a 2 core server with 4 GB RAM (Linux)
Also when looking @ Gartner Magic Quadrant, Informatica is on the top right – the leader in data integration. Microsoft is in the left box (challengers) – means you can do less with the platform…
If you only have SQLServer and some files then most likely SSIS would work ok.
If you have a more complicated env and want your ETL on Linux , choose Informatica
In an enterprise environment with high volume real-time processing there's no better option than Informatica. You want to automated processing, same. Quality doesn't come for free.
The main caveat is the lack of real good programmers. The majority are "mappers" which eliminates all the advantages.
Hi, there are few times when I have used them, I specialize more in the Oracle database area, but between PowerCenter vs SSIS I found it easier to use the SSIS.
It is down to (1) which tool suits Client's project better and (2) what expertise you have on board. I don't know Informatica at all and have been working heavilly with SSIS since before the last ice age so I would probably vote for SSIS. I am still to find a task too heavy or too complex for it to manage. But chances are, for your project Informatica is more suitable, provided that you have the right people to use it.
I worked with both and other ETL tools like Talend and SAP BODS.
If you look for ETL tools it depends what matters more to you: Informatica is really fast in transferring data but the usability, in my opinion, is not ok. As well pricing is much higher than SSIS. So, the only reason I would use Informatica in a project is that you get millions of rows per second or 100 of millions every hour to transfer it between different databases. As using the real ETL functionality is so complicated I have seen many installations that use Informatica just for sourcing, add after that a SQL transform and stage the data again. So, it becomes, in fact, a very expensive scheduler.
SSIS is included in the Microsoft package and will work as well in the newest version for a considerable amount of data.
Also, scripting is very good supported in SSIS and with the Team Foundation Server version management and deployment works also very well. But as well you need to get the hand on how to use the visual studio front end and sometimes you move a box around and all your ETL flow gets mixed up.
The question is what you want to achieve. If you target is to build a Data Warehouse I would recommend that you check out the Datawarehouse Automation tools like WhereScape or the Datavault Builder as they represent a newer concept: you define what you want to achieve instead of how. And the tools take care of historicization, data integration and so on.
So, in short, I would recommend: check the DWA tools like the Datavault Builder. If this is not what you need: SSIS is cheaper and will probably do the job and is simpler to use. Informatica is still probably the fastest option I know to move data around if you are a company with a high amount of real-time financial or phone transactions.
I used both of them in projects. Informatica is much more comfortable and has also a lot of features more than other tools.
Mark Bennett gave an appropriate answer. I have used both and both have pros and cons. The selection starts with your requirements and expectations. If you dont know those then you are just guessing. Careful of anyone who says one " is better because...." as they may not really know the other and have no clue what your needs are. The end result of that is guaranteed bad advice.
I would choose SAP Data Services Enterprise Edition over these two.
PFA which helps better to the question and please do let me know if required any .