TrustRadius Insights for SAP Data Services are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Ease of Use: Users have found the ETL tool to be user-friendly for loading data from SAP and non-SAP systems into HANA. The straightforward graphical design facilitates a quick learning curve, making the process intuitive for users who may be new to such tools. This ease of use has led to increased efficiency in managing data integration tasks.
Functionality: Reviewers appreciated the tool's functionality in creating workloads for data cleansing, data quality, and integration tasks. The ability to interface with various scheduling tools further enhances its versatility and usability across different workflows. Additionally, the seamless connectivity with multiple database platforms and applications ensures a smooth integration process without technical hiccups.
Reliability: Some users highlighted the reliability of jobs through audit features integrated within the tool. By allowing audit gates to ensure data integrity checks and providing automated notifications and alerts, users can trust that their ETL processes are running smoothly and error-free. This reliability feature contributes significantly to maintaining data accuracy in the warehouse environment.
Loading Reviews List....
SAP Data Services Reviews
2 Reviews
Professional, Scientific, and Technical ServicesInformation Technology & Services2
I have used the SAP Data Services platform for more than 10 years since its inception when the tool was owned by Business Objects. This tool has demonstrated its full potential in ETL implementations, data quality projects, SAP ERP migrations and proof of concept with great results and complete compliance from the users.
Pros
The ETL construction process its very easy. Its ease of use and the fact that the design of the processes is completely graphic makes its learning process very fast.
Support on ETL Migration.
Data Quality Projects.
Metadata Administration.
Its connectivity capabilities with different database platforms, applications and cloud systems are excellent and has been growing with the evolution of the different versions.
Cons
New connectivity options for cloud solutions must be added.
Avoid dependency from flash in Information Steward scorecard.
More connectivity options for hadoop distributions.
Likelihood to Recommend
This tool has demonstrated its full potential in both ETL implementations, data quality projects, SAP ERP migrations and proof of concept.
Data Services is used to extract, transform and load data from/to various sources such as Text files, Excel sheets, CSV files and SAP HANA tables. It is used by the IT department. It is used to address various types of business problems such as loading vendor details, cost information, customer data, material descriptions, etc.
Pros
Extracting data from various types of data sources
Transforming data using joins, functions, look ups, etc.
Loading data into different kinds of targets
Cons
Debugging is not very easy. When one wants to see the flow of data from one Query to another, the process is not very smooth and efficient.
A lot of functions do not behave the way they should. I have faced problems with the count() function.
I have faced problems while loading Excel files. The same set of options will work in one case but not in the other.
Likelihood to Recommend
It is well suited when you want to extract data from a source supported by data services, to perform various transforms on that data (such as joins, look ups, applying functions, performing delta merge, etc.,) and also to further load the transformed data into the target. Data Services allows you to schedule the jobs as per your business requirement. Therefore, you can manage the loading of data into the target as per your needs.
I have faced issues in performing one time updates for historical data using Data Services. Map operation does not behave the way it should and therefore I would not recommend it for those scenarios.