We performed a comparison between Informatica PowerCenter and SAP Data Services based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: SAP Data Services wins out in this comparison. The main difference between the two solutions is that Informatica PowerCenter cannot do batch processing and users also consider it to be expensive.
"The interface is very clean and clear."
"It is UI friendly and has all the advantages of an ETL tool."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"Good interface, reasonable documentation."
"What I like the most is that we have to deal with less while writing the queries."
"Has a good visual tool for data mapping."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"I found the map links, work links, and workflows valuable. They are important features."
"The user interface is ok."
"The reporting on the data, even from third-party software, is very good."
"The feature of SAP Data Services has enhanced our company's business processes because we are able to run around 800 jobs in areas like data extraction and transaction objects."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"The maintenance of data services is the solution's most valuable feature."
"I appreciate having access to the SAP data."
"The BA reporting tools, such as Data Services, and ETL tool in SAP Data Services are the most valuable. When we had in-memory requirements, we used HANA. HANA is most preferably for most the customers for in-memory. SAP is the first company that created the in-memory concept."
"You can always manipulate a lot of things as long as you have the skill level."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"The solution must improve the integration with new services."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"The UI is a little outdated."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"We would like the different tools offered within this solution to be available as standalone entities, rather than having to purchase the entire package when we only require a few features."
"The skillset of data engineers matters a bit to use all the functionality of this solution. Otherwise, the delivery speed won't be faster."
"We encounter challenges while exporting implemented rules, such as those applied to objects like the material master, into a format like Excel for documentation and further analysis."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"It would be nice if this solution was a bit easier to move from development to production."
"The execution engines and processing engines have shortcomings and need improvements."
"The description of error messages isn't extensive, although they point to the problem. With other solutions, like Talend, I was able to use the debugger to get directly to the problem, but with SAP Data Services the debugger is not working. I'm not sure if it's a problem with the version specifically, but I'm using it in an enterprise environment and I can't do an upgrade."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while SAP Data Services is ranked 10th in Data Integration with 45 reviews. Informatica PowerCenter is rated 8.0, while SAP Data Services is rated 8.0. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of SAP Data Services writes "Responsive support, scalable, and beneficial integration". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Talend Open Studio, whereas SAP Data Services is most compared with Azure Data Factory, Syniti Data Quality, SAP Process Orchestration, Palantir Foundry and SSIS. See our Informatica PowerCenter vs. SAP Data Services report.
See our list of best 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.