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

Informatica Intelligent Data Management Cloud (IDMC) vs SSIS 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:
 

ROI

Sentiment score
6.5
Informatica Cloud enhances data management ROI through analytics and efficiency, but benefits vary with adoption and tool preference.
Sentiment score
6.5
SSIS is cost-effective, enhancing data management efficiency and integration with SQL Server, providing significant operational and financial benefits.
Leadership prefers to utilize third-party tools, such as Snowflake, which has both storage and ELT features.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
The stability and performance remain issues.
consultant at a energy/utilities company with 5,001-10,000 employees
Compared to Collibra Catalog, where the value is noticeable within six months.
Data and Analytics Manager at a insurance company with 10,001+ employees
The tool has made us tremendously more efficient and saved us a significant amount of money.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
Managing Partner at Dynamis Informatica
 

Customer Service

Sentiment score
6.8
Informatica IDMC offers strong customer service, with variability in response times and support quality based on issue priority.
Sentiment score
6.0
Users find Microsoft support adequate for critical issues but often use online resources and community support for minor ones.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
Consulting Principal & Founder at Digital Data Consultancy
Even after going out of service support, they still reached back to me whenever I raised tickets.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
We expect more responsive assistance because they have the expertise since Informatica is their tool, but I don't see enough expertise on the Informatica support side.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
The first line of support needs to be more knowledgeable.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Scalability Issues

Sentiment score
7.3
Informatica IDMC is highly scalable and adaptable, catering to enterprise-level tasks with flexible cloud-based architecture.
Sentiment score
6.7
SSIS is effective for small to medium enterprises but may face challenges with scalability and performance for large datasets.
I have used the product over multiple systems and was able to write reports for large data sets without any performance issues.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
Consulting Principal & Founder at Digital Data Consultancy
There are many options available, and the licensing model is quite good, supporting our needs effectively.
Data Integration Architect at Endeavour Foundation
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
Tech Lead at a consultancy with 11-50 employees
 

Stability Issues

Sentiment score
7.6
Informatica Intelligent Data Management Cloud is generally stable, with minor issues, praised for scalability and reliability, rated highly.
Sentiment score
7.4
SSIS is highly rated for stability and performance, though minor issues and cloud discrepancies are occasionally noted by users.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
Consulting Principal & Founder at Digital Data Consultancy
There are substantial stability issues with Informatica Cloud Data Quality on the cloud.
consultant at a energy/utilities company with 5,001-10,000 employees
I find the stability to be good, with occasional restarts required every two to three months due to glitches.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
It processes large volumes of data quickly.
Managing Partner at Dynamis Informatica
 

Room For Improvement

IDMC faces integration, pricing, customization, and usability challenges, needing improvements in performance, support, AI, and functionalities.
SSIS needs enhanced error logging, diverse data integration, user management, ease of use, scalability, and better documentation support.
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.
Contractor at Sanlam
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
Consulting Principal & Founder at Digital Data Consultancy
The current solution requires code-writing and tweaking, while other solutions offer material-level matches.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
Managing Director at Knights Innovation Support Centre
SSIS has a difficult learning curve when dealing with complex transformations.
Managing Partner at Dynamis Informatica
The logging capabilities could be improved, particularly for error logging.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Setup Cost

Informatica IDMC is a costly, feature-rich solution for large enterprises, with pricing concerns partly mitigated by negotiable discounts.
SSIS is economical with SQL Server licenses, offering favorable pricing and integration, though add-ons may increase costs.
It ranges from a quarter million to a couple of million a year.
Consulting Principal & Founder at Digital Data Consultancy
Informatica Intelligent Cloud Services is affordable for my specific use cases, with the pricing being rated three or four on a scale where one is very cheap.
Data Integration Architect at Endeavour Foundation
Regarding pricing, compared to other tools I have worked with, Informatica offers competitive pricing, which I find not high in terms of starting strategy.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
Utilizing SSIS involves no extra charges beyond the SQL Server license.
Managing Partner at Dynamis Informatica
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
However, it could be a bit cheaper.
Tech Lead at a consultancy with 11-50 employees
 

Valuable Features

Informatica IDMC is praised for seamless data integration, quality management, flexibility, and robust AI-driven data features.
SSIS offers efficient, scalable ETL with seamless Microsoft integration, user-friendly interface, flexibility, and cost-effectiveness, enhancing data processes.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
Consulting Principal & Founder at Digital Data Consultancy
The connectors serve as the main functionality, making data integration processes more efficient by saving time and effort.
Data Integration Architect at Endeavour Foundation
We could run data quality rules as part of Service Bus, which ensured the integrity of customer information before it was entered into our database.
Data and Analytics Manager at a insurance company with 10,001+ employees
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Managing Partner at Dynamis Informatica
SSAS is included in the base installation of SQL Server.
Managing Director at Knights Innovation Support Centre
 

Categories and Ranking

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) (7th), Business-to-Business Middleware (2nd), API Management (5th), Cloud Data Integration (2nd), Data Governance (3rd), Test Data Management (2nd), 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)
SSIS
Ranking in Data Integration
2nd
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2026, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.7%, down from 4.6% compared to the previous year. The mindshare of SSIS is 3.6%, down from 7.5% 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.7%
SSIS3.6%
Other92.7%
Data Integration
 

Featured Reviews

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.
Chris Farris - PeerSpot reviewer
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
User-friendly interface facilitates efficient data migration and reduces operational overhead
Its usability and ease of use are standout features. It is really easy to use - almost too easy at times. Users don't have to be experts to use their tool set and utilize the clicking mechanisms, drop down boxes, and other features to build a package and run it. The configuration is very easy and the system is very stable. I would rate it at a 10 as it is highly reliable; we have never had any problems with it. Very little maintenance is required on my side. While you need to keep the product up to date, the maintenance requirements are minimal. SSIS integrates with all Microsoft tools seamlessly. We have used it against Oracle, DB2 and SQL. It integrates and can move data around from any data platforms, making it very diverse in that standpoint. It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
900,747 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Manufacturing Company
11%
Construction Company
7%
Computer Software Company
6%
Financial Services Firm
14%
Government
8%
Manufacturing Company
7%
Construction Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise155
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise57
 

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 is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What is your experience regarding pricing and costs for SSIS?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
What needs improvement with SSIS?
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly. The initial setup for SSIS is somewhat complex in the beginning, but once you und...
 

Also Known As

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking
SQL Server Integration Services
 

Overview

 

Sample Customers

The Travel Company, Carbonite
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS and other solutions. Updated: June 2026.
900,747 professionals have used our research since 2012.