There are many posts and documents on connecting to the SAP BW system by installing the self-hosted integration runtime on a windows server. Still, my problem is the sap BW system is running on a Linux environment. Has anyone successfully created a connection from Azure data factory or synapse pipeline to SAP BW running on a Linux environment?
Asked
Active
Viewed 195 times
1 Answers
0
Below are the steps to connect BW to Azure using the OHD connector.
- Whitelist the Self-hosted integration runtime IP from the BW systems and allow the port 3301(depends on the system number of BW) to connect to the SHIR.
- Create a technical/service user in sap bw to be used for data loading
- 64-bit SAP Connector for Microsoft .NET 3.1 need to be installed on the SHIR host system.
- SAP BW Open Hub Destination (OHD) is created with the destination type "Database Table"
- The SAP BW user needs the following permissions:
Authorization for Remote Function Calls (RFC) and SAP BW.
Permissions to the “Execute” activity of the S_SDSAUTH authorization object. - create the dataset/linked service using the SAP BW Open Hub connector with the detail of the OHD from step 3
deba prasad nayak
- 21
- 6