BICC and external storage

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