No more typing reviews! Try our Samantha, our new voice AI agent.

Census vs Informatica Intelligent Data Management Cloud (IDMC) comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 15, 2026

Review summaries and opinions

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

Categories and Ranking

Census
Ranking in Data Integration
44th
Average Rating
9.0
Reviews Sentiment
5.4
Number of Reviews
2
Ranking in other categories
No ranking in other categories
Informatica Intelligent Dat...
Ranking in Data Integration
1st
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
215
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (9th), Business-to-Business Middleware (4th), API Management (18th), Cloud Data Integration (4th), Data Governance (3rd), Test Data Management (4th), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (2nd), Integration Platform as a Service (iPaaS) (5th), Test Data Management Services (5th), Product Information Management (PIM) (1st), Data Observability (2nd), AI Data Analysis (3rd)
 

Mindshare comparison

As of November 2026, in the Data Integration category, the mindshare of Census is 0.4%, down from 0.4% compared to the previous year. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.8%, down from 4.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica Intelligent Data Management Cloud (IDMC)3.8%
Census0.4%
Other95.8%
Data Integration
 

Featured Reviews

reviewer2784462 - PeerSpot reviewer
Software Engineer at a tech vendor with 10,001+ employees
Data activation has become faster and business teams access consistent customer insights
Census has been very useful to us as a reverse ETL layer. We have reduced engineering efforts, which has translated into tens of thousands of euros per year in avoided development and maintenance costs, faster and more accurate customer activation, and other improvements that we achieved using Census. Census is faster than our previous approach. Census has enabled faster activation of analytic data into CRM and marketing platforms in our case. Another key benefit is the elimination of manual exports and custom integration scripts, consistent customer data across analytical and operational systems. The best feature that Census offers is that it works directly on top of the data warehouse, preserving a single source of truth. Another valuable feature is that Census provides excellent support for CRM, marketing, and customer-facing platforms. Census creates a single source of truth by making the data warehouse the only place where business logic and data definition live and by ensuring that all downstream operational systems are consumers, not owners of data. All customer attributes, metrics, and segments are defined once, directly in the data warehouse, using SQL and existing data models. Census was useful for us because of the fast time to value, as new syncs can be configured and deployed quickly without custom development. It also ensures that data models are clean and well-defined in the data warehouse after we start using Census. Based on delivery metrics and team feedback, the benefit is that the time to activate new use cases was reduced from weeks to days. Engineering effort dedicated to reverse ETL pipelines decreased by sixty to seventy percent. Maintenance overhead for custom integration was almost completely eliminated, and marketing and growth teams accelerated experimentation cycles significantly. From a cost perspective, reduced engineering effort translated into tens of thousands of euros per year in avoided development and maintenance costs, and faster and more accurate customer activation improved campaign effectiveness and business responsiveness.
RC
Contractor at Sanlam
Cloud data catalog has streamlined lineage and quality while leaving more automation to improve
I have not explored IDMC's automation capabilities driven by AI and metadata too much at the moment, but it is on the cards. We are basically creating the foundation, as the whole migration has taken place recently and it is still early days. I think Informatica Intelligent Data Management Cloud (IDMC) is evolving, and as the vendors move forward, they pick up new concepts from each other. I have seen that products leapfrog each other, and from my experience over the years, the big players tend to copy features or add enhancements based on industry trends. I feel whatever the tool does not have now, there is a feedback loop allowing us to request new features, and we continually ask for different ways to do things as we have a pipeline into the product management team. It is difficult to say what additional features I would prefer to see in the next release of IDMC. I would appreciate more automation on the lineage front, with more AI to seamlessly join independent sources and create seamless lineage between different technologies, such as from file into database A into a different database and landing up in a reporting system such as Cognos, Qlik, Qlik Sense, QlikView, or Power BI.

Quotes from Members

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

Pros

"Based on delivery metrics and team feedback, the benefit is that the time to activate new use cases was reduced from weeks to days, engineering effort dedicated to reverse ETL pipelines decreased by sixty to seventy percent, maintenance overhead for custom integration was almost completely eliminated, and marketing and growth teams accelerated experimentation cycles significantly."
"Reverse ETL makes warehouse data more accessible to business teams, saves repetitive work, and helps improve the consistency of customer information across platforms."
"The way that the solution scans is very useful."
"I think that it's a good solution...It is stable because we have the experience to deploy this solution."
"We reduced product data setup time from 1.5 hours to 30 minutes."
"There are a couple of valuable features. One is that it is very quick on the profiling. So, you get a very fast snapshot of the type of data that you're looking at from the profiling perspective. It can highlight anomalies in the data."
"Informatica MDM has helped our organization because we now work from a harmonized single record for customers and patients."
"Informatica Data Quality is a product that is worth the money."
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"I know that there are two good features, APN and ServiceNow but we haven't explored all of its features yet."
 

Cons

"The areas for improvement are complex transformation logic because it must still be handled upstream in the warehouse, and cost predictability requires attention at high data volumes."
"I would like to see more advanced data quality checks, clearer error messages when a sync fails, and easier troubleshooting for complex workflows."
"I would like to see support for more data sources."
"The initial setup of Informatica MDM is more complex than it should be."
"Asia pacific region address validation needs to be improved."
"Informatica Cloud Data Integration could improve the price by making it less expensive."
"The integration could be a bit better. The process is something new."
"It would be great if the cloud version could match the full range of capabilities available on-premise."
"Informatica MDM could be improved by adding drag and drop options, business data insights, and visualization reporting."
"The one thing that I think could be improved is connectivity with the Salesforce because if you're loading a huge amount of data, whatever optimization is carried out, takes some time and it could be a little faster."
 

Pricing and Cost Advice

Information not available
"Informatica is very expensive."
"We got a 50% discount."
"Informatica MDM's price could be lower."
"There is no doubt that it is very expensive, but the brand value comes at a cost. Other MDM solutions in the market that haven't proven themselves like Informatica are also pretty expensive. We need to understand that MDM itself is very expensive to implement. So, Informatica is also pretty expensive. I would rate it a two out of five for being pretty expensive."
"The solution is expensive."
"The solution is very expensive."
"I'm not sure about the most recent pricing trends, but I don't believe it's significantly different from PowerCenter. I believe it is nearly the same."
"I have no idea what the price actually is. It is probably not going to be the cheapest, but it is a pretty stable and robust platform from the backend standpoint."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
920,929 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
11%
Construction Company
10%
Comms Service Provider
10%
Healthcare Company
10%
Financial Services Firm
11%
Manufacturing Company
10%
Outsourcing Company
9%
Construction Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise155
 

Questions from the Community

What needs improvement with Census?
Census has been performing very well overall. One area that may need improvement is that sometimes a custom setup is very difficult to configure. This was the case with our Intercom segment setup. ...
What is your primary use case for Census?
Census is a versatile data synchronizing solution that solves a wide range of data management problems for our business. With Census, we were able to reduce the sync time taken to transfer data fro...
What advice do you have for others considering Census?
I would rate Census an eight out of ten according to my experience. I feel it is not quite a ten because sometimes a custom setup is very difficult to configure. This was the case with our Intercom...
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 ...
 

Also Known As

No data available
ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking
 

Overview

 

Sample Customers

Information Not Available
The Travel Company, Carbonite
Find out what your peers are saying about Census vs. Informatica Intelligent Data Management Cloud (IDMC) and other solutions. Updated: November 2026.
920,929 professionals have used our research since 2012.