Informatica Intelligent Data Management Cloud (IDMC) vs SSIS comparison

Informatica and Microsoft are both solutions in the Data Integration category. Informatica is ranked #3 with an average rating of 7.8, while Microsoft is ranked #4 with an average rating of 7.7. Additionally, 93% of Informatica users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

Informatica Intelligent Dat...

Read 181 Informatica Intelligent Data Management Cloud (IDMC) reviews

14,140 Views
10,140 Comparison Views

93% willing to recommend

SSIS

Read 72 SSIS reviews

14,200 Views
11,375 Comparison Views

79% willing to recommend

Informatica Intelligent Dat...

SSIS

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

SSIS and Informatica Intelligent Data Management Cloud (IDMC) compete in the data integration market. IDMC has the upper hand due to its advanced features that justify its cost.

Features: SSIS is tightly integrated with Microsoft SQL Server, providing robust data transformation capabilities and seamless ETL processes. It supports custom scripting, email sending, and SSAS processing, making it versatile for various tasks. IDMC offers extensive integration options, advanced data quality tools, and AI-driven automation, enhancing flexibility across diverse platforms and focusing on broader interoperability.

Room for Improvement: SSIS could improve by offering better cloud compatibility and more comprehensive data governance features. Its user interface could be modernized to appeal to new users. Additionally, expanding support for non-Microsoft systems would increase its market appeal. IDMC can enhance its interface to simplify complex configurations, improve pricing transparency, and ensure smoother integrations with non-cloud environments to cater to hybrid setups.

Ease of Deployment and Customer Service: SSIS benefits from a straightforward deployment, especially within Microsoft ecosystems, supported by dependable customer service. IDMC is designed for cloud-first deployment, offering adaptability for hybrid-cloud strategies. Its support services are robust, aiding in dynamic and varied deployment environments.

Pricing and ROI: SSIS generally offers a lower setup cost, attracting budget-conscious organizations while providing a steady ROI in Microsoft-centric infrastructures. IDMC, with higher initial costs, is seen as a valuable investment for organizations needing complex data management solutions, delivering significant long-term benefits despite the higher upfront expenses.

To learn more, read our detailed Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS Report (Updated: November 2024).

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS

November 2024

Download the complete report

Helped 824,067 peers since 2012

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)

SSIS

Ranking in Data Integration

4th

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

Featured Reviews

Raj Sethupathi

Data Integration Consultant GCP/AWS at Infogrators Inc

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.

Read full review

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

Its ability to transform and transport data is extremely valuable

he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.

Read full review

Quotes from Members

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

Pros

"The scalability of the solution is excellent."

"It is quite easy to use and flexible."

"It has improved our organization because it has made our data more reliable. Data is the most important asset these days, and in order to trust your data, you need these tools to make sure that your data is clean and reliable."

"I like the connectivity and richness of features for the technical team, the maturity of the product, and that it had a cloud version. There is Informatica Cloud, and it is part of the Informatica Cloud platform."

"I think the integration feature is probably one of the key features in Informatica MDM...Stability-wise, I rate the solution a ten out of ten."

"It comes with lot of features and is a one-stop-shop solution for integration, data modeling, and data governance. Everything can be built under one particular umbrella. If any issues come up, then there won't be any blame game saying that it could be an integration issue or an MDM hub issue because it's wholly owned by Informatica. That's the biggest advantage of Informatica MDM over that of any other tools that are available on the market."

"The ability to clean out data and improve the data quality is the best feature."

"The solution is stable."

More Informatica Intelligent Data Management Cloud (IDMC) pros

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."

"It is easy to set up the solution."

"Overall, it's a good product."

"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."

"It has good data integration and good processes."

"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."

More SSIS pros

Cons

"Informatica's support understands the solution, but they lack the experience we need for our use case. That was one thing that we prioritized when we started searching for this kind of solution."

"There may be some types of limitations with the performance."

"One thing Informatica could improve is the way IPUs are used. Each customer purchases a certain amount of IPUs per month, but you can use more or less than that defined quantity. The only problem is if you don't use the all your IPUs, they don't carry over into the next month. I think customers should have the ability to transfer unused IPUs into the next month or year. This improvement could help give customers more flexibility, especially since cloud solutions need flexibility in how we use and pay for them."

"I feel the out-of-the-box APIs or the API management could be improved slightly from their current state. It could be more user-friendly."

"Pre-sales technical support is much better than post-sales technical support."

