Frequently Asked Questions about CData MCP Server for Salesforce

Q: What is the CData MCP Server for Salesforce? A: The CData MCP Server for Salesforce is a tool that allows Large Language Models (LLMs) like Claude Desktop to access and query live data from Salesforce. It uses the Model Context Protocol (MCP) to provide a standardized way for LLMs to interact with external data sources.

Q: What is MCP (Model Context Protocol)? A: MCP is an open protocol that standardizes how applications provide context to LLMs. It allows LLMs to access and interact with external data sources and tools in a consistent manner.

Q: What are the benefits of using the CData MCP Server for Salesforce? A: The benefits include seamless integration with Salesforce, real-time data access, simplified setup, natural language querying, and the ability to unlock AI-powered insights from Salesforce data.

Q: Is the CData MCP Server for Salesforce free to use? A: There is a free (beta) read-only version available. Paid versions with read/write capabilities are also available from CData.

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

Q: How do I install the CData MCP Server for Salesforce? A: The installation process involves cloning the repository, building the server using Maven, downloading and licensing the CData JDBC Driver for Salesforce, configuring the connection, creating a configuration file, and configuring Claude Desktop.

Q: What is a .prp file? A: A .prp file is a configuration file that contains the properties required to connect to Salesforce using the CData JDBC Driver. It includes information such as the JDBC URL, driver class, and other connection parameters.

Q: Can I use environment variables instead of a .prp file? A: Yes, you can configure the server using environment variables. This is useful for containerized deployments or when you want to bundle the CData JAR inside the compiled JAR.

Q: How do I configure Claude Desktop to use the CData MCP Server for Salesforce? A: You need to add the MCP server to the claude_desktop_config.json file, specifying the command, arguments, and environment variables required to run the server.

Q: What kind of queries can I run against Salesforce using the CData MCP Server? A: You can run SQL SELECT queries to retrieve data from Salesforce tables. The server exposes Salesforce data as relational SQL models.

Q: What if I have trouble connecting to my data source (Salesforce)? A: Contact the CData Support Team for assistance.

Q: Where can I get help with using the MCP server? A: Join the CData Community to ask questions and get help from other users.

Q: What data sources are supported? A: Many data sources are supported. A table of supported source types is in the description of this MCP Server.