Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

HOW TO CONNECT ORACLE CLOUD INFRASTRUCRE OBJECT STORAGE FROM MICROSOFT POWER BI TOLL.

Team,

 

I have a requirement to read the Parquet file stored under ORACLE CLOUD INFRASTRUCTURE (OCI) OBJECT STORAGE under buckets , my data resides. So i'm checking: can we read these data file from Oracle Object Storage in MS Power BI tool and can we construct new reports?

Interesting Links
Need Help
Tutorial Requests

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Icon for Super User rankSuper User
    1 year ago

    Hello Anonymous,

     

    If you have access to Oracle's OCI Data Integration or Oracle Autonomous Data Warehouse (ADW), you can integrate Object Storage data with Power BI through a database or ODBC connection.

     

    1. First, use OCI Data Integration or Data Flow tools to load Parquet data into an Oracle ADW table.

    2. Then, set up a direct query or import mode connection to ADW (Get Data > Oracle Database in Power BI Desktop)

    3. Enter the ADW connection string and credentials - query the loaded data and build your reports.

     

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks, Sahir! for acknowledging my question.

     

    Let me explain Use case: I'm exporting Fusion Data Intelligence Analytics needed warehouse tables/objects by using the inbuilt ETL extract feature, and that extracts all the needed objects under OCI Buckets in Object Storage in form of Data (Parquet format) and Metadata (Avro format). Now I want to leverage these objects into the MS Power BI desktop tool to avoid using any ETL tools to reduce the commercial purpose.

     

    Hope you're clear with my use case.

     

    One more question: is this OCI Object Storage option available in the PRO or Premium version?

     

    Thanks,

    Guru