SAP Data Services

SAP Data Services

SAP Data Services

Overview

Reviews

SAP DS - BEST ETL TOOL

8
Data Services is used in our organization to extract the data from Tera data and flat file to load it into Hana with the help of DATA …

SAP Data Services

7
We use SAP data services as the ETL tool to move data across systems. It is a very powerful tool that allows us to harmonize the data …
Read full review

My SAP Data Services Review

8
We use SAP Data Services in the IT department as one of our ETL tools. It lets us integrate data from many data sources in an easy way …
Read full review

My SAP Data Services Review

10
SAP Data Services allow us to integrate data from many data sources to our corporate data warehouse. It is used by the technicians of our …
Read full review

SAP Data Services Review

8
SAP Data Services is used to transform and insert information from other systems into SAP. It is the software used to integrate SAP with …
Read full review

SAP Data Services review

8
SAP Data Services is used as an integration tool within the group BI solution. It is mainly used to load sources that do not support …
Read full review

Popular Features

View all 6 features

Data profiling (12)

8.0
80%

Data element standardization (12)

8.0
80%

Data source connectivity (12)

7.4
74%

Match and merge (12)

7.0
70%

Reviewer Pros & Cons

View all pros & cons

Pricing

View all pricing
N/A
Unavailable

What is SAP Data Services?

SAP Data Services is an offering from SAP to improve data quality.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

3 people want pricing too

Alternatives Pricing

What is Boomi?

Boomi is a cloud-based, on-premise, or hybrid integration platform. It offers a low-code/no-code interface with the capacity for API and EDI connections for integrating with external organizations and systems, as well as compliance with data protection regulations.

What is TIBCO Cloud Integration (including BusinessWorks and Scribe)?

TIBCO Cloud™ Integration is an enterprise iPaaS platform. It offers a drag-and-drop and API- led design approach for user-friendliness.

Features Scorecard

Data Quality

7.6
76%

Product Details

What is SAP Data Services?

You cannot afford to run your business on questionable data. SAP® Data Services software allows you to access, transform, and connect data to fuel your critical business processes. SAP aims to enable data integration and data quality, providing the right level of insight across your business so you can make better decisions and operate more effectively.

SAP Data Services Features

  • Supported: Gain access to your data anytime, anywhere
  • Supported: Integrate tightly with SAP applications
  • Supported: Interconnect with SAP Data Hub

SAP Data Services Competitors

SAP Data Services Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Alternatives

View all alternatives

Frequently Asked Questions

What is SAP Data Services?

SAP Data Services is an offering from SAP to improve data quality.

What is SAP Data Services's best feature?

Reviewers rate Data profiling and Data element standardization and Address verification highest, with a score of 8.

Who uses SAP Data Services?

The most common users of SAP Data Services are from Enterprises and the Information Technology & Services industry.

Reviews and Ratings

(30)

Ratings

Reviews

(1-12 of 30)
Companies can't remove reviews or game the system. Here's why
Karlos Dickson | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
SAP Data Services is a helping tool for our company in providing services of data mapping, data profiling, and data source connectivity with our different databases. It has been a great tool for ETL purposes and provides the best data management solution for the cause. SAP Data Services is also very effective in handling multiple thread massive data and does the job very well for our company. We also use SAP DS for reporting and analytics of data purposes. The solution is available for all the employees in the company.
  • Data mapping and profiling.
  • Good tool for managing and controlling the data.
  • Easy integration with different data bases.
  • Good for reporting and data analytics.
  • Limited connectivity options with the cloud solutions.
SAP Data Services is a great tool for managing and mapping big data with easy setup and integration processes. The metadata administration provided by the SAP DS is also very effective and saves a lot for the organizations which deal with heavy data management issues. Recommended for the companies and businesses looking for a reliable data services tool.
December 09, 2021

Data Service - Future

Score 6 out of 10
Vetted Review
Verified User
Review Source
Maximize the value of all your organization’s structured and unstructured data with exceptional functionalities for data integration, quality, and cleansing.
  • cleansing
  • quality
  • data integration
  • Change Data Capture
  • Data Services Workbench
  • Cloud Platform Integration – Data Service (CPI-DS)
SAP Data Services is a data integration and transformation software application. It allows users to develop and execute workflows that take data from predefined sources called data stores (applications, Web services, flat-files, databases, etc.)
December 08, 2021

SAP DS - BEST ETL TOOL

Rakesh Sharma | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Data Services is used in our organization to extract the data from Tera data and flat file to load it into Hana with the help of DATA SERVICES JOBS . as it is very convenient to map from non SAP source to SAP mapping. This helps in running the batch jobs and real-time jobs with massive data.
  • Handle Massive data so well for ETL purpose
  • different types of transformation is available in one go .
  • Job scheduling and maintanence is user friendly
  • It should have option of loading data as triggered based as well
  • Extracting flat files data should be automated with single click.
  • Should have the option to trigger the HANA procedure directly with putting it into data foundation
Data services are well suited when you have massive data to dump into the HANA system with the help of Batch Loading of data. Data services can be also used when you have the non SAP source and data need to be loaded in the SAP system. when it comes to real-time data. This is not so much suitable as compared to SLT or other tools.
Score 10 out of 10
Vetted Review
Reseller
Review Source
SAP Data Services is the primary ETL tool for many of my clients. We use it to move, manage, and control data to meet reporting and analytics needs. Paired with SAP HANA, we quickly aggregate data into a central data lake for centralized batched reporting.
  • Repetition of the same extract or transform for different needs. We can use variables to use the same ETL job for different types of aggregations.
  • Reliability of the jobs through the use of audit features. We can add audit gates to check for table counts and automatically send out notifications and alerts.
  • Heavy processing is required to run the standard transformations. We get around this by creating custom SQL transforms, but lose insight when we take this approach.
  • Delta loading is possible but sometimes difficult. It sometimes requires customization that creates maintenance issues.
