Oracle Analytics and AI

Shiva Uppushetty

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

Sumanth V -Oracle

@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: https://docs.oracle.com/en/cloud/saas/analytics/24r2/fawag/merging-external-applications.html#GUID-C2CDC6FB-FD10-4FB6-9F88-47D3558FDC43