Office 365 by CData FAQs

Question 1

Is this a read-only server?

Accepted Answer

Yes, this specific project builds a read-only MCP server.  For full read, write, update, delete, and action capabilities and a simplified setup, check out the free [CData MCP Server for Office 365 (beta)](https://www.cdata.com/download/download.aspx?sku=CXZK-V&type=beta).

Question 2

What kind of data can I access?

Accepted Answer

You can access a wide variety of Office 365 data, including emails, calendar events, contacts, and more. The specific data available depends on your Office 365 configuration and the tables you configure in the properties file.

Question 3

What is the Model Context Protocol (MCP)?

Accepted Answer

MCP is an interface that allows Large Language Models (LLMs) to interact with external data sources.  CData uses MCP to let you query data using natural language instead of complex SQL.

Question 4

What is the Office 365 MCP Server by CData?

Accepted Answer

It's a tool that allows Large Language Models (LLMs) like Claude Desktop to query live Office 365 data using natural language. It exposes Office 365 data as SQL models via a Model Context Protocol (MCP) interface.

Question 5

How does it work?

Accepted Answer

It uses the CData JDBC Driver for Office 365 to connect and expose Office 365 data as relational SQL models. An MCP server wraps the driver, enabling LLMs to retrieve information through natural language questions.

Office 365 by CData

Office 365 by CData

Key Features

Use Cases

Key Features

Use Cases