Oracle Transactional Business Intelligence

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

How to send OTBI reports to a destination folder on a network drive outside of Oracle

Received Response
71
Views
1
Comments

How can one send OTBI reports to a destination folder on a network drive outside of Oracle

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi,

    NO you cannot connect to a network drive outside your cloud. Oracle Fusion Cloud Applications is SaaS. Your host has chosen to make it so many of the features are disabled in SaaS. You cannot connect to a network drive using OBI in OTBI in SaaS like you can when you use OBI in PaaS/on-premise.

    But included in your Oracle Fusion Cloud Applications subscriptions you do get some out of the box object storage for files in Universal Content Management (UCM) on Web Center Content (WCC). In your browser go to your content server /cs/. So a solution might be to put your data files here then use your favourite data integration tool to move the files downstream to your network drive.

    The recommended method to "bulk extract" data as files is to use Business Intelligence Cloud Connector BICC not your API or a publisher report in OTBI. In your browser go to /biacm/.

    For more information see

    Oracle Fusion Cloud Applications Creating a Business Intelligence Cloud Extract F92942-01 24B https://docs.oracle.com/en/cloud/saas/applications-common/24b/biacc/index.html

    My Oracle Support https://support.oracle.com/ 

    Oracle Applications Cloud: Data Export Best Practices (Doc ID 2615185.1

    Oracle Fusion Transactional Business Intelligence and BI Cloud Connector Performance Recommendations (Doc ID 2679006.1