sas-data-sets-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for SAS Data Sets

: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 SAS Data Sets.

Purpose

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

CData JDBC Driver connects to SAS Data Sets by exposing them as relational SQL models.

This server wraps that driver and makes SAS Data Sets 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/sas-data-sets-mcp-server-by-cdata.git
   cd sas-data-sets-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/sasdatasets/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 SAS Data Sets\
     • (Mac/Linux) /Applications/CData JDBC Driver for SAS Data Sets/
   • Run the command java -jar cdata.jdbc.sasdatasets.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.sasdatasets.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. sas-data-sets.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.sasdatasets.SASDataSetsDriver)
   • 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=sasdatasets
     ServerName=CDataSASDataSets
     ServerVersion=1.0
     DriverPath=PATH\TO\cdata.jdbc.sasdatasets.jar
     DriverClass=cdata.jdbc.sasdatasets.SASDataSetsDriver
     JdbcUrl=jdbc:sasdatasets: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\\sas-data-sets.prp"
         ]
       },
       ...
     }
   }
   

   Linux/Mac

... View full README on GitHub