Azure / Azure/Azure-DataFactory

[Critical] SAP BW via MDX connector -- missing Load balancing option

Open
#663 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PowerShell
Stars
529
Forks
623
PR merge metrics
No merged PRs in 30d

Description

Hi Team,

The [SAP BW via MDX connector](https://learn.microsoft.com/en-gb/azure/data-factory/connector-sap-business-warehouse?tabs=data-factory#linked-service-properties) service does not have options to connect to the Target SAP BW system with Logon Load balancing - message server/service details.

In comparison to [SAP BW Open Hub Integration](https://learn.microsoft.com/en-gb/azure/data-factory/connector-sap-business-warehouse-open-hub#linked-service-properties), the SAP BW via MDX does not have properties - **messageServer** & **messageServerService**. But has connection details as **server** & **systemNumber** pointing to one APP Server of SAP BW.

For Production or in general -- This way of connecting to one SAP APP server Instance is a SPOF(Single point of failure) when the target SAP App server of the SAP BW system becomes unavailable or overloaded or having performance issues.

Please review if this way of connectivity is intended or unintentionally missed. Adding load balancing based connection method will improve the reliability of this connecter.

**SAP Server logon Load balancing:**
SAP System are configured / installed with one or more than one nodes (called SAP Application Server or SAP Application Instance in SAP World).
https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/48/a8c4a95134307be10000000a42189b/content.htm?no_cache=true
https://help.sap.com/docs/SUPPORT_CONTENT/si/3362959490.html

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.