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."Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"Has a good visual tool for data mapping."
"It is UI friendly and has all the advantages of an ETL tool."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"It's very easy to use it to develop mappings and workflows."
"UI-based ability to create data mapping."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"It can scale."
"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."
"Qlik Compose is good enough. It is user-friendly and intuitive."
"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."
"The most valuable is its excellence as a graphical data representation tool and the versatility it offers, especially with drill-down capabilities."
"One of the most valuable features was the ability to integrate multiple source systems that mainly used structured IDBMS versions."
"One of the most valuable features of this tool is its automation capabilities, allowing us to design the warehouse in an automated manner. Additionally, we can generate Data Lifecycle Policies (DLP) reports and efficiently implement updates and best practices based on proven design patterns."
"The technical support is very good. I rate the technical support a ten out of ten."
"I would like to see it be able to import data from NoSQL."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"The UI is a little outdated."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"The documentation could be improved."
"Requires an established data center because there is no option for software as a service."
"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."
"There could be more customization options."
"I believe that visual data flow management and the transformation function should be improved."
"I'd like to have access to more developer training materials."
"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 is some scope for improvement around the documentation, and a better UI would definitely help."
"The solution has room for improvement in the ETL. They have an ETL, but when it comes to the monitoring portion, Qlik Compose doesn't provide a feature for monitoring."
"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."
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 AWS Database Migration Service. 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.