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.

Connection Setup

📓 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 aSAP BW environment from OneCloud, 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.

Connection Example

The following is an example of a working Connection. Please substitute your own values.

⚠️ This BizApp requires the installation of a Java runtime. For best system compatibility please install Java 8.

💡 Remember to activate the Connection for the desired Environments.

Did this answer your question?