Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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