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

Informatica Intelligent Data Management Cloud (IDMC) vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
7.8
Number of Reviews
180
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (5th), Business-to-Business Middleware (3rd), API Management (8th), 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 (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
SSIS
Ranking in Data Integration
4th
Average Rating
7.8
Number of Reviews
71
Ranking in other categories
No ranking in other categories
 

Featured Reviews

MP
Jul 24, 2024
Powerful tool to create data warehouse solution with accessibility and features
We use the solution for ETL It's a powerful tool to create data warehouse solutions for our clients. We take unstructured data and use Informatica Cloud to structure it in various ways, making it usable on a reporting front end. This enables clients to make informed business decisions based on…
XZ
Mar 19, 2024
Integrates well with Visual Studio and good graphical interface that displays ETL process step-by-step
SSIS (SQL Server Integration Services) is primarily an ETL tool. It's frequently used for data integration and transformation. In the past, we used it to integrate data into our systems. Microsoft is now focusing on Azure Data Factory for cloud solutions, but SSIS is still a viable on-premises…

Quotes from Members

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

Pros

"The most valuable features of Informatica MDM are it is cloud-enabled and has all the elements that are supposed to have in terms of MDM as a solution. All the features that are there. It is very well-integrated with any of the SAP and non-SAP applications. It is quite user-friendly. The user experience that you receive in Informatica MDM is quite good."
"Informatica Persistent Data Masking can mask production data for different users, ensuring that only authorized individuals can access sensitive information."
"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 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 features that I have found most valuable are, first of all, that it comes as part of this whole bundle of Informatica tools. So if you've been implementing Informatica MDM across a business, you'd often find it comes with it. It's been thrown in as a sweetener. The adoption of it is often the challenge because as part of your MDM project, governance is seen as something beyond the MDM and is often restrictive. So this tool actually, for the first time, when you talk to data governance teams, gives a holistic view of what a data governance team can do with this tool."
"Informatica is user-friendly, stable, and scalable. These three aspects are the most valuable for us. If we can make it work well with the CRM, we can continue or try again this year to complete that part of the project. I am confident that this kind of solution is what we need because we have a third-party resource that works in the development."
"Informatica Cloud Data Integration is stable."
"A great product enrichment tool."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"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."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The simplicity of the solution is great. The solution also offers excellent integration."
 

Cons

"Informatica should simplify the rules for setting classifications and user access management permissions. It's too complex to define, configure, and make work."
"Needs to implement the new workflow with simple steps and a quick visualization with a 360 view of the data."
"The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions."
"The solution should improve its integration."
"The tool's performance is an area that should be given further consideration."
"New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."
"Some functionalities can be a challenge in the cloud."
"The biggest challenge I see is the IDE's for the cloud and automization are different."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"Improvement as per customer requirements."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The solution could improve by having quicker release updates."
"The security could be improved, as it is more important in our context."
"The performance of this solution is not as good as other tools in the market."
 

Pricing and Cost Advice

"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."
"it's expensive, but if you're looking for a stable solution, Informatica MDM is a good one to choose."
"It's an expensive solution."
"The platform has a premium cost. I rate the pricing as seven out of ten."
"I rate the product's pricing a seven on a scale of one to ten, where one is the lowest price and ten is the highest price."
"The pricing structure is good, but having to pay for extra drivers to be used in an ICS environment makes me a little nervous."
"The licensing price of the product depends on the organization's requirements."
"I have heard from customers that the product comes with a huge license cost."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"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."
"All of my clients have this product included as part of their Microsoft license."
"Our license with SSIS is annual."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"The solution is available at a lesser price than that of Informatica."
"People have to opt for a perpetual-based licensing model."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
801,394 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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
17%
Computer Software Company
13%
Manufacturing Company
10%
Insurance Company
6%
Financial Services Firm
17%
Computer Software Company
13%
Government
7%
Manufacturing Company
7%
 

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

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
 

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: September 2024.
801,394 professionals have used our research since 2012.