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.
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"It has a Data Catalog that uses the Model repository."
"What I like the most is that we have to deal with less while writing the queries."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
"The most valuable feature is the logging capability."
"The solution offers very good integration capabilities."
"Technical support from SAP is awesome. If we have an issue, they give a good solution."
"The most valuable feature is the ETL functionality."
"Data Services' table comparison mechanism is very powerful. It's pretty hard to find a similar feature in other solutions."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"The user interface is ok."
"The reputation of Informatica is that it is expensive."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Its scalability can be improved. It is not scalable."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"The performance of Informatica PowerCenter could improve."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"The solution shows a lack of cloud support data services."
"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 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."
"The pricing of the solution should be improved."
"The interface is not quite user-friendly and is in need of improvement."
"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."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"The execution engines and processing engines have shortcomings and need improvements."
Informatica PowerCenter is ranked 3rd in Data Integration with 30 reviews while SAP Data Services is ranked 10th in Data Integration with 15 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 "Easy to use, simple to implement, and offers very good mapping capabilities". 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, SSIS, Palantir Foundry and SAP Process Orchestration. 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.