SAP Data Services is the best ETL tool when paired with an SAP HANA data lake
September 26, 2019

SAP Data Services is the best ETL tool when paired with an SAP HANA data lake

Kevin Clemons | TrustRadius Reviewer
Score 10 out of 10
Vetted Review

Overall Satisfaction with SAP Data Services

SAP Data Services is the primary ETL tool for many of my clients. We use it to move, manage, and control data to meet reporting and analytics needs. Paired with SAP HANA, we quickly aggregate data into a central data lake for centralized batched reporting.
  • Repetition of the same extract or transform for different needs. We can use variables to use the same ETL job for different types of aggregations.
  • Reliability of the jobs through the use of audit features. We can add audit gates to check for table counts and automatically send out notifications and alerts.
  • Heavy processing is required to run the standard transformations. We get around this by creating custom SQL transforms, but lose insight when we take this approach.
  • Delta loading is possible but sometimes difficult. It sometimes requires customization that creates maintenance issues.
  • As an enabler of SAP HANA, it's required. So, it's a positive ROI when SAP HANA is factored into the equation.
  • We use SAP Data Services for migration into SAP migrations, and this creates a positive ROI for our implementations for new or existing clients.
SAP Data Services is better at integration with other SAP products and data sources with native HANA connectors. There are also accelerators to consider when looking at it as a data migration tool for SAP implementations.
It's an established product with a large community and easy to reach experts.

Do you think SAP Data Services delivers good value for the price?


Are you happy with SAP Data Services's feature set?


Did SAP Data Services live up to sales and marketing promises?


Did implementation of SAP Data Services go as expected?


Would you buy SAP Data Services again?


It's definitely one of the leading ETL tools, and it's the best ETL tool to use with SAP integration. If you use SAP HANA, then you should think about Data Services as your primary ETL tool.

SAP Data Services Feature Ratings

Data source connectivity
Data profiling
Master data management (MDM) integration
Data element standardization
Match and merge
Address verification