Azure / Azure/Azure-DataFactory
[Critical] SAP BW via MDX connector -- missing Load balancing option
- 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
Assessment
This issue has not been assessed yet.