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.
The connectivity to SQL Server’s Analysis Service is via ODBC APIs.
Technical Specifications
The following are the connector capabilities mentioned below:
Crawling
Crawling
Dimensions
Crawling
Dimensions Columns
Supported Data Types:
Integer, Float, Date, String, Object, Error, Boolean, Object, Decimal, Byte, Time, Timestamp
Profiling
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
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
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.
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
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 and Profiling can be specified.
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
Was this helpful?