Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAS | MCP Enquiry

Received Response
37
Views
5
Comments
User_OKR8H
User_OKR8H Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

We would like to enquiry that OAS can integration with Oracle sqlcl MCP server. Or we can OAM have API for create reports?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited Aug 18, 2025 1:09PM

    What would you like to do with the SQLcl MCP server and OAS? OAS isn't an AI agent/LLM and can't use a MCP server.

    And SQLcl MCP server is also not an AI agent/LLM and can't call other tools like could be the OAS APIs.

    In your post you talk about OAS and then about OAM, it sounds like there is some confusion about what you are trying to achieve, the tools involved and what they do and how.

  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Aug 19, 2025 4:22PM

    Hi Leong,

    Welcome to the Oracle Analytics community, and thanks for posting your question here!

    The Oracle SQLcl MCP server is specifically for query directly the Oracle database via exposed APIs, it is not built for OAC or OAS. There are good blogs about using it with SQL Developer.


    For OAC/OAS, you can review this blog that my colleague, Mike, published.

    It explains how to use an MCP server with exposed OAC REST API's.
    You can use the same concepts with exposed OAS API's (REST/SOAP/BIJDBC/SMML)

    Create an AI Agent to manage your OAC instance With MCP and REST API's

    There is an Idea Lab request for incorporating MCP with Oracle Analytics, here:

    https://community.oracle.com/products/oracleanalytics/discussion/26703/add-model-context-protocol-mcp-client-support-in-oracle-analytics-ai-assistant-connections

    Other comments, welcomed.

  • User_OKR8H
    User_OKR8H Rank 1 - Community Starter

    Thanks both, understand OAS current is no LLM function, we would like to find out possibility for this.

    as checked on the OAS rest api spec, i saw OAS is allow to created report from the client, but it need to special format like .xdm or .xlf. this like the xml format.

    do we have a guide this for this format report. And know more how to created it by manually.

    https://docs.oracle.com/en/middleware/bi/analytics-server/oap_rest_api/op-v1-reports-post.html

  • Gianni Ceresa
    Gianni Ceresa Mod

    Ok, so now MCP is not a topic anymore but you are asking about the Publisher API (sounds like the thread is a moving target…).

    Do you want to know how to manually create Publisher objects? (data models, templates, sample data files etc.) Use the UI to create those objects as you need.

  • User_OKR8H
    User_OKR8H Rank 1 - Community Starter

    Yes, but can using xml file or other format instead of UI?