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
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.
Pros
- 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.
Cons
- 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.
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.
Do you think SAP Data Services delivers good value for the price?
Yes
Are you happy with SAP Data Services's feature set?
Yes
Did SAP Data Services live up to sales and marketing promises?
Yes
Did implementation of SAP Data Services go as expected?
Yes
Would you buy SAP Data Services again?
Yes
Comments
Please log in to join the conversation