Using SSIS to extract data from BICC — Oracle Analytics

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

Using SSIS to extract data from BICC

Received Response
173
Views
5
Comments
Jeremy Rosser
Jeremy Rosser Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Content

Does anyone know of an easier way to extract data from BICC?  The default storage is UMC which is not easy to work with.  I am hoping there is a way to write a SSIS package to call and extract a BICC job/process.  Just looking for ideas on how to get data out of Oracle Cloud ERP in an automated fashion.

Answers

  • Olivier Sinquin
    Olivier Sinquin Rank 4 - Community Specialist

    if your fusion env is 19c I would recommend using Object Storage as the target, rather than UCM, you'll have more options/APIs to connect. This won't trigger the BICC extract though. But I believe there are APIs for that because OAC data replicator uses them to trigger the extract and storage in OCI Object Storage. Hope this helps

  • Olivier Sinquin
    Olivier Sinquin Rank 4 - Community Specialist

    also, I know you mention you want to use SSIS but ODI is now free on the Oracle Market Place... Food for thought...https://cloudmarketplace.oracle.com/marketplace/en_US/listing/59419903

  • Jeremy Rosser
    Jeremy Rosser Rank 1 - Community Starter

    I did see ODI is free and I had a quick demo by Oracle, there is just a comfort with SSIS.  I am working with the security group to let me do a POC on adding cloud storage as external storage within BICC ( I believe that is what you were suggesting).

     

    thank you,

  • ravikiran goda-Oracle
    ravikiran goda-Oracle Rank 6 - Analytics Lead

    Please add cloud storage as external storage

     

  • Ajit-Infy
    Ajit-Infy Rank 1 - Community Starter

    Hi Ravi,

    By add cloud storage as external storage I still don't see support for non-oracle products like Amazon/Google as of Jun 2023. Is there any roadmap/direction from Oracle to add support to external storage for above vendors?

    - Ajit