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

Informatica Intelligent Data Management Cloud (IDMC) vs Qlik Compose comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
181
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (6th), Business-to-Business Middleware (3rd), API Management (7th), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (4th), Product Information Management (PIM) (1st), Data Observability (2nd)
Qlik Compose
Ranking in Data Integration
22nd
Average Rating
7.6
Reviews Sentiment
6.5
Number of Reviews
12
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Raj Sethupathi - PeerSpot reviewer
Offers profiling and address standardization but can be complicated
Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.
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 way that the solution scans is very useful."
"The most valuable feature of Informatica Axon has been the data marketplace."
"The product is scalable and excellent for enterprise-level organizations."
"What I like best about Informatica MDM is its structured, table-based approach. Unlike Reltio, where data is only visible through the UI and cloud-based, the solution allows access to normalized tables. This means I can directly query and see data in each table. For instance, I can easily get all customer details from the customer table. However, for more complex queries, like seeing all customer interactions with the organization, some SQL knowledge is needed to join different tables and retrieve the details."
"The solution's scalability is high."
"We are able to set rules, establish a data quality management platform, and monitor the quality."
"We can scan anything."
"The most valuable features of the solution are pushdown, optimization, and partitioning, which can be used for frequent data loading, especially when we have a huge data volume in our company."
"The technical support is very good. I rate the technical support a ten out of ten."
"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."
"Qlik Compose is good enough. It is user-friendly and intuitive."
"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."
"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."
"It's a stable solution."
"It can scale."
 

Cons

"The stability and the integration of the solution have room for improvement."
"New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."
"I have received feedback from certain teams and there is a steep learning curve to use this solution."
"I would rate my experience with the initial setup a two out of ten, with one being difficult and ten being easy."
"There may be some types of limitations with the performance."
"Exploring the possibility of incorporating AI capabilities that can suggest additional rules would significantly streamline our data analysis process following data profiling."
"I have encountered some issues using the substitution, which is one of the techniques of data masking."
"The cloud version could be better in terms of pricing."
"I'd like to have access to more developer training materials."
"There could be more customization options."
"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."
"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."
"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."
"There is some scope for improvement around the documentation, and a better UI would definitely help."
"I believe that visual data flow management and the transformation function should be improved."
 

Pricing and Cost Advice

"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality."
"The price of Informatica Cloud Data Integration could be reduced."
"The price is high, but the competitors are even higher, like Collibra."
"It's a very expensive solution"
"The price is neither too high nor too low."
"Informatica Axon is expensive."
"Informatica MDM's pricetag should come down. They have to cut some costs."
"The price of the solution is expensive."
"On a scale of one to ten, where one is cheap, and ten is very expensive, I rate the solution a six."
"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.
824,067 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
10%
Government
6%
Financial Services Firm
15%
Manufacturing Company
11%
Computer Software Company
10%
Government
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
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...
What are the biggest benefits of using Informatica Cloud Data Integration?
When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...
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

ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration
Compose, Attunity Compose
 

Learn More

 

Overview

 

Sample Customers

The Travel Company, Carbonite
Poly-Wood
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Qlik Compose and other solutions. Updated: November 2024.
824,067 professionals have used our research since 2012.