Review from a new user
Overall Satisfaction with SAP Data Services
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.
- Positive for ETL
- Okay for Address Cleansing
- Negative for debugging
I have only used SAP Data Services for ETL purposes.
Comments
Please log in to join the conversation