UBOS Asset Marketplace: MCP Server for ADP - Unleash the Power of AI with Your Data

In today’s data-driven world, the ability to seamlessly integrate and analyze information is crucial for making informed decisions and gaining a competitive edge. The UBOS Asset Marketplace offers a robust solution: the MCP (Model Context Protocol) Server for ADP (Automatic Data Processing). This server empowers you to connect Large Language Models (LLMs) like Claude Desktop to your ADP data, unlocking the potential for AI-powered insights and automation.

What is MCP and Why Does It Matter?

MCP, or Model Context Protocol, is an emerging open standard designed to streamline how applications provide context to Large Language Models (LLMs). Think of it as a universal translator that enables LLMs to understand and interact with data from various sources. Instead of complex coding and custom integrations, MCP provides a standardized way for LLMs to access and utilize external information. This server acts as a bridge, allowing AI models to access and interact with external data sources and tools. This unlocks powerful capabilities, allowing AI agents to answer questions, automate tasks, and generate insights based on real-time data.

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

The UBOS Asset Marketplace extends this functionality by providing pre-built MCP Servers for popular data sources like ADP, simplifying the integration process and accelerating your AI initiatives.

The UBOS MCP Server for ADP: A Deep Dive

The UBOS MCP Server for ADP, leveraging CData JDBC Drivers, provides a seamless connection between Claude Desktop and your ADP data. This integration opens up a world of possibilities for leveraging AI to enhance your business processes.

Key Features:

• Seamless Integration: Connect Claude Desktop to ADP data with minimal configuration.
• Read-Only Access: Securely access your ADP data without the risk of accidental modifications (Read/Write beta servers also available).
• CData JDBC Driver Powered: Utilizes the reliable and high-performance CData JDBC Driver for ADP.
• Natural Language Queries: Retrieve live information from ADP by asking natural language questions – no SQL required.
• Easy Setup: Simple installation and configuration process.
• SQL Modeling: CData JDBC Driver exposes ADP data as relational SQL models, enabling complex queries.
• Completely Free (for this Read-Only Version): Access powerful integration capabilities without initial cost barriers.

Use Cases:

• AI-Powered Reporting: Generate insightful reports on employee data, payroll, and other HR-related metrics using natural language queries.
• Automated HR Tasks: Automate tasks such as employee onboarding, performance reviews, and leave management using AI agents.
• Data-Driven Decision Making: Make informed decisions based on real-time ADP data analyzed by AI models.
• Improved Employee Experience: Provide employees with quick and easy access to HR information through AI-powered chatbots.
• Enhanced Data Analysis: Analyze ADP data in conjunction with other data sources to identify trends and patterns.
• Custom AI Agent Development: Use the MCP Server as a foundation for building custom AI agents tailored to your specific HR needs. Connect it to the UBOS platform to create AI agents with memory, planning, and tool use capabilities.

Technical Details:

• Architecture: The server wraps the CData JDBC Driver for ADP and makes ADP data available through a simple MCP interface.
• Connectivity: Connects to ADP by exposing it as relational SQL models.
• Security: Provides read-only access to ADP data.
• Configuration: Requires a .prp file to configure the JDBC connection.

Setting Up the UBOS MCP Server for ADP

Here’s a step-by-step guide to setting up the UBOS MCP Server for ADP:

1. Clone the Repository:

   bash git clone https://github.com/cdatasoftware/adp-mcp-server-by-cdata.git cd adp-mcp-server-by-cdata

2. Build the Server:

   bash mvn clean install

   This creates the JAR file: CDataMCP-jar-with-dependencies.jar

3. Download and Install the CData JDBC Driver for ADP:

   https://www.cdata.com/drivers/adp/download/jdbc

4. License the CData JDBC Driver:

   • Navigate to the lib folder in the installation directory:
     • (Windows) C:Program FilesCDataCData JDBC Driver for ADP
     • (Mac/Linux) /Applications/CData JDBC Driver for ADP/
   • Run the command java -jar cdata.jdbc.adp.jar --license
   • Enter your name, email, and “TRIAL” (or your license key).

5. Configure your connection to the data source (ADP):

   • Run the command java -jar cdata.jdbc.adp.jar to open the Connection String utility.
   • Configure the connection string and click “Test Connection”
     • Note: If the data sources use OAuth, you will need to authenticate in your browser.
   • Once successful, copy the connection string for use later.

