Try our new research platform with insights from 80,000+ expert users

Informatica PowerCenter vs Qlik Compose comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica PowerCenter
Ranking in Data Integration
2nd
Average Rating
8.0
Reviews Sentiment
6.5
Number of Reviews
80
Ranking in other categories
Data Visualization (8th)
Qlik Compose
Ranking in Data Integration
21st
Average Rating
7.6
Number of Reviews
12
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Informatica PowerCenter is 10.9%, up from 10.1% compared to the previous year. The mindshare of Qlik Compose is 1.2%, up from 1.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Lars Borchers - PeerSpot reviewer
A stable and reliable product that provides a variety of features for data integration
The solution is not for newcomers. It has an old touch. The solution must improve the integration with new services. It was part of the program at Informatica when they moved to their cloud platform. It is integrated. However, from an on-premise perspective, we need to buy licenses for PowerExchange. If we want a native driver to access a special service, we need to extend our license to those services. It is expensive. I don't like that it's not all included in the solution.
Sahil Taneja - PeerSpot reviewer
Easy matching and reconciliation of data
The initial setup was easy for the data warehousing concept. But for a person who is new to ETL and warehousing concepts, it may take some time. If someone is familiar with these concepts, they could understand and learn the tool quickly. However, compared to other tools, the UI is complex. It would be helpful to have a better UI and documentation for new users. As of now, there is a challenge in learning the Compose tool for new users altogether. Qlik Compose was deployed on-premises. But the servers, like the SQL servers were maintained on the cloud—the managed instances.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The solution is stable."
"I like the completeness of the way I can build ETL workflows."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"It is an excellent ETL tool."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"PowerCenter performs well during data transformation and optimization."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"Informatica PowerCenter provides multiple transformations in one particular toolset. You don't need to apply any coding."
"There were many valuable features, such as extracting any data to put in the cloud. For example, Qlik was able to gather data from SAP and extract SAP data from the platforms."
"I have found it to be a very good, stable, and strong product."
"Qlik Compose is good enough. It is user-friendly and intuitive."
"As long as you pick the solution that best fits with your requirements, you won't find that performance is a problem. It's good."
"One of the most valuable features was the ability to integrate multiple source systems that mainly used structured IDBMS versions."
"I like modeling and code generation. It has become a pretty handy tool because of its short ideation to delivery time. From the time you decide you are modeling a data warehouse, and once you finish the modeling, it generates all the code, generates all the tables. All you have to do is tick a few things, and you can produce a fully functional warehouse. I also like that they have added all the features I have asked for over four years."
"The technical support is very good. I rate the technical support a ten out of ten."
"It's a stable solution."
 

Cons

"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"The reputation of Informatica is that it is expensive."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"There should be proper documentation available for the implementation process."
"I'd like to have access to more developer training materials."
"Qlik's ETL and data transformation could be better."
"There is some scope for improvement around the documentation, and a better UI would definitely help."
"My issues with the solution's stability are owing to the fact that it has certain bugs causing issues in some functionalities that should be working."
"It could enhance its capabilities in the realm of self-service options as currently, it is more suited for individuals with technical proficiency who can create pages using it."
"There could be more customization options."
"It would be better if the first level of technical support were a bit more technically knowledgeable to solve the problem. I think they could also improve the injection of custom scripts. It is pretty difficult to add additional scripts. If the modeling doesn't give you what you want, and you want to change the script generated by the modeling, it is a bit more challenging than in most other products. It is very good with standard form type systems, but if you get a more complicated data paradigm, it tends to struggle with transforming that into a model."
 

Pricing and Cost Advice

"We have a site license, but we do pay by the division."
"We have found the pricing very cost-effective. The licensing is CPU and data source-based."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price."
"It's much more expensive, almost three times more expensive than most other solutions."
"It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
"The price is mostly reasonable."
"The solution is in the middle price range compared to other solutions."
"On a scale of one to ten, where one is cheap, and ten is very expensive, I rate the solution a six."
"The price of the solution is expensive."
"While they outperform Tableau, there's room for improvement in Qlik's pricing structures, especially for corporate clients like us."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
13%
Manufacturing Company
7%
Insurance Company
7%
Financial Services Firm
13%
Computer Software Company
11%
Manufacturing Company
11%
Government
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
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...
Which ETL tool would you recommend to populate data from OLTP to OLAP?
There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cu...
What do you like most about Qlik Compose?
The most valuable is its excellence as a graphical data representation tool and the versatility it offers, especially with drill-down capabilities.
What is your experience regarding pricing and costs for Qlik Compose?
While they outperform Tableau, there's room for improvement in Qlik's pricing structures, especially for corporate clients like us.
 

Also Known As

PowerCenter
Compose, Attunity Compose
 

Learn More

 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Poly-Wood
Find out what your peers are saying about Informatica PowerCenter vs. Qlik Compose and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.