Oracle Analytics and AI

Kirk Li

Hello Group,

Our analysis currently spans multiple topics, with data sourced partly from Oracle Fusion Subject Areas and partly from external data in ADW (Autonomous Data Warehouse). Given this setup, I have two main questions:

1. Would using Oracle's Semantic Modeler be advisable for our hybrid data sources?
2. If we decide to implement the Semantic Modeler, should we continue to use Fusion Subject Areas as the data source for Fusion content, or is there a way to fetch data directly from the Fusion database?

Any insights or suggestions would be greatly appreciated!

Thank you!

Nathan CCC

Hi,

This forum is for Oracle Transactional Business Intelligence OTBI in Oracle Fusion Cloud Applications. Semantic Data Modeller is NOT in OTBI. Semantic Data Modeller is in Oracle Analytics Cloud OAC. OTBI in Oracle Fusion Cloud Applications is not implemented using Oracle Analytics Cloud (OTBI uses the "legacy" OBIEE).

BTW The recommended by Oracle good practice method for "bulk" extract of data from Oracle Fusion Cloud Applications is to use Business Intelligence Cloud Connector BICC. This will get incremental CSV data files to your out of the box Universal Content Management or an external object storage you have purchased. You will need to use a data integration tool to load your bicc extract files to your data source.

But if you have OAC then you have 2 additional options

1) OAC Applications Connector to get a “real time” connection to the subject areas in OTBI in Oracle Fusion Cloud Applications. Bypass BICC with a connection to OTBI as a data source (no extract load).

2) OAC Data Replication to automatically get the files output from the data extraction from Business Intelligence Cloud Connector (BICC) to load incremental into your selected external database.  

For more information see

Oracle Fusion Cloud Applications
Creating a Business Intelligence Cloud Extract G12410-01 24D

https://docs.oracle.com/en/cloud/saas/applications-common/24d/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) 

Oracle® Cloud Connecting Oracle Analytics Cloud to Your Data F25037-47 

July 2023 Part II Connecting Oracle Analytics Cloud to Your Data 

Connect to Oracle Fusion Cloud Applications Suite 

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-fusion-cloud-applications-suite.html#GUID-FDC9B8BD-4CC4-4AA2-8C02-1078E4FA32A2

Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM) 

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-epm-cloud.html#GUID-3DF935C1-82D2-49BB-A0E4-4848BA3D2602

Oracle® Cloud Configuring Oracle Analytics Cloud E81766-64 July 2023 Advanced Configuration Replicate Data  

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/typical-workflow-replicate-data.html#GUID-959FF422-A1BE-4591-9732-5E35D7E76203