6. Create a .prp file for your JDBC connection (e.g. adp.prp) using the following properties and format:

   • Prefix - a prefix to be used for the tools exposed
   • ServerName - a name for your server
   • ServerVersion - a version for your server
   • DriverPath - the full path to the JAR file for your JDBC driver
   • DriverClass - the name of the JDBC Driver Class (e.g. cdata.jdbc.adp.ADPDriver)
   • JdbcUrl - the JDBC connection string to use with the CData JDBC Driver to connect to your data (copied from above)
   • Tables - leave blank to access all data, otherwise, you can explicitly declare the tables you wish to create access for

   env Prefix=adp ServerName=CDataADP ServerVersion=1.0 DriverPath=PATHTOcdata.jdbc.adp.jar DriverClass=cdata.jdbc.adp.ADPDriver JdbcUrl=jdbc:adp:InitiateOAuth=GETANDREFRESH; Tables=

Integrating with Claude Desktop

1. Create the config file for Claude Desktop (claude_desktop_config.json) to add the new MCP server, using the format below. If the file already exists, add the entry to the mcpServers in the config file.

   Windows

   { “mcpServers”: { “{classname_dash}”: { “command”: “PATHTOjava.exe”, “args”: [ “-jar”, “PATHTOCDataMCP-jar-with-dependencies.jar”, “PATHTOadp.prp” ] }, … } }

   Linux/Mac

   { “mcpServers”: { “{classname_dash}”: { “command”: “/PATH/TO/java”, “args”: [ “-jar”, “/PATH/TO/CDataMCP-jar-with-dependencies.jar”, “/PATH/TO/adp.prp” ] }, … } }

   If needed, copy the config file to the appropriate directory (Claude Desktop as the example).

   Windows

   bash cp C:PATHTOclaude_desktop_config.json %APPDATA%Claudeclaude_desktop_config.json

   Linux/Mac

   bash cp /PATH/TO/claude_desktop_config.json ‘/Users/{user}/Library/Application Support/Claude/claude_desktop_config.json’

2. Run or refresh your client (Claude Desktop).

   Note: You may need to fully exit or quit your Claude Desktop client and re-open it for the MCP Servers to appear.

Running the Server Independently

1. Run the following command to run the MCP Server on its own:

   bash java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

   Note: The server uses stdio so can only be used with clients that run on the same machine as the server.

Leveraging the Server: Usage Details

After configuring the MCP Server, your AI client can use built-in tools to read and extract the underlying data. Instead of explicitly calling the tools, simply ask the client to answer questions about the underlying data system. Here are a few examples:

• “What is the correlation between my closed won opportunities and the account industry?”
• “How many open tickets do I have in the SUPPORT project?”
• “Can you tell me what calendar events I have today?”

Available Tools and Descriptions

In the definitions below, {servername} refers to the name of the MCP Server in the config file (e.g. {classname_dash} above).

• {servername}_get_tables - Retrieves a list of tables available in the data source. Use the {servername}_get_columns tool to list available columns on a table. The output of the tool will be returned in CSV format, with the first line containing column headers.
• {servername}_get_columns - Retrieves a list of columns for a table. Use the {servername}_get_tables tool to get a list of available tables. The output of the tool will be returned in CSV format, with the first line containing column headers.
• {servername}_run_query - Execute a SQL SELECT query

Troubleshooting Common Issues

• Cannot see your CData MCP Server in Claude Desktop: Ensure that you have completely closed Claude Desktop (Windows: use the Task Manager, Mac: use the Activity Monitor).
• Claude Desktop is unable to retrieve data: Double-check that you have correctly configured your connection. Use the Connection String builder to create the connection string and copy it into the property (.prp) file.
• Trouble connecting to your data source: Contact the CData Support Team.
• Issues using the MCP server or have other feedback: Join the CData Community.

The UBOS Advantage: Beyond Basic Connectivity

While the MCP Server for ADP provides essential connectivity, integrating it with the UBOS platform unlocks a new level of AI agent capabilities. UBOS provides tools for:

• Agent Orchestration: Manage and coordinate multiple AI agents working together.
• Memory and Planning: Equip your agents with long-term memory and the ability to plan complex tasks.
• Custom Tool Building: Create custom tools tailored to your specific business needs.
• Multi-Agent Systems: Develop sophisticated multi-agent systems that can tackle complex problems.

Conclusion: Empowering Your Business with AI and ADP

The UBOS Asset Marketplace’s MCP Server for ADP is a powerful tool for connecting your ADP data to the world of AI. By leveraging CData JDBC Drivers and the UBOS platform, you can unlock the potential for AI-powered insights, automation, and improved decision-making. Start exploring the possibilities today!