SSAS by CData FAQs

Question 1

What kind of SQL Server Analysis Services functionality does this package allow?

Accepted Answer

This package is for read-only data access. For full read, write, update, delete, and action capabilities, check out the free CData MCP Server for SQL Server Analysis Services (beta).

Question 2

How do I configure SSAS by CData to work with Claude Desktop?

Accepted Answer

You need to create or modify the claude_desktop_config.json file to include the new MCP server, specifying the path to the Java executable, the JAR file, and the .prp configuration file.

Question 3

What is the Model Context Protocol (MCP) Server?

Accepted Answer

The MCP Server wraps the CData JDBC Driver for SQL Server Analysis Services and makes SSAS data accessible through a simple MCP interface. This allows applications to retrieve live data by asking natural language questions – no SQL required.

Question 4

What are the prerequisites for using SSAS by CData?

Accepted Answer

You need the CData JDBC Driver for SQL Server Analysis Services and Java installed. You will also need to clone the repository, build the server using Maven, and configure a .prp file for your JDBC connection.

Question 5

What is SSAS by CData?

Accepted Answer

SSAS by CData provides a read-only MCP Server that allows applications, like Claude Desktop, to query SQL Server Analysis Services data using CData JDBC Drivers. It enables querying SSAS data with natural language.

SSAS by CData

About

Key Features

Use Cases