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, Planful, and Oracle EPM, allows OneCloud customers to tightly and bi-directionally integrate their data stored in the BW system with other apps.
SAP BW via RPC
OneCloud connects to SAP BW via RPC through 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, select the appropriate Runner, and use the SAP BW Connection Parameters to complete the setup.
The following is an example of a working connection. Please substitute your own values.
For documentation on all available commands, see the SAP BW Command Reference.