How to Replicate Data from Azure to SAP

Paweł Adamczak
Dominik Maj

The SAP BW/4HANA system can be used as a data consolidation platform. Within the Data Warehouse, we can consume data from various source systems and provide a common semantic layer.

Let’s consider an architecture where the SAP BW/4HANA system consolidates data from regional ERP and other systems, and one of them stores data on Azure BLOB. This may refer, for example, to Sales data being maintained regionally.

In such a scenario, we want to bring the Azure data into SAP BW/4HANA, to consolidate all the data in one place. In this example, the Azure Data Factory moves the data to the SAP BW/4HANA system.
Azure pushes the content of the CSV file (ADLS gen.2 storage) to BW/4HANA, for data replication.

 

The Azure Data Factory allows us to connect with the SAP HANA database via Integration Runtime and to send the data. Once the SAP and Azure data is merged, we can build a common view of the global data.

The entire dataflow looks like this:

 

 

Once the Azure Data Factory pushes the data to the SAP HANA table, it is automatically available in the reporting layer. The transfer of 4 million records from Azure to SAP BW/4HANA took 2 minutes.

Having the Composite Provider joining data from both sources, enabled the creation of a report that shows the Sales data from across all regions. The BEX Query data can be visualized in the SAP Analytics Cloud dashboard and provides actionable insights.

 

In this scenario we were able to verify the integration option of the Azure data into the SAP systems. It has been tested and confirmed that extraction of Azure data and combining it with the data from the ERP system within the SAP BW/4HANA is possible in a reasonable time.

This solution is recommended for consolidation scenarios, where the Azure system is responsible for pushing data to the Data Warehouse. Once the data coming from Azure is populated in the SAP HANA system via the generic ODBC connector, the SAP BW/4HANA system can easily consume and expose it in the common layer for presentation, for example in the SAP Analytics Cloud.

 

To find out more, download the presentation below.

    Want more details on the above scenario?
    Download our presentation!


    For more information on SAP and Azure system integrations, contact our specialists:

     

     

     

    Paweł Adamczak
    Data warehouse architect


    Dominik Maj

    I’m a versatile IT consultant with wide experience with various data processing tools. I’ve been part of Lingaro’s Big Data Team since its very beginning, taking part in projects based on Hadoop, Spark, Elastic, Microsoft Azure, Airflow and more. Apart from IT, I’m passionate about culture and I enjoy singing which I practice in various choirs and ensembles.


    Related News