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
...at Large Enterprises
...who compared it with Oracle Data Integrator (ODI)
Free Report: SAP Data Services Reviews and More
Learn what your peers think about SAP Data Services. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
Download now
456,249 professionals have used our research since 2012.
Add a Comment
Guest
Author
Highlights
The logic is also simple. It makes it easy to build your extraction.
The user interface is ok.
The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth.
It is a powerful product with a broad range of features.
The HANA database, which is very fast, is a valuable feature.
The maintenance of data services is the solution's most valuable feature.
The reporting on the data, even from third-party software, is very good.
See more »
Buyer's Guide
Download our free SAP Data Services Report and get advice and tips from experienced pros sharing their opinions.
Download Now
Quick Links
Learn More: Questions: