UBOS Asset Marketplace: CData MCP Server for Active Directory – Unleash the Power of LLMs on Your Active Directory Data

In today’s data-driven landscape, the ability to seamlessly integrate and analyze information from diverse sources is paramount. Large Language Models (LLMs) like Claude are revolutionizing how we interact with data, offering natural language interfaces for querying and understanding complex datasets. However, connecting these powerful AI tools to your existing infrastructure, such as Active Directory, can be a challenge.

That’s where the CData MCP Server for Active Directory, available on the UBOS Asset Marketplace, steps in. This innovative solution bridges the gap between LLMs and your Active Directory data, enabling you to extract valuable insights and automate critical tasks with unprecedented ease.

What is the CData MCP Server for Active Directory?

The CData MCP Server for Active Directory is a Model Context Protocol (MCP) server that leverages the CData JDBC Driver for Active Directory to expose your Active Directory data as a relational SQL model. This allows LLMs, such as Claude Desktop, to query live data using natural language, eliminating the need for complex SQL queries. The MCP server acts as a translator, converting natural language requests into SQL queries that the JDBC driver can understand, and then returning the results in a format that the LLM can easily process.

This integration empowers users to ask questions about their Active Directory data in plain English and receive accurate, real-time answers. Imagine being able to ask Claude, “How many users are in the Marketing department?” or “What are the groups that John Smith belongs to?” and receiving instant, insightful responses.

Key Features and Benefits

• Natural Language Querying: Interact with your Active Directory data using natural language, eliminating the need for SQL expertise.
• Real-time Data Access: Retrieve live information from Active Directory, ensuring you always have the most up-to-date insights.
• Simplified Integration: Easily connect Claude Desktop and other LLMs to Active Directory with a straightforward setup process.
• Enhanced Data Discovery: Explore your Active Directory data in a more intuitive and accessible way.
• Automation of Tasks: Automate routine tasks, such as user management and security auditing, using natural language commands.
• Read-Only Access: The provided server is read-only, ensuring the security and integrity of your Active Directory data. For full read/write capabilities, consider the free (beta) CData MCP Server for Active Directory.
• Leverages CData JDBC Driver: Built on the robust and reliable CData JDBC Driver for Active Directory.
• Seamless Integration with UBOS: Easily deploy and manage the MCP server within the UBOS platform.

Use Cases

The CData MCP Server for Active Directory opens up a wide range of use cases for businesses of all sizes. Here are a few examples:

• IT Support: Quickly answer user questions about their account status, group memberships, and other Active Directory information.
• Security Auditing: Identify potential security vulnerabilities by querying Active Directory for inactive accounts, privileged users, and other security-related data.
• User Management: Automate user onboarding and offboarding processes by using natural language commands to create, modify, and delete user accounts.
• Compliance Reporting: Generate reports on Active Directory data to meet regulatory requirements.
• Data Analysis: Analyze Active Directory data to identify trends and patterns, such as user adoption rates and security risks.
• Improved Decision-Making: Empower business users to make data-driven decisions by providing them with easy access to Active Directory information.

How to Get Started

Integrating the CData MCP Server for Active Directory with UBOS is a simple process:

1. Clone the Repository: Obtain the MCP server code from the provided GitHub repository.
2. Build the Server: Compile the code using Maven to create a JAR file.
3. Download and License the CData JDBC Driver: Download the CData JDBC Driver for Active Directory and activate your license (a trial license is available).
4. Configure the Connection: Use the Connection String utility to configure the connection to your Active Directory instance and test the connection.
5. Create a .prp File: Create a configuration file containing the connection details and other settings.
6. Configure Claude Desktop: Add the new MCP server to your Claude Desktop configuration file.
7. Run the Server: Execute the JAR file with the configuration file to start the MCP server.

Once the server is running, you can start querying your Active Directory data using natural language through Claude Desktop.

Diving Deeper: A Step-by-Step Guide

To fully leverage the CData MCP Server for Active Directory, let’s explore each step in more detail.

1. Cloning the Repository:

The first step involves obtaining the necessary code. Open your terminal or command prompt and execute the following command:

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

This command clones the repository containing the MCP server code to your local machine and navigates you into the newly created directory.

2. Building the Server:

Next, you need to compile the code into an executable JAR file. Ensure you have Maven installed on your system. If not, download and install it from the Apache Maven website (https://maven.apache.org/).

Once Maven is installed, run the following command in the repository directory:

bash mvn clean install

This command cleans the project, compiles the code, and creates the JAR file: CDataMCP-jar-with-dependencies.jar. This JAR file contains all the necessary dependencies to run the MCP server.

3. Downloading and Licensing the CData JDBC Driver:

The CData MCP Server relies on the CData JDBC Driver for Active Directory to connect to your Active Directory instance. Download the driver from the CData website: https://www.cdata.com/drivers/activedirectory/download/jdbc.

After downloading, install the driver. Then, you need to license it. Navigate to the lib folder in the installation directory (typically C:Program FilesCDataCData JDBC Driver for Active Directory on Windows or /Applications/CData JDBC Driver for Active Directory/ on macOS/Linux).

Run the following command:

bash java -jar cdata.jdbc.activedirectory.jar --license

Enter your name, email, and either “TRIAL” (for a trial license) or your purchased license key.

4. Configuring the Connection:

To configure the connection to your Active Directory instance, run the following command in the lib folder:

bash java -jar cdata.jdbc.activedirectory.jar

This opens the Connection String utility. Configure the connection string with the appropriate settings for your Active Directory environment. You’ll need to provide information such as the server address, username, password, and domain.

Click “Test Connection” to verify that the connection is working correctly. If the data source uses OAuth, you’ll need to authenticate in your browser. Once the connection is successful, copy the connection string for use in the next step.

5. Creating a .prp File:

Create a file with the .prp extension (e.g., active-directory.prp) to store the connection details and other settings. This file will be used by the MCP server to connect to Active Directory. The file should contain the following properties:

• Prefix: A prefix to be used for the tools exposed (e.g., activedirectory).
• ServerName: A name for your server (e.g., CDataActiveDirectory).
• ServerVersion: A version for your server (e.g., 1.0).
• DriverPath: The full path to the JAR file for the CData JDBC driver (e.g., PATHTOcdata.jdbc.activedirectory.jar).
• DriverClass: The name of the JDBC driver class (e.g., cdata.jdbc.activedirectory.ActiveDirectoryDriver).
• JdbcUrl: The JDBC connection string you copied from the Connection String utility (e.g., jdbc:activedirectory:InitiateOAuth=GETANDREFRESH;).
• Tables: Leave blank to access all data, or specify a comma-separated list of tables you want to expose (e.g., Users,Groups).

Here’s an example of an active-directory.prp file:

env Prefix=activedirectory ServerName=CDataActiveDirectory ServerVersion=1.0 DriverPath=PATHTOcdata.jdbc.activedirectory.jar DriverClass=cdata.jdbc.activedirectory.ActiveDirectoryDriver JdbcUrl=jdbc:activedirectory:InitiateOAuth=GETANDREFRESH; Tables=

Replace PATHTOcdata.jdbc.activedirectory.jar with the actual path to the CData JDBC driver JAR file.

6. Configuring Claude Desktop:

To make the MCP server available to Claude Desktop, you need to add it to the Claude Desktop configuration file (claude_desktop_config.json). The location of this file varies depending on your operating system. Example:

Windows: %APPDATA%Claudeclaude_desktop_config.json

Linux/Mac: /Users/{user}/Library/Application Support/Claude/claude_desktop_config.json

If the file doesn’t exist, create it. Add the following entry to the mcpServers section of the configuration file:

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

Replace PATHTOjava.exe with the actual path to your Java executable, PATHTOCDataMCP-jar-with-dependencies.jar with the path to the MCP server JAR file, and PATHTOactive-directory.prp with the path to your .prp file.

7. Running the Server:

Finally, you can run the MCP server using the following command:

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

Replace /PATH/TO/CDataMCP-jar-with-dependencies.jar with the actual path to the MCP server JAR file and /PATH/TO/Salesforce.prp with the path to your .prp file.

The server will start and listen for requests from Claude Desktop. You may need to fully exit or quit your Claude Desktop client and re-open it for the MCP Servers to appear.

Now you can start interacting with your Active Directory data through Claude Desktop using natural language queries.

Understanding the Tools

The CData MCP Server exposes a set of tools that Claude Desktop can use to interact with your Active Directory data. These tools include:

• {servername}_get_tables: Retrieves a list of tables available in the data source.
• {servername}_get_columns: Retrieves a list of columns for a specific table.
• {servername}_run_query: Executes a SQL SELECT query against the data source.

Where {servername} is the name of the MCP server in the configuration file (e.g., activedirectory).

JSON-RPC Request Examples

If you’re scripting requests directly to the MCP server (instead of using an AI client like Claude), you can use JSON-RPC to call the available tools. Here are some examples:

Get Tables:

{ “jsonrpc”: “2.0”, “id”: 1, “method”: “tools/call”, “params”: { “name”: “active_directory_get_tables”, “arguments”: {} } }

Get Columns for the Account Table:

{ “jsonrpc”: “2.0”, “id”: 2, “method”: “tools/call”, “params”: { “name”: “active_directory_get_columns”, “arguments”: { “table”: “Account” } } }

Run a Query to Select Deleted Accounts:

{ “jsonrpc”: “2.0”, “id”: 3, “method”: “tools/call”, “params”: { “name”: “active_directory_run_query”, “arguments”: { “sql”: “SELECT * FROM [Account] WHERE [IsDeleted] = true” } } }

Troubleshooting

If you encounter any issues, refer to the troubleshooting section in the original documentation. Common issues include:

• MCP Server not appearing in Claude Desktop (ensure you’ve fully quit and reopened Claude Desktop).
• Claude Desktop unable to retrieve data (verify your connection configuration).
• Problems connecting to the data source (contact CData Support).
• Issues using the MCP server (join the CData Community).

The UBOS Advantage

While the CData MCP Server for Active Directory provides a powerful solution for connecting LLMs to your data, integrating it with the UBOS platform unlocks even greater potential. UBOS is a full-stack AI Agent Development Platform designed to help businesses orchestrate AI Agents, connect them with enterprise data, and build custom AI Agents with your LLM model and Multi-Agent Systems.

Here’s how UBOS enhances the CData MCP Server for Active Directory:

• Centralized Management: UBOS provides a central platform for managing all your AI Agents and integrations, including the CData MCP Server. This simplifies deployment, monitoring, and maintenance.
• Enhanced Security: UBOS offers robust security features to protect your data and ensure compliance.
• Scalability: UBOS is designed to scale to meet the demands of your business, allowing you to easily add more AI Agents and integrations as needed.
• Customization: UBOS allows you to customize the CData MCP Server to meet your specific requirements. You can create custom tools, modify the data model, and integrate with other systems.
• Orchestration: UBOS enables you to orchestrate complex workflows involving multiple AI Agents and data sources. This allows you to automate sophisticated tasks and gain deeper insights into your data.

By combining the CData MCP Server for Active Directory with the UBOS platform, you can create a powerful and flexible AI-driven solution that empowers your business to unlock the full potential of your Active Directory data.

Conclusion

The CData MCP Server for Active Directory is a game-changer for organizations looking to leverage the power of LLMs to analyze and interact with their Active Directory data. By providing a natural language interface and real-time data access, this solution empowers users to gain valuable insights, automate tasks, and make better decisions. And by integrating with the UBOS platform, you can unlock even greater potential and create a truly AI-driven enterprise.