# 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.

![](https://support.ovaledge.com/hs-fs/hubfs/image-png-Jul-27-2021-05-10-19-41-AM.png?width=425\&name=image-png-Jul-27-2021-05-10-19-41-AM.png)

> 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**

| Feature              | Support                                       |
| -------------------- | --------------------------------------------- |
| Dimensions Profiling | Row count, Columns count, View sample data    |
| Column Profiling     | Min, Max, Null count, distinct, top 50 values |
| Full Profiling       | Supported                                     |
| Sample Profiling     | Not supported                                 |

&#x20; **Querying**

| Operation              | Details                    |
| ---------------------- | -------------------------- |
| Select                 | Supported                  |
| Insert                 | Not supported, by default. |
| Update                 | Not supported, by default. |
| Delete                 | Not supported, by default. |
| Joins within database  | Supported                  |
| Joins outside database | Not supported              |
| Aggregations           | Supported                  |
| Group By               | Supported                  |
| Order By               | Supported                  |

{% 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](https://docs.ovaledge.com/release8.0/connectors/connector-repositories/reporting-tool/microsoft-ssas-sql-server-analysis-services/ssas-application-setup).

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
* **Tenant Id:** Respective Tenant Id
* **App Id:** Respective App Id
* **App Secret:** App secret maintained for this SSAS.
* **URL:** URL for this SSAS machine
* **Server Name:** It is the server name where ODBC APIs application is running.

{% 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