The OneCloud SAP Business Warehouse BizApp enables OneCloud to natively integrate with SAP BW to execute MDX queries and extract tabular data directly for use in an external system. Combining the ability to perform high-speed data extraction operations across other applications including Tableau and Power BI and performance management applications such as Anaplan, IBM Planning Analytics, Host Analytics, and Oracle EPM, allows OneCloud customers to tightly and bi-directionally integrate their data stored in the BW system with other apps.
For documentation on all available commands, see the SAP BW Command Reference.
Need a specialized SAP BW Command?
If there are specific SAP BW operations that your company is looking to perform firstname.lastname@example.org to discuss the requirements and the possibility to incorporate the capability into OneCloud.
SAP BW via RPC
OneCloud connects to SAP BW via RPC. via the published REST API and does not require anything specialized except connectivity to the service.
To automate functionality within your SAP BW environment from OneCloud, you’ll need to navigate to the connection manager to create a connection.
From here, choose SAP BW from the service drop-down and select the appropriate Runner. Now, enter values for the following fields:
|Username||TextField||SAP BW username|
|Password||TextField||SAP BW password|
|Server Hostname||TextField||The IP address or hostname of the SAP Netweaver instance. (e.g. 18.104.22.168)|
|Client||TextField||The Client ID used for the RFC connection (e.g. 001).|
|Instance Number||TextField||The Instance Number defined in the RFC destination.|
|SAP Jco Installation Folder||TextField||The path to the SAP Jco installation. (e.g. C:\onecloud\sap-jco)|
The following is an example of a working connection. Please substitute your own values.