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?

  • 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).

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.

Which version of this solution are you currently using?

4.2 SP11
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More SAP Data Services reviews from users
...who work at a Manufacturing Company
...who compared it with Oracle Data Integrator (ODI)
Learn what your peers think about SAP Data Services. Get advice and tips from experienced pros sharing their opinions. Updated: March 2021.
473,605 professionals have used our research since 2012.
Add a Comment