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

Informatica Intelligent Data Management Cloud (IDMC) vs dbt comparison

 

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

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

Mindshare comparison

As of March 2026, in the Data Integration category, the mindshare of dbt is 1.7%, up from 1.0% compared to the previous year. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.6%, down from 5.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.6%
dbt1.7%
Other94.7%
Data Integration
 

Featured Reviews

AS
Principal Data Engineer at Integrant, Inc.
Data teams have streamlined code-driven pipelines and now collaborate faster on shared models
We are still experimenting with testing, but not that much. We are not using some features yet. We are trying to introduce them because we are coming from a background of SSIS. The team used to work with SSIS, Microsoft SQL Server Integration Services. We are still adapting one feature at a time. Currently, we are working with the SQL modules and with the Jinja templating. We are experimenting with testing, but I would say towards the end of this year, we are planning to explore more of the documentation and the data lineage options as well. I would say the benefits are coming from GUI-based tools like SSIS. We have more control on the codebase. We can create something of a system where we can use macros and templating, speeding up the development cycle. We are now trying to introduce a little testing, and also we are using some sort of a CI/CD cycle, so continuous integration and continuous deployment. I do not believe that these kinds of features are that common as a package as a whole package. dbt excels in that area. I used to have a couple of notes about the performance, but lately I have discovered something called dbt Fusion, which, according to dbt Labs, they proclaim is much faster during the parsing of dbt models. However, I would love to see even more of an out-of-the-box solution regarding the testing. They are treating the testing in a good way so far, but I would love to see even more improvement because the whole data testing field is not very mature. It is not the same as software testing; for example, you have test suites, test tools, and profilers, but for data testing, it is not yet that advanced. I would love for dbt to take the lead on that.
Divya-Raj - PeerSpot reviewer
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
Handles large data volumes effectively and offers competitive pricing
There is a lot of improvement required, as we still face some cache issues most of the time, which is a challenge that we expect to see resolved in the future. Additionally, there is some limitation when we are working with a tool, especially regarding In and Out parameters, and I feel that this aspect should be improved going ahead. We face issues with the API side, as Cloud Application Integration cannot handle large volumes; according to the API page, there is a limitation of 500 records or 500 MB. The AI integrated into the Informatica Intelligent Cloud Services solution is called Application Integration, where we still face challenges when dealing with huge volumes, as previously explained.

Quotes from Members

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

Pros

"dbt has positively impacted my organization by allowing us to create our data pipelines much faster, going from ingestion of data to creating a data product in weeks instead of months, and we can do it in-house with the skillset we already have."
"Since we migrated from SSIS to dbt model architecture, it takes around four hours only to complete a full refresh, and the client is now happy because our downtime was drastically reduced when we perform a complete refresh of the data."
"From a developer point of view, I find the ease of development and the code to be the most useful capabilities of dbt."
"There is operational efficiency achieved, and data quality and governance have also been achieved with modular SQL and version controlling, which reduced duplication of data and data errors."
"I would say the best feature or the most desirable feature for dbt is the ability to write everything in code."
"The product is developer-friendly."
"The OAuth feature is the most valuable feature for authentication."
"The user interface is flexible and the visibility of the data flow is amazing."
"It can automatically connect or associate business terms with various options, providing flexibility beyond general capabilities."
"This is where I think MDM shines - with its strong fuzzy matching algorithm. This is the essence of Informatica MDM. Based on these results, I can write our match conditions and then perform the corresponding data management activities."
"The fuzzy matching capability is a great feature."
"The user-friendliness and performance of Informatica is quite impressive."
"I like EDC's self-service capabilities. You can put the catalog on the intranet inside the organization, so users can search for something. People in the research world have specialized systems, and you might find data from various places that sound similar."
"​The tool manually checks on applying business rules and helps to implement them."
 

Cons

"Since dbt has a license cost, if a company is small and does not have much budget, they can explore other tools because there are other tools that provide the same functionality at a lower cost."
"Every upgrade is a little bit of a risk for us because we do not know if the workarounds that we developed will be available for the next version."
"Dbt is not as stable as preferred, as it has had a few outages in the current year itself, so improvement should be made in the outages section as it is not stable."
"If I needed to name a few areas for improvement, I would mention the migration of code to Git and GitHub, which sometimes fails and can be confusing for developers during handover."
"dbt can be improved as I find the co-pilot in dbt is not very good, and my team has tried using it but opted to move off it and use other co-pilots such as GitHub."
"The solution must add more Python-based implementations."
"Informatica Axon needs to improve its interface."
"Informatica Cloud Data Quality could improve by adding more algorithms for matching and mastering. We currently only have five or six. Additionally, the parallelism in data is better in other solutions, such as IBM."
"Cost-wise, it could be better."
"The solution doesn't directly connect to any of the analytical tools."
"The current features are a bit complicated, and we need to write big scripts and test."
"There are a small number of UI bugs that occur on occasion."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"In terms of cost effectiveness, Informatica Intelligent Data Management Cloud (IDMC) is more than 20% costly compared to the industry."
 

Pricing and Cost Advice

"The solution’s pricing is affordable."
"Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well."
"The solution's pricing model is easy, but it is very expensive."
"The solution is very expensive."
"Informatica Cloud Data Quality is a costly solution."
"The licensing price of the product depends on the organization's requirements."
"We saw an ROI. We have been able to get data from various sources and consolidate it into a data lake, which is helping us in data analytics."
"Informatica Axon is expensive."
"Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
884,873 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business1
Midsize Enterprise3
Large Enterprise3
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise153
 

Questions from the Community

What is your experience regarding pricing and costs for dbt?
The course content that dbt provides is free and excellent for anyone starting out.
What needs improvement with dbt?
We are still experimenting with testing, but not that much. We are not using some features yet. We are trying to introduce them because we are coming from a background of SSIS. The team used to wor...
What is your primary use case for dbt?
I am working with one of our enterprise customers, managing their newly established cloud warehouse. They are using Snowflake and we are using dbt to manage all the transformation and views and tab...
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 Informatica Intelligent Data Management Cloud (IDMC) vs. dbt and other solutions. Updated: March 2026.
884,873 professionals have used our research since 2012.