Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Export OAC Tabular Analyses to CSV in OCI Object Storage Bucket

Received Response
63
Views
5
Comments
Alvaro_Soares
Alvaro_Soares Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

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.

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    "classic" agents can't write to OCI Object Storage from OAC. DV export also doesn't write to OCI Object Storage.

    Therefore you can't "natively" do it from there. What you could do, for DV, would be to have a script that export via the Rest API and then write to your OCI Object Storage. But you will need to write the script and run it somewhere.

    Or, of course as you said yourself, Publisher.

  • Alvaro_Soares
    Alvaro_Soares Rank 4 - Community Specialist

    Hi @Gianni Ceresa ,

    Thank you for reaching out.

    Do you have any Oracle documentation on Rest API scripts to export an Analysis? Because my user environment does not have Publisher module on their OCI .

    Thank you.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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

  • Alvaro_Soares
    Alvaro_Soares Rank 4 - Community Specialist

    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

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    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.