@User_6RR5G Currently there are two ways currently to expose "gold layer" data from AIDP: (1) Connect utilizing a JDBC or ODBC connector. See examples in the Oracle docs: Connect to Compute (2) Connect utilizing a deltshare client facilitated by the AIDP data share feature. See AIDP data share docs Share Data and delta…

Agreed that a native integration into APEX would be meaningful. In a similar way that you can wrap APEX objects into PL/SQL logic, would be interesting to integrate things like python functions, calls to notebooks, AIDP catalog objects, etc into APEX objects. I'll note however that a way to "integrate" your AIDP data…

Hi @philipgodfrey - yes would agree with that

Great idea. Would add to this that maybe table comments in an integrated ADW environment could be integrated in some way for full consistency.

For anyone searching for something similar, here's how we approached this: (1) Used Document 2463485.1 to obtain a listing of all DFF PVOs. This approach assumes that this is how FDI extracts DFFs into FDI. (2) For each configured DFF, we performed a logical query executions in the OTBI admin console. The results of this…

Hi @MandeepGupta, Thanks for sharing, that's helpful to list all configured DFFs and their associated configuration attributes. However that doesn't show the OBIEE semantic model label that gets assigned based on the configured prompt. So while having the configured prompt in a BIP report is helpful, since Oracle derives…