Does SAP Business Warehouse via MDX support SAP BW/4HANA?

Question

Does SAP Business Warehouse via MDX support SAP BW/4HANA? It is not explicitly stated in the support page.

https://learn.microsoft.com/en-us/azure/data-factory/industry-sap-connectors

Answer 1

Hi @Del Mundo, Paolo Ian

To clarify, the SAP Business Warehouse via MDX connector in Azure Data Factory does not support SAP BW/4HANA. It is specifically designed to work with SAP NetWeaver BW 7.x systems only. This limitation is confirmed in Microsoft’s official documentation, even though it's not prominently stated. 
If you're working with SAP BW/4HANA, you'll want to explore other connector options within Azure Data Factory, such as: 

• SAP Table or SAP Open Hub (for direct table access) 
• SAP CDC (Change Data Capture) using the ODP framework, which is fully compatible with BW/4HANA and supports delta extraction

For reporting tools like Power BI, SAP BW/4HANA is supported via the Application Server connector. While MDX may be used internally, it’s not explicitly exposed or controllable by users. Also, please be aware that certain BEx features (like local calculations and variables) may not behave the same in Power BI, especially in DirectQuery mode. 

Please refer the below Microsoft Doc for more information
https://learn.microsoft.com/en-us/azure/data-factory/sap-change-data-capture-introduction-architecture?
https://learn.microsoft.com/sl-si/azure/data-factory/industry-sap-connectors

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.