Building an AIDP environment on OCI, layer by layer — from workbench to bronze/silver/gold pipelines.
More →From asking questions in natural language to AI Agents inside Oracle Analytics.
More →A practical end-to-end guide to building and managing semantic models in Oracle Analytics Semantic Modeler.
More →
In the previous post an OPAF agent queried Oracle Analytics Server through my MCP server. MCP is an open protocol, so the same server works with any MCP client, without changing a line of code on oas001.
In this post I connect Claude Desktop on my Mac to the OAS MCP server through an SSH tunnel and ask it the same questions as the OPAF agent. Then I go further: charts, a follow-up drill-down, and a short comparison of the two clients.
In the previous post I built the OAS MCP server and opened port 8000 for the OPAF subnet. Now OPAF becomes the MCP client.
In this post I change two OPAF proxy settings, register the server with a Bearer token and build a Custom Flow with an MCP server node and an Agent node. Then I test the agent with business questions and check in the service log which Logical SQL it sent to OAS. I close with what I would change before using the server with a customer's OAS.
In the introduction I described the architecture and the four tools the server exposes. In this post I build it.
I walk through the Python code that talks to the OAS SOAP web services and wraps them as MCP tools, install the server on oas001 as a systemd service, test it with curl and open port 8000 for the OPAF subnet only. At the end the server answers tools/list with four tools, ready for an MCP client. The next post connects OPAF to it.
Oracle Analytics Cloud has an MCP server built in. Oracle Analytics Server does not. Many customers run OAS on premises or on their own compute, and their semantic models hold years of curated business logic that AI agents should be able to use instead of rebuilding it from raw tables.
In three short posts I build a small MCP server for OAS in Python, run it as a service next to OAS on an OCI compute instance and connect AI agents to it, starting with Oracle Private Agent Factory (OPAF). The server exposes four read-only tools on top of the OAS SOAP web services, which have been part of the product since OBIEE.