Coming October 25: PeerSpot Awards will be announced! Learn more
2018-04-11T09:42:00Z
Nurit Sherman - PeerSpot reviewer
Content Operations Manager at PeerSpot (formerly IT Central Station)
  • 21
  • 443

Which is better, Informatica PowerCenter or SSIS?

One of the most popular comparisons on IT Central Station is Informatica PowerCenter vs SSIS.

In your opinion, which is better and why?

Thanks!

--Rhea

22
PeerSpot user
22 Answers
PeerSpot user
ETL Solution Architect at a tech services company
Real User
2018-04-11T13:17:52Z
11 April 18

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.

PeerSpot user
-- at a tech company with 51-200 employees
Real User
2018-04-13T17:32:09Z
13 April 18

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.

it_user568449 - PeerSpot reviewer
Sr. Director, BI Technologies at a comms service provider with 10,001+ employees
Real User
2018-04-13T13:48:26Z
13 April 18

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.

PeerSpot user
information Architect
MSP
2018-04-11T20:45:22Z
11 April 18

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.

2018-04-11T16:46:36Z
11 April 18

Informatica is better because it works not only with MS SQL but also Greenplum, Oracle and other databases

it_user843471 - PeerSpot reviewer
Strategy of Distributional Systems and IT with 11-50 employees
User
2018-04-14T14:31:17Z
14 April 18

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.

Find out what your peers are saying about Informatica PowerCenter vs. SSIS and other solutions. Updated: August 2022.
633,572 professionals have used our research since 2012.
it_user74787 - PeerSpot reviewer
User at a tech company with 51-200 employees
Vendor
2018-04-12T16:22:36Z
12 April 18

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.

it_user779817 - PeerSpot reviewer
Teradata ETL Consultant with 201-500 employees
User
2018-04-11T15:43:34Z
11 April 18

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.

2018-04-11T15:06:02Z
11 April 18

I would go with the tried and tested Informatica tool. Its industrial strength and extensively successful across the globe and been around long enough.

Brian Dandeneau - PeerSpot reviewer
Business Process and Strategy Specialist Advisor at NTTData
Consultant
Top 5Leaderboard
2018-05-07T17:48:19Z
07 May 18

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.

it_user636003 - PeerSpot reviewer
IBM Analytic Platform Solution Advocate at IBM
MSP
2018-04-13T00:45:28Z
13 April 18

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.

it_user783891 - PeerSpot reviewer
Business Intelligence Project Lead at Delphi
Real User
2018-04-12T15:46:28Z
12 April 18

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

2018-04-12T15:27:20Z
12 April 18

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.

it_user801078 - PeerSpot reviewer
TSS Engineer with 501-1,000 employees
User
2018-04-12T14:30:53Z
12 April 18

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.

PeerSpot user
Business Intelligence Consultant at a tech services company with 51-200 employees
Consultant
2018-04-12T11:09:09Z
12 April 18

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.

it_user829101 - PeerSpot reviewer
Consultant at 2150 GmbH
Vendor
2018-04-12T09:17:04Z
12 April 18

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.

PeerSpot user
Lead Consultant- Analytics with 1,001-5,000 employees
Vendor
2018-04-12T07:29:03Z
12 April 18

Informatica

it_user843471 - PeerSpot reviewer
Strategy of Distributional Systems and IT with 11-50 employees
User
2018-04-12T00:02:26Z
12 April 18

I used both of them in projects. Informatica is much more comfortable and has also a lot of features more than other tools.

GaryM - PeerSpot reviewer
Data Architect at World Vision
Real User
Top 5Popular
2018-04-11T22:42:24Z
11 April 18

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.

it_user632214 - PeerSpot reviewer
Analyst at a tech services company with 5,001-10,000 employees
User
2018-04-11T19:42:24Z
11 April 18

I don't know Powercenter. I worked a little with SSIS. But aside these two tools, I would prefer to use Pentaho or Talend, which are free tools. Specially Pentaho also has the power of connecting to any database. You can code in java or javascript. Also in Talend. These two last tools are very good, and Talend is special to work with high volumes of data, and it has the ability of connecting to the cloud.

it_user546849 - PeerSpot reviewer
Senior Solutions Engineer at SAP
Real User
2018-04-11T19:39:35Z
11 April 18

I would choose SAP Data Services Enterprise Edition over these two.

it_user850776 - PeerSpot reviewer
User at a tech company with 51-200 employees
User
2018-04-11T14:14:29Z
11 April 18

PFA which helps better to the question and please do let me know if required any .

Related Questions
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Feb 13, 2022
Why?
2 out of 3 answers
RC
Advanced Senior Programmer at a individual & family service with 10,001+ employees
25 October 21
Cloud Data Integration
21 November 21
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge quantities of data with a high level of reliability. We also like the metadata repository and the data warehouse application console. We would like to see the licensing improved, though. We would like to see a feature-wise option as opposed to the current bundle option. PowerCenter is a very expensive solution. The numerous levels of transformation and multiple interfaces can make it a very confusing solution to learn. Cloud Data Integration offers great options for data cleansing, data mastering, data masking, master data management, and API management. The UI is very easy to use and the setup is straightforward. The new licensing is very flexible. Cloud Data Integration has inbuilt tools that allow for a lot of data transformation without changing any SQL queries from the code. This is one of our favorite features. We would point out, though, that there are some limitations with performance using Cloud Data Integration. We experienced some connectivity issues, making things run a bit slow. There are some issues with data residency laws in some countries. More regions should be added. Finally, it would behoove Cloud DataIntegration to consider adding more data sources. Conclusion: These are two great solutions under Informatica Brand which is synonymous with quality, reliability, and price. (Very high price.) Cloud Data is best suited for small to medium organizations and is somewhat limited in the regions it can be used. PowerCenter is most applicable for large enterprises that can more easily absorb the cost and best utilize everything PowerCenter has to offer with their current bundle licensing tier.
Christiana Steves - PeerSpot reviewer
Business Analyst at TekSlate.com
Jul 13, 2017
Doing Python on exceptionally small tasks makes me admire the dynamically typed nature of this language (no want for assertion code to hold track of types), which regularly makes for a faster and less painful development system alongside the manner. but, I experience that during a whole lot larger tasks this may virtually be a hindrance, because the code might run slower than say, its equal in ...
See 2 answers
PeerSpot user
Software Architect at a tech consulting company with 51-200 employees
13 July 17
From my own experience, your question does not admit a "one size fits all" kind of answer, in fact, the answer should start with the (annoying): it depends. I will start with describing how I work with the kinds of tools that you mention: When I have to solve a new problem I start exploring the problem and prototyping the solution with Python and the usual toolset (NumPy, Pandas, SciPy, MathPlotLib, the works). If the problem is an ongoing concern, instead of a being a "just one shot" nuisance, once I have a stable prototype, but need a more robust and performant solution for the long run, I start a new project to design such a solution with .NET (typically, with C#), either on Windows or on Linux, depending on the circunstances of the problem. So if you face similar scenarios, that is, you need to have robust and performant solutions for the long run on many of your problems, my suggestion is to start getting friendly with a compiled language like C++ or C#, or some other, and follow an approach in the line of what I do. Kind regards, GEN
PeerSpot user
Software Architect at a tech consulting company with 51-200 employees
13 July 17
Consultant working with Microsoft development tools and Database tools as a software architect for more than 20 years.
Related Categories
Download Free Report
Download our free Informatica PowerCenter Report and get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
DOWNLOAD NOW
633,572 professionals have used our research since 2012.