It's definitely one of the leading ETL tools, and it's the best ETL tool to use with SAP integration. If you use SAP HANA, then you should think about Data Services as your primary ETL tool.
It's an established product with a large community and easy to reach experts.
Martin Lopez | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source
I have used the SAP Data Services platform for more than 10 years since its inception when the tool was owned by Business Objects. This tool has demonstrated its full potential in ETL implementations, data quality projects, SAP ERP migrations and proof of concept with great results and complete compliance from the users.
  • The ETL construction process its very easy. Its ease of use and the fact that the design of the processes is completely graphic makes its learning process very fast.
  • Support on ETL Migration.
  • Data Quality Projects.
  • Metadata Administration.
  • Its connectivity capabilities with different database platforms, applications and cloud systems are excellent and has been growing with the evolution of the different versions.
  • New connectivity options for cloud solutions must be added.
  • Avoid dependency from flash in Information Steward scorecard.
  • More connectivity options for hadoop distributions.
This tool has demonstrated its full potential in both ETL implementations, data quality projects, SAP ERP migrations and proof of concept.
We offer this support and also we got great support from SAP.
Kiran Bhat | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Data Services is used mainly within IT to migrate data from our legacy system into SAP ERP. DS is used for selection, enrichment, validation and transfer of data.
  • Integration with SAP ERP/ECC works really well.
  • A lot of flexibility in data creation, with different types of communication capabilities like BAPIs, IDocs, and Batch input.
  • Reliable and consistent results and easily enforceable data templates.
  • Initial setup of rules requires more technical expertise than master data management teams are typically used to.
DS is extremely well suited for legacy data migration, enrichment, and validation. The large data volumes can easily be handled by the system and this reduces the deployment time, especially for SAP ERP. The error reports accurately provide problematic data and it is very easy to create organization-specific data validation rules.
October 18, 2018

Review from a new user

Himanshi Arora | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • Extracting data from various types of data sources
  • Transforming data using joins, functions, look ups, etc.
  • Loading data into different kinds of targets
  • 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.
It is well suited when you want to extract data from a source supported by data services, to perform various transforms on that data (such as joins, look ups, applying functions, performing delta merge, etc.,) and also to further load the transformed data into the target. Data Services allows you to schedule the jobs as per your business requirement. Therefore, you can manage the loading of data into the target as per your needs.

I have faced issues in performing one time updates for historical data using Data Services. Map operation does not behave the way it should and therefore I would not recommend it for those scenarios.
December 10, 2019

SAP Data Services

Score 7 out of 10
Vetted Review
Verified User
Review Source
We use SAP data services as the ETL tool to move data across systems. It is a very powerful tool that allows us to harmonize the data because it gives us many options for transformation.
  • Data transformation capabilities
  • Native connectivity
  • Not usable for end users. It is very technical.
It is well suited in the case where you have some SAP systems in your IT ecosystem. It carries many out of the box tools for SAP systems.
I know there were several problems and SAP gave us good support and in good time.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use SAP Data Services in the IT department as one of our ETL tools. It lets us integrate data from many data sources in an easy way using their graphical interface. It runs especially well-integrating data from our SAP corporative ERP to our data warehouse.
  • Very easy to implement new ETL processes
  • Connectivity with SAP products
  • Spatial data support
  • Connectivity using SAP Cloud Platform
In my opinion, SAP Data services is well suited to integrate data to any data warehouse from almost any data source. It lets you do it in an easy way using their graphical interface.
As with any SAP product, we can confirm that we received excellent support from SAP.
Score 10 out of 10
Vetted Review
Verified User
Review Source
SAP Data Services allow us to integrate data from many data sources to our corporate data warehouse. It is used by the technicians of our IT department.
  • Integrate data from many data sources
  • ETL
  • Ensure data quality and data integrity in our data warehouse
  • SOAP Web service as target
  • Spatial data support
  • Extended DevOps capabilities
In my opinion SAP Data Services is the best ETL data integration tool, especially if you have SAP products in your company. It has a graphical interface that let you implement ETL processes in an easy way.
As other SAP products, there is excellent support by SAP on this tool. You can access the SAP Help portal in order to give support either from the huge community or directly from SAP.
November 29, 2019

SAP Data Services Review

Score 8 out of 10
Vetted Review
Verified User
Review Source
SAP Data Services is used to transform and insert information from other systems into SAP. It is the software used to integrate SAP with MDG.
  • Customization.
  • Processing capabilities.
  • Programming capabilities.
  • Native connectivity.
  • Not easy to use, need to reach experts even for simple transformations.
SAP Data Services is a strong ETL tool with a lot of flexibility available to transform and tune the data. In case you connect SAP systems, it offers easy configuration in order to make systems communicate well.
We did not have any problem which needed to be addressed to support.
October 12, 2018

SAP Data Services review

Score 8 out of 10
Vetted Review
Verified User
Review Source
SAP Data Services is used as an integration tool within the group BI solution. It is mainly used to load sources that do not support realtime replication.
  • Loading files from landing area into the database.
  • Integrating various sources with SAP HANA.
  • Multi-developer environments.
  • Loading of XML sources.
  • Type two dimensions could be handled more elegantly.
  • Importing HANA calcultation views into the datastore is not intuitive.
  • Scheduler is very basic.
Data services is quite easy to learn for someone with previous ETL tool experience. You are able to publish web service jobs in data services which work quite well, however note that this consumes a large amount of memory. Template tables are a very nice feature which automatically creates target tables based on the input data. This makes rapid development of new source loads very efficient.