Support Read Only Access to FAIDP's/FDI's ADW Table Objects from AIDP

DMD

Currently the AIDP workbench catalog functionality doesn't support access to ADW view objects, only table objects. This creates data accessibility complexities specific to FDI given that FDI only allows you to access ADW's secured view objects, but not the underlying table objects.

While this makes sense from FDI security governance standpoint, this creates data accessibility complexities specific to AIDP that requires you to leverage either: (1) manual data sync ETLs into a AIDP managed catalog or (2) ADW based delta share based access (3) notebook based connectivity through oracledb package, but then catalog functionalities are lost. So while data can still be accessed from AIDP through the above patterns, it's requires more complexity, maintenance, and data storage redundancy in comparison to if the data were accessible directly from the external catalog functionality.

An alternative solution for this is for AIDP to support view objects as a part of the external catalog functionality. Idea lab post for this scenario has been created in the AIDP idea labs:

Support view type objects in Autonomous Database based external catalogs — Oracle