Data Integration Tools » SAP Data Services Reviews » Version 4.2 SP11 » Review

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.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Author
BUYER'S GUIDE
Download our free Data Integration Tools Report and find out what your peers are saying about SAP, Informatica, Microsoft, and more!
Download Now
Sign in to see all reviews and comparisons. It's free!
By clicking Sign in with LinkedIn™ you agree to let IT Central Station use your LinkedIn profile and email address in accordance with our Privacy Policy and agree to the Terms of Service.
Sign Up with Email
  • Unlimited access to 30000+ reviews from real users
  • Your own page to promote your professional skills
  • Join a community of experts to call upon for support
As seen in:

By registering, you agree to our Terms of Service and Privacy Policy.
  • Unlimited access to 30000+ reviews from real users
  • Your own page to promote your professional skills
  • Join a community of experts to call upon for support
As seen in