In this tutorial you’ll learn how to connect an AI agent to an Oracle Analytics Cloud (OAC) MCP server in Oracle AI Data Platform. This connection enables an agent to use Oracle Analytics tools to discover, understand, and query business data, helping users get answers to questions such as departmental budgets and spending.
In this video tutorial, you’ll learn how to:
- Add a Remote MCP Server tool to an AI agent.
- Configure the MCP server URL, display name, and authentication credential.
- Connect to Oracle Analytics Cloud using Bearer Token authentication and an OAC access token.
- Explore the tools exposed through the OAC MCP server for discovering, describing, querying, and managing analytics content.
- Select the appropriate tools for discovering datasets, understanding their structure, and executing Logical SQL queries.
- Test the Search Catalog tool to verify that expected catalog objects are accessible.
By connecting an AI agent to Oracle Analytics Cloud through an MCP server, you can extend the agent with Oracle Analytics capabilities for retrieving and querying business data. Watch the full tutorial to see how to configure and test the connection and explore the additional resources in this series to learn more about using Oracle AI Data Platform.
For more information, see how to connect to remote MCP servers in the Oracle Help Center.
Explore self-paced short courses in the Oracle Analytics and AI Learning Hub to continue building your skills with Oracle Analytics and AI.