- Data warehousing project (with CDC or comparison table to update our histories).
- Four sources: SQL Server, Oracle, SAP ECC, Excel file.
- One target: Azure SQL Data Warehouse.
- Complex transformation to load the Data Warehouse (good and simple optimization).
SAP Data Services Review
Enables ability to change the source and target from Oracle to SQL without changing your code
What is our primary use case?
How has it helped my organization?
- It's very simple to build a data flow.
- The development is faster than SSIS or Talend.
- Impact analysis is very useful to know who used this KPI (the report on the user that had access to this report).
- Profiling data is very useful to know the interesting fields.
What is most valuable?
- Portability of development (you can change your source/target from Oracle to SQL without changing your code).
- Web console monitoring.
- Auto-documentation.
- Simple toolbox with all you need.
What needs improvement?
- Development with web tool (today is with client tool).
- Connection to Active Directory to extract user and group.
- A PaaS cloud service (today is on-premise).
- Better connection to SAP BW.
For how long have I used the solution?
More than five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Jan 22 2019
Author
Gérald GAUTIER
President with self employed
Consultant
BUYER'S GUIDE
Download our free Data Integration Tools Report and find out what your peers are saying about SAP, Informatica, Microsoft, and more!
