ssas-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for SQL Server Analysis Services

:heavy_exclamation_mark: This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our CData MCP Server for SQL Server Analysis Services.

Purpose

We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data SQL Server Analysis Services supported by the CData JDBC Driver for SQL Server Analysis Services.

CData JDBC Driver connects to SQL Server Analysis Services by exposing them as relational SQL models.

This server wraps that driver and makes SQL Server Analysis Services data available through a simple MCP interface, so LLMs can retrieve live information by asking natural language questions — no SQL required.

Setup Guide

1. Clone the repository:

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

2. Build the server:

   mvn clean install
   

   This creates the JAR file: CDataMCP-jar-with-dependencies.jar
3. Download and install the CData JDBC Driver for {source}: https://www.cdata.com/drivers/ssas/download/jdbc
4. License the CData JDBC Driver:
   • Navigate to the lib folder in the installation directory, typically:
     • (Windows) C:\Program Files\CData\CData JDBC Driver for SQL Server Analysis Services\
     • (Mac/Linux) /Applications/CData JDBC Driver for SQL Server Analysis Services/
   • Run the command java -jar cdata.jdbc.ssas.jar --license
   • Enter your name, email, and "TRIAL" (or your license key).
5. Configure your connection to the data source (Salesforce as an example):

   • Run the command java -jar cdata.jdbc.ssas.jar to open the Connection String utility.

     

   • Configure the connection string and click "Test Connection"

     Note: If the data sources uses 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. ssas.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.ssas.SSASDriver)
   • 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

     Prefix=ssas
     ServerName=CDataSSAS
     ServerVersion=1.0
     DriverPath=PATH\TO\cdata.jdbc.ssas.jar
     DriverClass=cdata.jdbc.ssas.SSASDriver
     JdbcUrl=jdbc:ssas:InitiateOAuth=GETANDREFRESH;
     Tables=
     

Using the Server 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": "PATH\\TO\\java.exe",
         "args": [
           "-jar",
           "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
           "PATH\\TO\\ssas.prp"
         ]
       },
       ...
     }
   }
   

   Linux/Mac

   {
   
   

... View full README on GitHub