Frequently Asked Questions: CData MCP Server for SAS Data Sets

Q: What is the CData MCP Server for SAS Data Sets? A: It’s a server that allows LLMs (like Claude Desktop) to query live SAS Data Sets data supported by the CData JDBC Driver for SAS Data Sets via the Model Context Protocol (MCP).

Q: What is MCP? A: MCP stands for Model Context Protocol. It is an open protocol that standardizes how applications provide context to LLMs. It acts as a bridge, allowing AI models to access and interact with external data sources and tools.

Q: What are the benefits of using this server? A: Seamless integration with AI models, real-time data access, simplified data retrieval, enhanced AI capabilities, and cost-effective data integration.

Q: Is this server read-only? A: Yes, this project builds a read-only MCP server. However, a free (beta) read/write server is available at https://www.cdata.com/solutions/mcp.

Q: What kind of data sources are supported? A: The server supports any SAS Data Sets accessible through the CData JDBC Driver for SAS Data Sets.

Q: Do I need to know SQL to use this server? A: No, the MCP interface enables AI models to retrieve live information by asking natural language questions, eliminating the need for complex SQL queries.

Q: How do I set up the server? A: The setup involves cloning the repository, building the server with Maven, downloading and licensing the CData JDBC Driver, configuring the connection, creating a configuration file, configuring your AI client (e.g., Claude Desktop), and running the server.

Q: Where can I find the CData JDBC Driver for SAS Data Sets? A: You can download it from https://www.cdata.com/drivers/sasdatasets/download/jdbc.

Q: How do I license the CData JDBC Driver? A: Navigate to the lib folder in the installation directory and run the command java -jar cdata.jdbc.sasdatasets.jar --license. Enter your name, email, and “TRIAL” (or your license key).

Q: What is a .prp file? A: It’s a configuration file for your JDBC connection, containing properties like Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Tables.

Q: How do I configure Claude Desktop to use the server? A: Create or modify the claude_desktop_config.json file to add the new MCP server entry with the correct paths to the Java executable, the server JAR file, and the .prp file.

Q: I can’t see the server in Claude Desktop. What should I do? A: Ensure you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and re-opened it.

Q: Claude Desktop can’t retrieve data. What should I do? A: Verify that you have configured your connection properly. Use the Connection String builder to create the connection string and copy it into the property (.prp) file.

Q: What if I am having trouble connecting to my data source? A: Contact the CData Support Team at https://www.cdata.com/support/submit.aspx.

Q: Where can I get help using the MCP server? A: Join the CData Community at https://community.cdata.com.

Q: What is the license for this MCP server? A: This MCP server is licensed under the MIT License.

Q: Can I use this MCP server with the UBOS Platform? A: Yes! The UBOS platform is designed to integrate seamlessly with MCP servers like this one, allowing you to orchestrate AI Agents, connect them with your enterprise data, and build custom AI Agents with your LLM model and Multi-Agent Systems.