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 product's initial setup phase is very easy."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"Good product if you are trying implement data quality, data integration, and data management projects."
"Informatica PowerCenter is a very good ETL tool."
"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."
"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."
"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."
"The initial setup is not complex."
"The basic functionality is quite good as is the basic logic and data information."
"You can always manipulate a lot of things as long as you have the skill level."
"The product's most valuable features are data validation and rules."
"The solution offers very good integration capabilities."
"I have worked with Data Services for a long time, and currently, I find the dashboarding and reporting part to be the most valuable function."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"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."
"They should release new versions for the solution's on-premises setup."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"The solution does not scale."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"It's an ETL that is very good with relational databases but not as good with files and semi-structured files."
"The execution engines and processing engines have shortcomings and need improvements."
"There should be some kind of enhancement that can be done on the admin side of certain sites where we can assign the roles and responsibilities. We should be able to control who is using the tool and how."
"With SAP Data Services, the problem arises when I try to connect to Azure Databricks."
"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."
"Scheduling of jobs in the sequence is not available. It's a very tedious process to do that particular task. If there was a tool to schedule in the sequence that would be extremely helpful."
"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 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.