yunIO MCP Integration with Microsoft Copilot

This article shows how to integrate yunIO with a Copilot chatbot to enable natural language access to live SAP data. With this setup, users can retrieve and interact with SAP data without direct SAP access, transaction code knowledge, or SAP GUI experience.

General Workflow

To integrate yunIO with Microsoft Copilot via the MCP server:

This setup allows Microsoft Copilot to securely access and execute yunIO services in SAP through MCP, enabling both interactive use cases and automated business processes.

Prerequisites

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

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: SAP-MCP-Server
     description: |-
       This is an MCP Connector to the MCP Server.
       This connector enables interactions with SAP.
     version: '1.0'
   host: sap-link.example.com:8177
   basePath: /
   schemes:
   
     - https
   paths:
     /mcp:
       post:
         summary: SAP 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 access is enabled in yunIO, select No authentication. When using the custom connector, no authentication is required.
     
   • If Authenticated access is enabled in yunIO, 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 SAP connection, 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