You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BICC and external storage

Received Response
20
Views
4
Comments
edited May 3, 2021 3:36PM in Oracle Analytics 4 comments

Summary

Need recommendation how to automate data flow from BICC to DW

Content

Was researching what options are available to automate data flow from BICC to corporate DW

Ended up with 3 distinct options:

  1. Use seeded capability to extract PVO to UCM. Then build custom bash script to download extracts and upload to corporate FTP, then use standard data loading to DW
  2. Configure external storage in BICC and leverage native capability to pull data to DW. for example Amazon (but read that BICC can only extract PVO to UCM or OCI Storage Container; see https://cloudcustomerconnect.oracle.com/posts/7383390b51?commentId=273695#273695

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!