yunIO MCP Integration with Microsoft Copilot

This article shows how to integrate yunIO with a Copilot chatbot to retrieve live SAP data using natural language. Users can access SAP data without direct SAP access, transaction code knowledge, or SAP GUI experience.

General Workflow

For more information about the yunIO MCP server, see Documentation: MCP Server.

Prerequisites

• A Microsoft account with access to the following Microsoft tools is required:
  • Power Automate or Power Apps
  • Copilot Studio
• yunIO services have meaningful descriptions and are enabled for MCP, see Documentation: MCP Server - Setup in yunIO.
• The MCP endpoint of yunIO must be exposed to the internet, see Documentation: MCP Server - Setup in yunIO.

Setup in Power Automate

Follow the steps below to create a Custom Connector in Microsoft Power Automate that connects to the yunIO MCP endpoint. The same procedure can be applied in Microsoft Power Apps.

1. In Power Automate, open the section Custom Connectors.
2. Click + New custom connector > Create from blank.
   
3. Give the connector a name of your choice and click Continue.
4. In the General tab, enter the connection details of your yunIO instance.
5. If you use an on-premises data gateway to expose the MCP endpoint of yunIO, activate the checkbox Connect via on-premises gateway.
6. Click Swagger editor to open the swagger view of the general connector settings.
   

7. Copy the MCP server schema (the path section) of the following template into the swagger editor:

   MCP Server Connection Details Example

   swagger: '2.0'
   info:
     title: yunIO-MCP-Server
     description: |-
       This is an MCP Connector to the yunIO MCP Server.
       This connector enables interactions with SAP.
     version: '1.0'
   host: yunio.example.com:8177
   basePath: /
   schemes:
   
     - https
   paths:
     /mcp:
       post:
         summary: yunIO MCP Server
         x-ms-agentic-protocol: mcp-streamable-1.0
         operationId: InvokeMCP
         responses:
           '200':
             description: Success
   

   For more information, see Microsoft Documentation: MCP server schema example.

8. In the Security tab, select the authentication type for the MCP server.
   

   • If Anonymous is enabled in the yunIO access settings, select No authentication. When using the custom connector, no authentication is required.
     
   • If Authenticated is enabled in the yunIO access settings, select Basic authentication. When using the custom connector, provide the credentials of a yunIO user.
   • If Request credentials from callers when running services is enabled in the yunIO connection settings, select Basic authentication. When using the custom connector, provide the credentials of an SAP dialog user.
     
9. Click Create connector.
   

The custom connector to the yunIO MCP server is now ready to use.

Setup in Copilot Studio

Follow the steps below to set up a chatbot in Microsoft Copilot Studio:

1. Log into Microsoft Copilot Studio.
2. Go to Create and click [+ New Agent].
3. Enter a name and description of the agent and click [Create]. A new agent is created.
4. In the Tools tab of the agent, click [+ Add a tool]. A tool selection opens.
   
5. In the tool selection, click Multi-Context-Protocol and select your MCP custom connector.
6. Go to Not connected > Create new connection.
   
7. If prompted, enter your yunIO credentials.
8. Click [Add to agent]. This might take some time.
9. Go to Tools > > Tools to check if your yunIO services are available.
   

10. Test the copilot chatbot in Copilot Studio.
    The example below demonstrates how to call a service that reads customer data from the SAP table KNA1.

    Example Prompt: "Give me a list of all customers from Germany."

    When executed, the chatbot:

    • Identifies the user's intent and calls the corresponding yunIO service .
    • Translates the user input into a WHERE clause to filter KNA1 records .
    • Returns the resulting SAP data in a readable text format .

    

The chatbot is now ready to be published. For more information, see Microsoft Documentation: Publish your copilot.

Related Topics

• Microsoft Documentation: Create a copilot
• Knowledge Base Article: Establish an Azure Relay Hybrid Connection to yunIO
• Documentation: MCP Server
• Documentation: Server Settings