Informatica Intelligent Data Management Cloud (IDMC) vs SSIS comparison

Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS

Download the complete report

Helped 879,422 peers since 2012

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

7.1

Informatica's cloud platform enhances data management efficiency, cost savings, and data security, requiring effective change management for optimal results.

Sentiment score

7.6

SSIS is praised for cost-effective, efficient data management with significant savings, but users may switch with more budget.

Leadership prefers to utilize third-party tools, such as Snowflake, which has both storage and ELT features.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

The stability and performance remain issues.

reviewer946383

consultant at a energy/utilities company with 5,001-10,000 employees

Compared to Collibra Catalog, where the value is noticeable within six months.

reviewer2696502

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.

For more quotes and insights, download the SSIS report

Managing Partner at Dynamis Informatica

Customer Service

Sentiment score

6.9

Informatica's customer service is generally rated positively for quick, knowledgeable support, though some report occasional delays and inconsistencies.

Sentiment score

6.0

Users rely on forums for SSIS issues; Microsoft support is mixed, with some finding response times and quality lacking.

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

The first line of support needs to be more knowledgeable.

For more quotes and insights, download the SSIS report

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

Scalability Issues

Sentiment score

7.3

Informatica Intelligent Data Management Cloud is praised for scalability and flexibility in handling large datasets, despite pricing concerns.

Sentiment score

6.7

SSIS is scalable and excels in data integration, but efficiency varies with large datasets and real-time processing challenges.

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Data Integration Architect at Endeavour Foundation

No quotes available

For more quotes and insights, download the SSIS report

Stability Issues

Sentiment score

7.7

Users generally find IDMC stable, with occasional challenges after updates, especially in older versions or specific integrations.

Sentiment score

7.4

SSIS is generally praised for stability and reliability, though some users note issues and the need for strong infrastructure.

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.

reviewer946383

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees

It processes large volumes of data quickly.

For more quotes and insights, download the SSIS report

Managing Partner at Dynamis Informatica

Room For Improvement

Informatica IDMC needs UI improvements, better connectivity, streamlined configuration, cheaper pricing, and enhanced support with AI integration.

SSIS needs improved scalability, data source support, real-time processing, cloud integration, and user-friendly interfaces for better performance.

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

If the development interface could be optimized to have fewer modules, it would be greatly beneficial.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Data Integration Architect at Endeavour Foundation

Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.

Sean Achim

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.

For more quotes and insights, download the SSIS report

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

Setup Cost

Informatica IDMC provides a robust but expensive pricing model with complex licensing and potential negotiation discounts for enterprises.

SSIS offers a cost-effective ETL solution for enterprises using Microsoft, enhancing affordability by integrating with SQL Server licenses.

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

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.

For more quotes and insights, download the SSIS report

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

Valuable Features

Informatica IDMC offers seamless data integration, AI-enhanced features, and efficient governance, enhancing user experience and operational efficiency.

SSIS provides user-friendly drag-and-drop functionality, excellent integration, scalability, cost-efficiency, and robust data transformation features.

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

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.

reviewer2696502

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.

For more quotes and insights, download the SSIS report

Managing Partner at Dynamis Informatica

SSAS is included in the base installation of SQL Server.

Sean Achim

Managing Director at Knights Innovation Support Centre

Categories and Ranking

Informatica Intelligent Dat...

Ranking in Data Integration

2nd

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

214

Ranking in other categories

Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (3rd), 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 (1st), Metadata Management (1st), Integration Platform as a Service (iPaaS) (3rd), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (1st), AI Data Analysis (1st)

SSIS

Ranking in Data Integration

1st

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of January 2026, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.7%, down from 5.5% compared to the previous year. The mindshare of SSIS is 4.0%, down from 7.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration Market Share Distribution
Product	Market Share (%)
SSIS	4.0%
Informatica Intelligent Data Management Cloud (IDMC)	3.7%
Other	92.3%

Data Integration

Featured Reviews

Handles large data volumes effectively and offers competitive pricing

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

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.

Read full review

User-friendly interface facilitates efficient data migration and reduces operational overhead

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

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.

Read full review

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

879,422 professionals have used our research since 2012.

Comparison Review

it_user90069

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…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Manufacturing Company

10%

Computer Software Company

Retailer

Financial Services Firm

17%

Computer Software Company

10%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	51
Midsize Enterprise	27
Large Enterprise	153

By reviewers
Company Size	Count
Small Business	26
Midsize Enterprise	19
Large Enterprise	57

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 do you like most about SSIS?

The product's deployment phase is easy.

What is your experience regarding pricing and costs for SSIS?

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.

Collibra Platform vs Informatica Intelligent Data Management Cloud (IDMC)

Comparisons

Compared 4% of the time

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

Qlik Talend Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 3% of the time

Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

TIBCO EBX vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

Informatica PowerCenter vs SSIS

Compared 9% of the time

dbt vs SSIS

Compared 7% of the time

Skyvia vs SSIS

Compared 6% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 6% of the time

FME vs SSIS

Compared 3% of the time

More SSIS Competitors

Product Reports

Informatica Intelligent Data Management Cloud (IDMC)

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Informatica Intelligent Data Management Cloud (IDMC) report

SSIS

Download SSIS product report

Also Known As

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking

SQL Server Integration Services

Overview

Informatica Intelligent Data Management Cloud (IDMC) offers seamless integration of master data management, data quality, and data integration with a cloud-native architecture supporting multiple data management styles, optimizing data governance through metadata management.

IDMC enhances data synchronization and mapping tasks, utilizing a broad range of connectors to interact efficiently with data sources. Its precise address validation via AddressDoctor and intuitive navigation bolster user empowerment, delivering agility, scalability, and security in data governance. Despite its strengths, areas like ease of use, SAP integration, and reporting could benefit from enhancements. Connectivity issues and workflow complexities are noted, needing improvements in performance, support, and licensing cost. Users demand expanded ETL capabilities, real-time processing, and broader data source support to address growing data needs.

What are the key features of IDMC?

Integration Capabilities: Ensures seamless connectivity between on-premise and cloud environments.
Master Data Management: Centralizes and streamlines data processes for enhanced quality.
Data Quality: Employs tools for cleansing and standardizing data accuracy.
Address Validation: Features AddressDoctor for precise address verification.
Real-Time Processing: Supports real-time data handling for critical operations.
Connectivity Options: Offers a wide array of connectors for easy data source interaction.

What benefits and ROI should users consider?

Scalability: Cloud-native design boosts system agility, adapting to data volume changes.
Security: Enhances data protection with robust encryption and compliance measures.
Efficiency: Automates processes to reduce manual effort and errors.
Flexibility: Supports diverse data management styles, offering adaptability to business changes.
Governance: Empowers effective data governance through comprehensive metadata management.

In industries such as banking, healthcare, and telecom, IDMC is implemented for data integration, cloud migration, and enhancing data quality. Its capabilities are crucial for metadata management, lineage tracking, and real-time processing, ensuring high data quality and streamlined operations.

Informatica

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Microsoft

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

Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS