Oracle Analytics Cloud and Server

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

OAC - How to connect various ways to OTBI/ERP from OAC?

Received Response
124
Views
1
Comments

Summary

Connecting from OAC to OTBI/ERP on cloud

Content

To create datasets from source: Fusion ERP to view tables and get more data. Is there another method, except for establishing the connection to OTBI and viewing the subject areas as the amount of data we are able to view is very limited. It throws a query limit error.

Version

105.3.0-115

Answers

  • Mihaela M
    Mihaela M Rank 3 - Community Apprentice

    Currently this is the only way, using the analytics server as middleware, as the Fusion SaaS database is not exposed. There is also option to replicate data in OAC and use BICC as extractor for this.