The OneCloud BizApp for Oracle Analytics Cloud (OAC) provides a powerful way to connect and automate OAC with a range of on-premise and cloud technologies. Eliminate the need to write and manage Essbase Command-Line Interface (CLI) scripts with OneCloud’s out-of-the-box functions to execute calculations, exchange, and loading of data, and commands to administer OAC. When combined with other technologies that OneCloud supports, the possibilities become endless and truly enable a scalable, maintainable, and auditable approach to automate your enterprise.
OneCloud connects to Oracle Analytics Cloud (OAC) via the published REST API and does not require anything specialized except connectivity to OAC.
To automate functionality within your OAC environment from OneCloud, you’ll need to navigate to the connection manager to create a connection.
From here, choose Oracle OAC from the service drop-down and select the appropriate Runner. Now, enter values for the following fields:
Your OAC instance URL. In the browser, this is the portion of the URL that ends with "oraclecloud.com".
The following is an example of a working connection. Please substitute your own values.