OAC Managed Service - Can Report Output Be Shared to an Sharepoint/Cloud Service/Storage Appliance

Question

Hello.

Is it possible to deliver report output/data extracts to a storage appliance, a Sharepoint site, or a Cloud service location using the managed service version of OAC?

If yes, could I get information regarding how to setup and organize my data to drop at an external location?

AS we move from OnPrem OBIEE to OAC managed service, we use Java methods to port data and reports to our storage appliance, Sharepoint site(s); as well as, dropping the data on the application server to be picked up by other applications.

Thank you for your time.

Steve F-2 · Accepted Answer

Hi Rod,

Thanks for posting your question in the Oracle Analytics community.

You won't find the exact option of sending an agent to a java app.

I think your options would be to review the SOAP API for classic analysis/dashboards, the Publisher web services.

The OAC REST API can  download the exported PDF or PNG output created by workbook export. Any export could saved to a "cloud/shared" drive you have configured.

There are supported datasources that can support saving output from data flows.  I realize that is not really what you are looking for, but thought it was mentionable in case you wanted to "rethink" your use-case.

There are UI options, but I assume you are aware of those or not in the context of your request.

we use Java methods to port data

Oracle Analytics is an analysis platform, not an ETL utility so exporting data is not the feature priority.

https://community.oracle.com/products/oracleanalytics/discussion/comment/68967#Comment_68967

Other comments welcomed.