SAP Data Services Part 2: Integrating with SAP BW on SAP HANA
- by Michael Vavlitis, Program and Project Associate Manager, Accenture MCaaS (Mortgage and Compliance as-a-Service)
- March 15, 2017
Learn the process of loading data into an SAP BW on SAP HANA system using SAP Data Services and SAP BW extractors. Explore some of the advanced data-transformation options and learn how to leverage existing SAP BW extractors to rapidly load data to an SAP HANA enterprise data warehouse.
By reading this article, you will:
- Explore SAP BW extractors and how they integrate with SAP Data Services to populate an SAP BW on SAP HANA system
- Learn how to extend transformations with custom logic
- Learn about the latest capabilities of SAP Data Services as of version 4.2 and as it pertains to SAP BW on SAP HANA
SAP extractors are designed for SAP BW business data, meaning that they include most of the requisite logic for typical summaries, transformations, and delta-loading processing. Therefore, SAP BW extractors are useful tools when building a data warehouse. SAP Data Services 4.x supports reading from extractors.
SAP Data Services 4.2 is certified by SAP for use with SAP BW up to version 7.5 and SAP HANA 1.0 SP12, see the SAP Data Services Product Availability Matrix (PAM) for details. To use an SAP data source for SAP Data Services, you need to configure an SAP Data Services DataStore. This DataStore represents the logical link that enables metadata to be imported. (It is worth noting that SAP Data Services connectivity to SAP BW standalone or SAP BW on SAP HANA involves the same options and steps. Thus, the terms SAP BW and SAP BW on SAP HANA are synonymous and used interchangeably throughout this article.) SAP Data Services can be implemented as both an inbound provider (with data sources) and as an outbound provider (with InfoProviders and open hubs).
This article is the second in a three-part series of articles about SAP Data Services. In the first part, “SAP Data Services Part 1: Integrating with SAP Business Suite Sources
,” the focus is on learning about the SAP Data Services interface and processes, as well as how to leverage SAP Data Services for extraction, transformation, and loading (ETL) of data to integrate with SAP Business Suite sources. In the next (and final) article in this series, the focus will be on integrating SAP Data Services with SAP HANA standalone implementations.
To load data that is extracted from an SAP BW system into SAP HANA using SAP Data Services, you need to establish a Remote Function Call (RFC) connection. To extract data from an SAP BW InfoCube, you need to create an SAP BW open hub and SAP BW process chain. To achieve this, create an RFC destination (TCP/IP) as a registered program in SAP BW.
The next step is to create a connection to the RFC server using the Data Services Management Console, which links to the SAP BW RFC connection that was established. Finally, an SAP Data Services job is built that runs the SAP BW open hub that extracts the cube data to the SAP BW database table. Subsequently, SAP Data Services queries the data through the RFC via the SAP Data Services server. This server then loads it into SAP HANA. SAP HANA studio offers compatibility with SAP Data Services to access external metadata.
Would you like to see this full item?