Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle BICC extract. Transfer files from UCM to other destination servers like AWS S3, Oracle FTP,..

Submitted
363
Views
3
Comments
VigneshRajasekaran
VigneshRajasekaran Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Hi Team,

We created a new offering to extract the data from below list of PVOs and created a BICC scheduled job to publish the output files to UCM Server. We could able to publish the BICC data files to UCM Server successfully.

Currently we are looking for alternative options to transfer the BICC published files from UCM server to other destination server like AWS S3, Oracle FTP Server, etc. Also, we do not see other options under BICC "Configure External Storage" to configure other servers like "AWS S3, Oracle FTP Server". There are only 3 default storage options were provided in BICC including UCM Server. Can you please check and help do we have options to transfer files from UCM server to other destination servers. Attached the details for your reference.

BICC External Storage Options.jpg
BICC Job Schedules.jpg
BICC Files published in UCM Server.jpg



Regards,
Vignesh

Tagged:
2
Up
2 votes

Submitted · Last Updated

Comments

  • User_I4UPR
    User_I4UPR Rank 1 - Community Starter

    Hi Bro,

    Kindly use UCM Utility to download the PVO's (files) in a UNIX path from there load the files to the other AWS Path using Schell script!

  • VigneshRajasekaran
    VigneshRajasekaran Rank 1 - Community Starter

    Hi,

    Thanks for the update. Can you please help with the steps or any documents available to download the PVO's using UCM Utility to a UNIX Path?

  • Nagesh Manda
    Nagesh Manda Rank 2 - Community Beginner

    Hi Vignesh,

    You can use paas platform like OIC or Oracle Functions to download the files from UCM (Via Web Service https://{host}/idcws/GenericSoapPort?wsdl) and upload them into AWS.