"There are also some technical issues sometimes with integrations because clients have a lot of different types of data sources."

"Interoperability is one area where EDC has room for improvement. It was challenging when the faculty took over the data world and had specific vendors they wanted to use, and some were not particularly open platforms."

"I would like to see more API integration to have the capability to build a report using other third party reporting tools to streamline the operation."

More Informatica Intelligent Data Management Cloud (IDMC) cons

"Generic processes should be used instead of custom code for each table."

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

"We'd like more integration capabilities."

"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."

"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

"Future releases should improve the data lineage, as it currently is not good."

"This solution needs full support for real-time processing."

More SSIS cons

Pricing and Cost Advice

"The platform has a premium cost. I rate the pricing as seven out of ten."

"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."

"Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor."

"We switched to Informatica PIM because it was cheaper than the Oracle solution. It is cheaper initially, but they will bundle it later. This is what happens in the industry."

"It's a costly solution"

"The pricing is high compared to other tools on the market."

"Informatica MDM's price could be lower."

"So, there are plans for licensing. There are subscription-based and usage-based licenses. Also, there are licenses for exceptional analytics, etc. In short, there are different models of licensing for every enterprise."

More Informatica Intelligent Data Management Cloud (IDMC) pricing and cost advice

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"This solution is included with the MSSQL server package."

"The solution comes free of cost."

"We have an enterprise license for this solution."

"SSIS' licensing is a little high, but it gives good value for money."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

More SSIS pricing and cost advice

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

824,067 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

17%

Computer Software Company

12%

Manufacturing Company

10%

Government

Financial Services Firm

18%

Computer Software Company

12%

Government

Manufacturing Company

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...

See all answers

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...

See all answers

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 ...

See all answers

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...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

The solution comes free of cost.

See all answers

Comparisons

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 8% of the time

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

Compared 7% of the time

Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 5% of the time

Microsoft Purview Data Governance vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

AWS Glue vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

Informatica PowerCenter vs SSIS

Compared 23% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Qlik Replicate vs SSIS

Compared 2% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC)

December 2024

Informatica Intelligent Data Management Cloud (IDMC) report

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Buyer's Guide

SSIS

November 2024

Download SSIS product report

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

SQL Server Integration Services

Learn More

Informatica

Microsoft

Overview

Informatica Intelligent Data Management Cloud (IDMC) is a robust platform used by banks, financial institutions, and health sector organizations for data management, governance, and compliance.

IDMC provides comprehensive tools for data discovery, profiling, masking, and transformation. It supports Salesforce integration, real-time data streaming, and scalable data management solutions. Health organizations manage national product catalogs while financial entities focus on data protection and regulatory compliance. Its intuitive interface, flexible features, and robust tools make it valuable across sectors, though enhancements in data integration and human workflow are being sought.

What are the most important features?

Data discovery: Facilitates identifying and understanding data sources.
Data profiling: Analyzes old databases for data quality.
Data and platform masking: Ensures data protection.
Salesforce integration: Seamless connectivity with Salesforce.
Mastering data: Centralizing and standardizing data.
UI intuitiveness: User-friendly interface.
Feature map flexibility: Adapts to user needs.
Business glossary creation: Defines business terms.
Data lineage: Tracks data flow and transformations.
Automation: Streamlines data processes.
Enterprise data cataloging: Organizes extensive data assets.
Scalability: Supports expanding data requirements.
Easy setup: Quick deployment process.
Bulk upload: Efficiently handles large data volumes.
Customizable data management: Tailors data solutions.
Real-time data streaming: Manages live data streams.
Integration with Hadoop and NoSQL: Connects with big data platforms.

What benefits and ROI should be considered?

Regulatory compliance: Ensures adherence to regulations.
Data protection: Safeguards sensitive information.
Enhanced data quality: Improves accuracy and reliability.
Centralized data: Consolidates data for better management.
Process automation: Reduces manual tasks and errors.

Banks and financial institutions use IDMC for data masking, transformation, and compliance, while health sector organizations leverage it for national product catalogs. Industry applications focus on automating business processes, centralizing data, and managing data catalogs to meet regulatory demands and ensure data protection.

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.

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

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS

November 2024

Free Report: Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS

Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS and other solutions. Updated: November 2024.

DOWNLOAD NOW

824,067 professionals have used our research since 2012.

See our Informatica Intelligent Data Management Cloud (IDMC) vs. SSIS report.

See our list of best Data Integration vendors and best Cloud Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.