Export OAC Tabular Analyses to CSV in OCI Object Storage Bucket

Question

Hi All,

I’m currently working with Oracle Analytics Cloud (OAC) and I have a folder containing multiple tabular analyses. My objective is to export these analyses in .csv format and store the files directly in a bucket within OCI Object Storage.

When I try to create an Agent, I do see the option to export content as .csv under the "Delivery Content" tab. However, I don't see any option to deliver or save the output directly to an OCI Object Storage bucket.

Could someone please advise if this type of export process is possible for OAC analyses, or is it only supported for BI Publisher reports?

Any guidance or documentation references would be greatly appreciated.

Thank you in advance.

GayathriAnand-Oracle · Answer

When you upload the private key file in Upload Center, make sure you choose File Type as 'SSH Private Keys'. Then when you go to setup Object Storage connection, this file will automatically appear in Private Key file dropdown.

Alvaro_Soares · Answer

Hi @Gianni Ceresa ,

It appears that BI Publisher is indeed available within our OAC environment, and the primary objective is to automate the export of a BI Publisher report in .csv format directly to an OCI Object Storage bucket.

However, during the configuration of the Object Storage connection within the BI Publisher Administration console, the field designated for uploading the Private Key File associated with my OCI user is unresponsive. My user is provisioned with the roles BI Administrator and BI Service Administrator, and I’ve successfully uploaded both .pem and .ssh key files via the Upload Center in BI Publisher. Despite this, the private key field in the Object Storage setup remains non-functional.

Is there a way to confirm whether there are specific BI Publisher or OCI permissions required for this operation? Alternatively, is this a known limitation that requires opening a Service Request (SR) with Oracle, considering this is a PaaS implementation?

Thank you

Gianni Ceresa · Answer

The Rest API for export is for DV workbooks:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/api-catalog-workbooks.html

For a "classic" analysis, you should explore the SOAP APIs:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/to_analysisexportviews_service.html#GUID-DA60F561-49B0-4013-86C6-4A9726C674C8