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

| **Feature**        | **Supported Objects**                                                                                                           | **Remarks** |
| ------------------ | ------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| Crawling           | Dimensions                                                                                                                      |             |
| Dimensions Columns | <p>Supported Data Types:</p><p>Integer, Float, Date, String, Object, Error, Boolean, Object, Decimal, Byte, Time, Timestamp</p> |             |

### **Profiling**

See this article [Profile Data](https://support.ovaledge.com/step-by-step-guide-to-setup-ovaledge-profiling) to know more about 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                                 |

### **Querying**&#x20;

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

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

## **Pre-requisites**

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.

> Once connectivity is established, additional configurations for [Crawling](https://support.ovaledge.com/understanding-crawler-settings) and [Profiling](https://support.ovaledge.com/understanding-profiling-settings) can be specified.

| **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 © 2025, OvalEdge LLC, Peachtree Corners GA USA