SAP Data Services Part 1: Integrating with SAP Business Suite Sources

  • by Michael Vavlitis, Program and Project Associate Manager, Accenture MCaaS (Mortgage and Compliance as-a-Service)
  • October 11, 2016
Gain an overview of SAP Data Services and how to extract data by leveraging SAP Business Suite extractors.
Learning Objectives

By reading this article, you will:

  • Learn about the SAP Data Services interface and processes
  • Find out how to leverage SAP Data Services for extraction, transformation, and loading (ETL) of data to integrate with SAP Business Suite sources
Key Concept
SAP Data Services can integrate with the SAP Business Suite to transport data by using extractors that streamline the extraction, transformation, and loading (ETL) process for this type of deployment.

SAP Data Services (formerly SAP BusinessObjects Data Services, sometimes referred to as BODS) offers an enterprise solution for data integration, profiling, quality, and text processing that enables users to integrate, transform, and load data. SAP Data Services is a comprehensive extraction, transformation, and loading (ETL) tool that supports loading of structured and unstructured data from SAP and non-SAP data sources into any SAP HANA application. When an external ETL tool is required in an SAP landscape, SAP recommends that you use SAP Data Services. SAP Business Suite powered by SAP HANA offers an in-memory platform for reporting and analysis of business processes in real time with data extractors that are compatible with SAP Data Services.

There is no one-size-fits-all solution when deciding which approach to take when integrating SAP Data Services to SAP Business Suite systems. Your approach depends on your custom system landscape and licensing, as you may or may not already have access to SAP Data Services. Whether you choose to implement SAP Data Services or prefer an alternative, such as Direct Extractor Connection (DXC), you must be prudent in considering all the nuanced benefits and constraints that each approach presents. I highlight the intricacies that each option presents to guide you on your next data integration endeavor.

What Is SAP Data Services?

SAP Data Services combines the ability to execute data integration and ensure data quality and data cleansing. In general, the tool consists of the components shown in Figure 1. The data quality functionality includes the ability to standardize data, as well as to perform geo-coding and matching operations. The data-integration component offers profiling and auditing of data, and also analysis of text files. Aggregations, calculations, filtering, joins, and look-ups are all also possible with this interface.


Figure 1
SAP Data Services’ components and capabilities

Michael Vavlitis

Michael Vavlitis is a proven business professional who has successfully completed projects and implementations in the U.S. and Canada. His practical experience ranges from business intelligence development and reporting using SAP Data Services, SAP HANA, SAP BW, and SAP BusinessObjects, as well as serving in a project team lead role.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.