# Microsoft SSAS (SQL Server Analysis Services)

#### **Connectivity Summary**

An out-of-the-box connector is available for SQL Server Analysis Services (SSAS) databases to support crawling database objects and lineage building.

<img src="https://support.ovaledge.com/hs-fs/hubfs/image-png-Jul-27-2021-05-10-19-41-AM.png?width=425&#x26;name=image-png-Jul-27-2021-05-10-19-41-AM.png" alt="" width="425">

> The connectivity to SQL Server’s Analysis Service is via ODBC APIs.

#### **Technical Specifications**

The following are the connector capabilities mentioned below:

**Crawling**

<table><thead><tr><th width="134.33331298828125">Feature</th><th width="183.99993896484375">Supported Objects</th><th>Remarks</th></tr></thead><tbody><tr><td>Crawling</td><td>Dimensions</td><td> </td></tr><tr><td>Crawling</td><td>Dimensions Columns</td><td><p>Supported Data Types:</p><p>Integer, Float, Date, String, Object, Error, Boolean, Object, Decimal, Byte, Time, Timestamp</p></td></tr></tbody></table>

**Profiling**

<table><thead><tr><th width="235.79998779296875">Feature</th><th>Support</th></tr></thead><tbody><tr><td>Dimensions Profiling</td><td>Row count, Columns count, View sample data</td></tr><tr><td>Column Profiling</td><td>Min, Max, Null count, distinct, top 50 values</td></tr><tr><td>Full Profiling</td><td>Supported</td></tr><tr><td>Sample Profiling</td><td>Supported</td></tr></tbody></table>

&#x20; **Querying**

<table><thead><tr><th width="298.99993896484375">Operation</th><th>Details</th></tr></thead><tbody><tr><td>Select</td><td>Supported</td></tr><tr><td>Insert</td><td>Not supported, by default.</td></tr><tr><td>Update</td><td>Not supported, by default.</td></tr><tr><td>Delete</td><td>Not supported, by default.</td></tr><tr><td>Joins within database</td><td>Supported</td></tr><tr><td>Joins outside database</td><td>Not supported</td></tr><tr><td>Aggregations</td><td>Supported</td></tr><tr><td>Group By</td><td>Supported</td></tr><tr><td>Order By</td><td>Supported</td></tr></tbody></table>

{% hint style="info" %}
By default, the service account provided for the connector will be used for any query operations. If the service account has write privileges, then Insert / Update / Delete queries can be executed.
{% endhint %}

#### **Pre-requisites**

Ensure that the SSAS Application (ODBC/API service) is installed and running on the designated server before configuring the connector in OvalEdge. For more details, click [here](broken://pages/YbSpik5BvKgGwxWplmvl).

To use the connector, the following need to be available:

* Connection details as specified in the following section should be available.
* An admin/service account for crawling and profiling requires the following minimum privileges:
  * Connection validate
  * Crawl Cubes
  * Crawl Tables
  * Profile Cubes, Tables

#### **Connection Details**

The following are the connection settings that need to be added for connecting to SQL Server‘s Analytical Services:

* **Database Type:** SSAS
* **License Type:** Standard&#x20;
* **Connection Name:** Select a Connection name for the SQL Server Analytical Services database. The name that you specified is a reference name to easily identify your SQL Server Analytical Services database connection in OvalEdge.\
  Example: SQL Server Analytical Services1
* **Server:** SSAS instance URL (on-premises/cloud-based)\
  Example: EC2AMAZ-ISRE34
* **Port number:** 5000 by default
* **Tenant Id:** Respective Tenant Id
* **App Id:** Respective App Id
* **App Secret:** App secret maintained for this SSAS
* **URL:** Provide the URL for this SSAS machine
* **SSAS Server:** It is the SSAS server name where ODBC APIs application is running
* **Deployment File Path:** Enter the deployment file path
* **SSAS Plugin Server:** Provide server name or IP address

{% hint style="info" %}
Once connectivity is established, additional configurations for Crawling and Profiling can be specified.
{% endhint %}

| Property                   | Details                                                                            |
| -------------------------- | ---------------------------------------------------------------------------------- |
| **Crawler configurations** |                                                                                    |
| Tables, views & columns    | By default, it is selected true                                                    |
| Relationships              | Need to select for crawl relationships                                             |
| Crawler rules              | Default includes tables regex has  regex = (.\*), which can crawl all the tables   |
| **Profile Settings**       |                                                                                    |
| Tables and columns         | By default, it is selected true                                                    |
| Views and columns          | By default, it is selected true                                                    |
| Profile Rules              | Default includes tables regex has  regex = (.\*), which can profile all the tables |

**Points to note**

Profiling for Measures & Measure-Folder dimension columns is NOT supported.

***

Copyright © 2026, OvalEdge LLC, Peachtree Corners GA USA


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ovaledge.com/release8.1/connectors/connector-repositories/reporting-tool/microsoft-ssas-sql-server-analysis-services.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.