Xtract Universal.iQ MCP Integration with Microsoft Power Platform

This article shows how to integrate Xtract Universal.iQ's MCP server as a Custom Connector with Power Automate / Power Apps.

The Custom Connector can be used as a tool in Microsoft Copilot Studio to create chatbots that enable users to retrieve and interact with SAP data without direct SAP access, transaction code knowledge, or SAP GUI experience.

Prerequisites

• A Microsoft account with access to Microsoft Power Automate or Microsoft Power Apps.
• Xtract Universal.iQ services must have meaningful descriptions and be enabled for MCP, see Documentation: MCP Server - Expose Services via MCP.
• The MCP endpoint of Xtract Universal.iQ is exposed to the internet, see Documentation: MCP Server - Activate MCP.

Setup in Power Automate

To create a Custom Connector in Microsoft Power Automate (or Power Apps) that connects to the Xtract Universal.iQ MCP endpoint:

1. Navigate to 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 Xtract Universal.iQ instance.
5. If you use an on-premises data gateway to expose the MCP endpoint of Xtract Universal.iQ, 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
   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 Xtract Universal.iQ, select No authentication. When using the custom connector, no authentication is required.
     
   • If Authenticated access is enabled in Xtract Universal.iQ, select Basic authentication. When using the custom connector, provide the credentials of a Xtract Universal.iQ 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 for the Xtract Universal.iQ MCP server is now ready to use.

Related Topics

• Microsoft Documentation: Copilot Studio - Extend your agent with Model Context Protocol
• Knowledge Base Article: Establish an Azure Relay Hybrid Connection to Xtract Universal.iQ
• Documentation: MCP Server
• Documentation: Server Settings