Frequently Asked Questions (FAQ) about CData MCP Server for Azure Analysis Services

Q: What is the CData MCP Server for Azure Analysis Services? A: It’s a read-only Model Context Protocol (MCP) server that allows Large Language Models (LLMs), such as Claude Desktop, to query live data from Azure Analysis Services using natural language. It leverages the CData JDBC Driver to expose Azure Analysis Services data as relational SQL models.

Q: What is MCP? A: MCP stands for Model Context Protocol. It is an open protocol that standardizes how applications provide context to LLMs, enabling them to access and interact with external data sources and tools.

Q: What are the benefits of using this MCP server? A: It simplifies the integration of Azure Analysis Services data with AI models, allowing users to query data using natural language instead of SQL. It provides read-only access for enhanced data security and offers a streamlined setup process.

Q: What is UBOS? A: UBOS is a full-stack AI Agent Development Platform focused on bringing AI Agents to every business department. It provides tools to orchestrate AI Agents, connect them with enterprise data, build custom AI Agents, and create Multi-Agent Systems.

Q: What kind of data sources the CData MCP Server supports? A: The CData MCP Server not limited to only Azure Analysis Services data, It can connect to a wide variety of sources. Please check ‘All Supported Sources’ in the main article above.

Q: How do I set up the CData MCP Server for Azure Analysis Services? A: The setup process involves cloning the repository, building the server, downloading and licensing the CData JDBC Driver, configuring the connection to Azure Analysis Services, creating a .prp file, and optionally configuring Claude Desktop. Detailed instructions are provided in the “Setup Guide” section above.

Q: Do I need to know SQL to use this server? A: No, you don’t need to know SQL. The server allows you to query Azure Analysis Services data using natural language questions.

Q: What AI clients are compatible with this server? A: The server is designed to work with AI clients that support the Model Context Protocol (MCP), such as Claude Desktop.

Q: How do I troubleshoot connection problems? A: Ensure that you have configured your connection properly using the Connection String builder. If you are still having trouble, contact the CData Support Team or join the CData Community for assistance.

Q: Is the server licensed under the MIT License? A: Yes, the MCP server is licensed under the MIT License, which means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License.

Q: Where can I find more information about UBOS? A: Visit the UBOS website at https://ubos.tech to learn more about our AI Agent Development Platform and explore the UBOS Asset Marketplace.