Linked Service with ADF for SAP BW MDX to Azure SQL

Akshay Arukandy 1 Reputation point
2021-08-11T11:31:39.817+00:00

Hi,
We are trying to build a connection in my Windows Integration Runtime Machine to the SAP BW using SAP Netweaver RFC SDK.
Are there any steps to be taken care of while doing the same? Or any other connectors to be installed?

Also, are there any documentations available for establishing and extracting data from SAB BI/BW MDX Queries/Cubes to Azure SQL?

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,024 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Saurabh Sharma 23,781 Reputation points Microsoft Employee
    2021-08-11T22:48:26.417+00:00

    Hi @Akshay Arukandy ,

    Thanks for using Microsoft Q&A !!
    You can use SAP BW connector in ADF for Copy and Lookup activities. This connector supports:

    • SAP Business Warehouse version 7.x
    • Copying data from InfoCubes and QueryCubes using MDX
    • Authentication mechanism - BASIC (Username/Password)

    Also, this connector is supported through SHIR and you need to install SAP NetWeaver Library which you can either get it from :

    You can refer to the Copy data from SAP Business Warehouse using Azure Data Factory documentation for more details. Additionally, you can refer to SAP Integration Whitepaper to get details on SAP connector.

    Please let me know if you have any other questions.

    Thanks
    Saurabh

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.