Frequently Asked Questions about the Salesforce Marketing MCP Server on UBOS

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

Q: What is the Salesforce Marketing MCP Server? A: The Salesforce Marketing MCP Server is a read-only server that allows you to connect to Salesforce Marketing data from AI models like Claude Desktop through CData JDBC Drivers. It enables natural language querying of your Salesforce Marketing data.

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

Q: What are the benefits of using the Salesforce Marketing MCP Server with UBOS? A: Key benefits include seamless integration between Salesforce Marketing and AI models, natural language querying, real-time data access, enhanced AI capabilities, and simplified setup.

Q: What type of data access does this MCP Server provide? A: This specific MCP Server provides read-only access to your Salesforce Marketing data. A free (beta) read/write server is available from CData for full CRUD (Create, Read, Update, Delete) capabilities.

Q: What is CData JDBC Driver? A: CData JDBC Driver connect to Salesforce Marketing by exposing them as relational SQL models.

Q: How do I set up the Salesforce Marketing MCP Server? A: The setup process involves cloning the repository, building the server, downloading and licensing the CData JDBC Driver, configuring your connection to Salesforce Marketing, creating a .prp file for your JDBC connection, and configuring your AI client (e.g., Claude Desktop).

Q: What kind of questions can I ask Claude Desktop once the server is configured? A: You can ask questions like “What is the correlation between my closed won opportunities and the account industry?”, “How many open tickets do I have in the SUPPORT project?”, or “Can you tell me what calendar events I have today?”

Q: Where can I find the CData JDBC Driver for Salesforce Marketing? A: You can download the CData JDBC Driver for Salesforce Marketing from https://www.cdata.com/drivers/salesforcemarketing/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.sfmarketingcloud.jar --license. Then, enter your name, email, and “TRIAL” (or your license key).

Q: How do I configure the connection string for my Salesforce Marketing data? A: Run the command java -jar cdata.jdbc.sfmarketingcloud.jar to open the Connection String utility. Configure the connection string and click “Test Connection”.

Q: What is a .prp file and what properties should it contain? A: A .prp file is a properties file for your JDBC connection. It should contain properties like Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Tables.

Q: How do I configure Claude Desktop to use the MCP Server? A: Create or modify the claude_desktop_config.json file to add the new MCP server, specifying the command and arguments to run the server.

Q: I cannot see my CData MCP Server in Claude Desktop. What should I do? A: Ensure that you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and restarted it.

Q: Claude Desktop is unable to retrieve data. What should I do? A: Verify that you have configured your connection properly using the Connection String builder and that the connection string is correctly entered in the .prp file.

Q: Where can I get help if I’m having trouble connecting to my data source? A: Contact the CData Support Team.

Q: Where can I get help if I’m having trouble using the MCP server, or have any other feedback? A: Join the CData Community.

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