Using SSIS to extract data from BICC

Question

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.

Ajit-Infy · Answer

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

ravikiran goda-Oracle · Answer

Please add cloud storage as external storage

Jeremy Rosser · Answer

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,