Certinia MCP Server by CData

Name: Certinia MCP Server by CData
Author: CDataSoftware

@CDataSoftware

About Certinia MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Certinia (beta): https://www.cdata.com/download/download.aspx?sku=HFZK-V&type=beta

#certinia #mcp-server #cdata

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\certinia.prp"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Certinia MCP Server by CData?

The Certinia MCP Server by CData is a read-only MCP server that allows large language models (like Claude Desktop) to query live data from Certinia using the CData JDBC Driver for Certinia. It wraps the driver in a simple MCP interface so users can ask natural language questions without writing SQL. It is intended for developers and data analysts who need AI-powered access to Certinia data.

How to use Certinia MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Certinia, create a .prp file with connection details, add the server to your Claude Desktop configuration (claude_desktop_config.json), and restart the client. The server runs on stdio, so it must be on the same machine as the client.

Key features of Certinia MCP Server by CData

Query Certinia data using natural language via LLMs
Exposes tools: get_tables, get_columns, run_query
Built on the CData JDBC Driver for Certinia
Read-only (write/update/delete available in separate CData MCP Server beta)
Supports any MCP client that runs on the same machine
Outputs results in CSV format

Use cases of Certinia MCP Server by CData

Ask “What is the correlation between my closed won opportunities and the account industry?”
Query “How many open tickets do I have in the SUPPORT project?”
Retrieve calendar events or other live Certinia data without writing SQL

FAQ from Certinia MCP Server by CData

Is this server read-only?

Yes, this project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, check out the free CData MCP Server for Certinia (beta).

What are the runtime requirements?

Java is required to run the server and the JDBC driver. The project uses Maven to build and the CData JDBC Driver for Certinia must be installed and licensed.

Where does the data live?

Data remains in Certinia. The server connects to Certinia live via the CData JDBC Driver and does not store data locally.

What transport does this server use?

The server uses stdio as its transport, so it can only be used with MCP clients running on the same machine.

How do I authenticate to Certinia?

The JDBC Driver supports OAuth authentication. When configuring the connection string using the Driver’s utility, you will need to authenticate in your browser if OAuth is required.