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

Informatica Intelligent Data Management Cloud (IDMC) vs SAS Data Integration Server comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
181
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (7th), 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)
SAS Data Integration Server
Ranking in Data Integration
36th
Average Rating
7.4
Reviews Sentiment
8.5
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Raj Sethupathi - PeerSpot reviewer
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.
reviewer1752714 - PeerSpot reviewer
A stable and scalable tool with data handling capabilities and an amazing technical support
I am from the data visualization team and used SAS VA and SAS Data Integration Server. This year, my team has stopped the use of SAS VA and SAS Data Integration Server. We have a separate team that uses SAS Data Integration Server since they belong to the data management team. I recommend the solution to those organizations that have a very large scale of data to handle so that they can utilize the solution's data handling capabilities. Organizations can go with the solution's on-premises or cloud version. Since the cost of the on-premises version of the solution is huge, I recommend businesses go with the cloud version. I rate the overall product between seven to eight out of ten.

Quotes from Members

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

Pros

"The solution's scalability is high."
"Informatica MDM has a defined data model we can customize with user and developer options."
"The Provisioning tool is something that is really handy for everyone. It is my pick as the best feature."
"The user interface is flexible and the visibility of the data flow is amazing."
"A great product enrichment tool."
"Informatica Cloud Data Integration is stable."
"Offers data lineage feature"
"It's a stable product without any bugs or glitches."
"The solution is very stable."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution offers very good data manipulation and loading."
 

Cons

"The solution doesn't directly connect to any of the analytical tools."
"Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them."
"The error information provided is not informative, as compared to Power Center."
"The model is somewhat flexible. There are certain aspects of the model that are not as flexible as we would like. It doesn't do certain things to a great level of depth. So, in situations where we want to drill in to do something specific, we have to essentially copy that data into our own structures in order to add that additional layer of flexibility."
"It is not easy to set up and configure the tool."
"Informatica MDM can improve the data catalog and data marketplace."
"It is complicated to establish the lineage in EDC using PowerCenter mappings."
"Error reporting and debugging need improvement."
"So I would like to see improved integration with other software."
"The transform tool has limited access. They should make it more flexible."
"The initial setup of SAS Data Integration Server was complex."
 

Pricing and Cost Advice

"Informatica MDM's pricetag should come down. They have to cut some costs."
"The solution's pricing model is easy, but it is very expensive."
"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 a very expensive solution"
"Informatica Axon is a costly solution. I rate Informatica Axon a four out of ten for its pricing."
"I have heard from customers that the product comes with a huge license cost."
"Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing."
"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."
"It is an expensive program."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Insurance Company
6%
Financial Services Firm
25%
Computer Software Company
14%
Government
11%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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 ...
What do you like most about SAS Data Integration Server?
The most valuable feature of the solution is its amazing capabilities in regard to data handling.
What is your experience regarding pricing and costs for SAS Data Integration Server?
I don't handle the cost and budget part. From the tool's perspective, I can say that it is an amazing product.
What needs improvement with SAS Data Integration Server?
Visualization is an area with a few shortcomings in the product. Some new and amazing visualization capabilities have been added to the product, but I haven't used them enough to be able to comment...
 

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
SAS Enterprise Data Integration Server, Enterprise Data Integration Server
 

Learn More

Video not available
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Credit Guarantee Corporation, Cr_dito y Cauci‹n, Delaware State Police, Deutsche Lufthansa, Directorate of Economics and Statistics, DSM, Livzon Pharmaceutical Group, Los Angeles County, Miami Herald Media Company, Netherlands Enterprise Agency, New Zealand Ministry of Health, Nippon Paper, West Midlands Police, XS Inc., Zenith Insurance
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. SAS Data Integration Server and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.