We performed a comparison between Informatica PowerCenter and Qlik Compose based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"PowerCenter performs well during data transformation and optimization."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"The product's initial setup phase is very easy."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"The ability to scale through partitions helped us to improve the performance."
"I have found it to be a very good, stable, and strong product."
"The technical support is very good. I rate the technical support a ten out of ten."
"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."
"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."
"Qlik Compose is good enough. It is user-friendly and intuitive."
"One of the most valuable features was the ability to integrate multiple source systems that mainly used structured IDBMS versions."
"It can scale."
"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."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"It should be more cloud-centric than on-prem-centric."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Requires an established data center because there is no option for software as a service."
"We had stability issues, mostly with JVM size."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"For more complex work, we are not using Qlik Compose because it cannot handle very high volumes at the moment. It needs the same batching capabilities that other ETL tools have. We can't batch the data into small chunks when transforming large amounts of data. It tries to do everything in one shot and that's where it fails."
"Qlik's ETL and data transformation could be better."
"When processing data from certain tables with a large volume of data, we encounter significant delays. For instance, when dealing with around one million records, it typically takes three to four hours. To address this, I aim to implement performance improvements across all tables, ensuring swift processing similar to those that are currently complete within seconds. The performance issue primarily arises when we analyze the inserts and updates from the source, subsequently dropping the table. While new insertions are handled promptly, updates are processed slowly, leading to performance issues. Despite consulting our Qlik vendors, they were unable to pinpoint the exact cause of this occurrence. Consequently, I am seeking ways to optimize performance within Qlik Compose, specifically concerning updates."
"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."
"There should be proper documentation available for the implementation process."
"I'd like to have access to more developer training materials."
"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."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Qlik Compose is ranked 20th in Data Integration with 12 reviews. Informatica PowerCenter is rated 8.0, while Qlik Compose is rated 7.6. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Qlik Compose writes "Easy matching and reconciliation of data". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Qlik Compose is most compared with Qlik Replicate, Talend Open Studio, Azure Data Factory, SSIS and IBM InfoSphere DataStage. See our Informatica PowerCenter vs. Qlik Compose report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.