SAP Data Services Part 3: How to Extract, Transform, and Load Data into SAP HANA

  • by Michael Vavlitis, Program and Project Associate Manager, Accenture MCaaS (Mortgage and Compliance as-a-Service)
  • June 12, 2017
Examine and compare the classic SAP Data Services approach for extracting, transforming, and loading (ETL) processes to the functionality that is native to SAP HANA to determine optimal integration.
Learning Objectives

By reading this article, you will:

  • Explore the options for implementing SAP Data Services to load data into SAP HANA
  • Highlight the latest extract, transform, and load (ETL) functionality that is now native to SAP HANA and how it affects its integration with SAP Data Services
Key Concept
Certain extract, transform, and load (ETL) processes have been pushed to SAP HANA, which directly affects the integration with SAP Data Services. ETL is a requisite step in a data-warehousing implementation that involves the movement of data from an existing legacy system to a new repository. It encompasses the entire end-to-end process of loading data from a source system to its ultimate destination. The extraction step involves pulling data from the source system while minimizing the performance impact on the active source system. The transformation step typically includes a set of applied conditions that morph the data into the expected output, such as applying filters or conversions of units or currencies. Once the transformation step is completed, data is subsequently loaded into the target data warehouse.

With the extract, transform, and load (ETL) functionalities becoming native to the SAP HANA platform, the future switch from SAP Data Services (formerly SAP BusinessObjects Data Services) to SAP HANA is inevitable. SAP’s slogan is Run Simple, so the consolidation of this functionality is an especially fitting example of that approach. The emergence and growth of SAP HANA signifies a trend that compels industry experts to remain informed regarding the latest functionality. In this article, I offer insights into the future of ETL on the SAP HANA platform.

I show how SAP Data Services currently integrates with SAP HANA and how SAP Data Services’ future is impacted by the upcoming native ETL functionality that SAP HANA will include, such as smart data integration and smart data quality. In the first article of this series, “SAP Data Services Part 1: Integrating with SAP Business Suite Sources,” I covered the interface and processes of SAP Data Services, as well as the integration of SAP Data Services with SAP Business Suite sources. In the second article, “SAP Data Services Part 2: Integrating with SAP BW on SAP HANA,” I explored the integration of SAP Data Services with SAP BW on SAP HANA and how BW extractors can be leveraged during the ETL process.

In this article, I also cover the latest capabilities of SAP Data Services (version 4.x onward) and how they integrate with SAP HANA (Support Package Stack 9 onward). As of Support Package Stack 9 (released October 2014), SAP HANA offers enhanced capabilities for achieving data integration, data quality, and data streaming. Prior to SAP HANA Support Package Stack 9, SAP Data Services typically served as the primary tool for these tasks on hundreds of projects that required ETL processing of data. Nevertheless, SAP Data Services maintains a considerable role and is not being phased out anytime soon. I examine and explain the future of SAP Data Services in the ETL landscape and how it aligns with the new functionality offered by SAP HANA.

New ETL Services Offered by SAP HANA

As of Support Package Stack 9, SAP HANA offers smart data integration, smart data quality, and smart data streaming. The latest SAP HANA tools now mirror most of the data integration and quality capabilities offered by SAP Data Services. The smart data streaming functionality enables acquisition, investigation, and response to real time event data within the SAP HANA application.

SAP HANA’s Effect on SAP Data Services

SAP Data Services is a versatile tool for linking a multitude of source and target systems. Furthermore, it offers unlimited scalability and is adept at handling intricate transformations. The benefits of SAP HANA smart data integration and smart data quality are that a cumbersome client application is no longer required and the system architecture has been streamlined. Thus, the latency and performance issues that often occur in SAP Data Services when using remote repositories relative to the development application can be circumvented.

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

6/24/2017 8:04:18 PM
Raj

Great Work..Please do check the pics.. they are not getting displayed , When Im using Chrome
6/24/2017 8:04:16 PM
Raj

Great Work..Please do check the pics.. they are not getting displayed , When Im using Chrome
6/24/2017 8:04:13 PM
Raj

Great Work..Please do check the pics.. they are not getting displayed , When Im using Chrome

Please log in to post a comment.

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