Oracle Analytics and AI

User_6RR5G

Could you please share the APIs available to expose Gold-layer data residing in the OCI AI Data Platform to external applications such as MCP tools or AI agents?

 Additionally, are there any documentation or Confluence pages that explain the available integration options and usage?

DMD

@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 share delta-io/delta-sharing: An open protocol for secure data sharing. On the delta share github page you can see a short list of applications that support delta sharing out of the box.

From an agentic AI standpoint there's a number of ways to go about that, but I'll share two high level considerations:

(1) AIDP's agent flow feature, which exposes OCI Generate AI agent endpoints. This feature also you to define agents within AIDP through a low code, drag and drop, "tool" centric approach: Build AI Agents with Oracle AI Data Platform: Demo

(2) Manage your gold layer in AIDP through an external catalog configured Autonomous Oracle Database (ADW/ AI Lakehouse) Internal Sources. In doing this you integrate all of the features of Autonomous database to an AIDP managed gold layer. A lot to explore from an ADW side that really could be a post of it's own, but think things like MCP, DBMS_CLOUD_AI_AGENTS, Select AI, etc etc.