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 partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"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."
"In the end, you have structured, proper data for use in an integrated BI solution."
"Can manage a huge quantity of data and provide reliability."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"The ability to scale through partitions helped us to improve the performance."
"The most valuable feature is the logging capability."
"Technical support from SAP is awesome. If we have an issue, they give a good solution."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"The logic is also simple. It makes it easy to build your extraction."
"I like how SAP Data Services links reporting and data integration. That's what's most interesting. You also have the opportunity to leverage the power of the Data Services server."
"It is a powerful product with a broad range of features."
"It's easy to understand and deploy. It's easy to create new applications, and depending on the complexity of the application, it is easy to deploy the new requirements."
"I appreciate having access to the SAP data."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"It should be more cloud-centric than on-prem-centric."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Integrating new tools can be tricky and challenging."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"They could make it easier to work with web services."
"I want some more business intelligence applications. People need to know more and more about data, including the transformation rules, etc. Informatica is a better product for data cataloging. SAP should update the data catalog."
"The pricing of the solution should be improved."
"It's an ETL that is very good with relational databases but not as good with files and semi-structured files."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"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."
"The solution could improve the overall features. There is a lot that can be done in the solution, therefor there are areas where it can improve. Additionally, there is a need to make it easier for one to create connections to other non-SAP systems. The flexibility to connect to other non-SAP systems is needed."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
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 Tableau, 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.