Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Question on Using Semantic Modeler for Hybrid Data Sources (Fusion Procurement and ADW)
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:
- Would using Oracle's Semantic Modeler be advisable for our hybrid data sources?
- 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!
Best Answer
-
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 24Dhttps://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
Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM)
Oracle® Cloud Configuring Oracle Analytics Cloud E81766-64 July 2023 Advanced Configuration Replicate Data
2
