SAP HANA and Business Warehouse data integration with Azure Data Factory. You can create data integration solutions using the Data Factory service that can ingest data from various data stores, transform/process the data, and publish result data to the data stores. Microsoft today announced that Azure Data Factory now enables movement of data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores.

  • The SAP HANA connector supports copying data from HANA information models (such as Analytic and Calculation views) as well as Row and Column tables using SQL queries.
  • The SAP BW connector supports copying data from SAP Business Warehouse version 7.x InfoCubes and QueryCubes (including BEx queries) using MDX queries. To establish the connectivity, you need to install the latest Data Management Gateway (version 2.8) and the SAP NetWeaver library.

Get started

In the source data store gallery, you will find SAP HANA and SAP BW as follows:

SAP HANA

After selecting SAP HANA from the gallery, specify the connection info on Data Management Gateway name, HANA server, user name and password.

Then you will see a page with navigator and query editor. Browse and pick the measures and dimensions, a base SQL query will be auto generated in the Query Editor as reference according to your selection, and you can review and further customize there. Click Validate Query to see the preview data and schema.

SAP BW

After selecting SAP BW from the gallery, specify the connection info on Data Management Gateway name, BW server, system number, client ID, user name and password.

Then you will see a page with navigator and query editor. Browse and pick the measures and dimensions, a base MDX query will be auto generated in the Query Editor as reference according to your selection, and you can review and further customize there. Click Validate Query to see the preview data and schema.

Once you finish your settings on SAP source, continue following the wizard to configure the destination.