Ability to store output BI Publisher to object storage on OCI — Oracle Analytics

Oracle Analytics Publisher Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Publisher Idea Lab

Categories

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

Ability to store output BI Publisher to object storage on OCI

Needs Votes
664
Views
8
Comments
Pam Koertshuis
Pam Koertshuis Rank 2 - Community Beginner
edited May 9, 2025 5:11PM in Oracle Analytics Publisher Idea Lab

Organization Name : Gemeente Rotterdam / City of Rotterdam

Description (Required): We have an external datawarehouse and need to export the data from SaaS to that datawarehouse. Not all data is available in the BI CC views, so we also need to use BI Publisher to query and download data. However, we cannot choose Object Storage in cloud as output location for the BI Publisher reports. So the work around is to build an OCI integration for this (with significantly additional cost and complexity).

Could the option to store the output in Parquet and/or .csv.gz format on object storage be added

Tagged:
25
Up
25 votes

Needs Votes · Last Updated

Thanks for Idea Pam! You idea is getting moved to the next stages which is - Needs Votes. If your idea is able to generate enough interest then it will move to the "Planned" Stages

Comments

  • Ryan Waller
    Ryan Waller Rank 2 - Community Beginner

    We have a similar need to be able to define an export via OTBI and/or BI Publisher and export the format of the data via Parquet format. The ideal situation is that the data types and structure of the data would be known at the time the Parquet file is created (since the source system knows what these fields are at the time we created the extract). This would eliminate the need for additional integration flows/ETL pipelines to be created just to copy/convert a file into a parquet format and then have to re-define or infer the data types, etc in that process when the source system already knows this information. This would also reduce our logic and validation processes that need to be done when we ingest a file that might have various delimiters (i.e. Pipe, Comma, Tab, etc).

  • ValeriaC
    ValeriaC Rank 1 - Community Starter

    Hi, how did you resolve your requirement?

  • Josh Vincent
    Josh Vincent Rank 1 - Community Starter

    This would be a tremendous help for our data engineering and warehousing tasks associated with Oracle Cloud ERP/HCM and other data. As noted above, delivery of output in .csv.gz would be ideal. As the original idea indicates, we have also found not all necessary data is available in BI Cloud Connector Console extract PVOs.

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    With more and more customers using FDI/OAC and OCI, this is increasingly becoming a must feature to have in fusion BIP.

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    Much needed feature; it'll add so much values. Upvoted.

  • ym-Oracle
    ym-Oracle Rank 3 - Community Apprentice

    I am able to schedule BIP to objectstore using OAC(FDI). I don't have access to SaaS BIP. I guess it should works.

  • Mayur_Muttur
    Mayur_Muttur Rank 1 - Community Starter

    I am looking for the same thing, scheduling BIP from SaaS to Object Storage, this is much needed feature.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Voted for the Idea.