Loading data into SAP HANA using DXC

This recipe explains how to load data into SAP HANA by using Direct Extractor Connection (DXC).

Getting ready

The data provisioning techniques we have come across so far require separate installation of the software components. Using DXC, we can load data into SAP HANA from the SAP source systems. Also, we can use all the standard data sources that come as a part of SAP Business Content, which were originally developed with the use of SAP Business Information Warehouse (BW). We go for DXC mostly in the case of BW on HANA. SAP BW will use all the data sources delivered and their related data objects, such as DataStore Object (DSO) and cubes, for deployment. SAP standard data sources are built on several base application tables. Re-implementing these in SAP HANA by replicating individual tables involves high costs and a lot of work. DXC allows us to use all the standard data sources, and data can be loaded to SAP HANA in the same way as we load data into...