Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
FAW RDG Agent connectivity through external application merge
Is it possible to connect on-prem DB from FAW external application merge?
As per the below documentation it's possible to connect on-prem DB from DV using RDG agent.
https://docs.oracle.com/en-us/iaas/analytics-for-applications/doc/oracle-fusion-analytics-warehouse.html
When we merge external RPD, can we use connection pool to connect the RDG agent? please let me know if this is something that can be achieved.
Thanks,
Shiva
Answers
-
@User_RL5X2 - First, this should be a question and not an idea/ER.
To answer your query, yes we can use RDG to connect to external DB using the "Remote Data Connectivity" option mentioned in the document and create DV datasets and workbooks using the same.But, it wouldn't work with External RPD merge feature as the external semantic model connects only to the Oracle Autonomous Data Warehouse associated with Oracle Fusion Data Intelligence. After enabling the external application merge functionality, if you make semantic model changes with data augmentation, then it'll result in unexpected errors. If such changes exist, then you must update the data augmentations to remove the semantic model changes. Ensure that you make the semantic model changes in the external semantic model.
Prior to merging the external semantic model, ensure that you:
- Import or migrate your external warehouse data to the Oracle Autonomous Data Warehouse associated with Oracle Fusion Data Intelligence using the Oracle database utilities or any ETL tool.
Reference:
0
