Microsoft Copilot Studio

​

Prerequisites

Make sure you have an Connect AI Embed account and are signed in.

​

Create a Microsoft Copilot Studio Agent

1. In the Copilot Studio navigation menu, click Agents, and then click +New agent.

2. Toggle the Configure button.

3. Enter information based on how you intend to use this agent while it is consuming our MCP server.

4. Click Create on the upper right. Copilot shows you the agent details.

​

Add the CData Connect AI Tool to the Agent

1. Scroll down the agent details until you see the Add tool button. Click this button.

2. In the Add Tool dialog, search for CData Connect AI and click the tool CData Connect AI.

   
3. Under Connection, click Create new connection.

   
4. In the next dialog, click Create.

5. Sign in to Connect AI with your credentials, if necessary.

6. Click Add to agent. The MCP tool is now listed under the Tools section for your agent. You can now test your agent.

​

Explore Live Data

With the Agent created in Microsoft Copilot Studio and the MCP tool connected, you can now interact with your data. The MCP tool allows you to send queries and receive responses from the data source in real time.

Open the chat window in your Microsoft Copilot Studio Agent to begin interacting with your data. You can ask questions, retrieve data, and perform actions on your data using the MCP tool.