SQL Server Reporting Services (SSRS) is a Microsoft tool used to create, manage, and deliver paginated reports from relational and multidimensional data sources. It enables users to design reports with tables, charts, and visualizations, and publish them to a web portal for secure access and sharing.
This provider does not support native column-to-column lineage. Column-level lineage can be enabled through lineage parsing. To activate this feature, contact our Customer Success team. For more information, see Sources of data lineage.
Default hierarchy
In the chart below, you will find the organizational structure of SQL Server Reporting Services objects. Objects are in represented in green and folders are in yellow.
Object Types
Dawiso ingests the following objects from SSRS:
Data Source
Maps to SSRS Data Source object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Description | Scanned Description |
| CreatedDate | Created at |
| CreatedBy | Created by |
| ItemID | ID |
| IsHidden | Is hidden |
| ModifiedDate | Modified at |
| ModifiedBy | Modified by |
| URL | URL |
| ConnectionString | Connection String |
| ContentSize | Content Size |
| CredentialRetrieval | Credential Retrieval |
| Enabled | Enabled |
| Extension | Extension |
| Path | Path |
Excel
Maps to SSRS Excel object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Description | Scanned Description |
| CreatedDate | Created at |
| CreatedBy | Created by |
| ItemID | ID |
| IsHidden | Is hidden |
| ModifiedDate | Modified at |
| ModifiedBy | Modified by |
| URL | URL |
| Path | Path |
Folder
Maps to SSRS Folder object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Description | Scanned Description |
| CreatedDate | Created at |
| CreatedBy | Created by |
| ItemID | ID |
| IsHidden | Is hidden |
| ModifiedDate | Modified at |
| ModifiedBy | Modified by |
| URL | URL |
| Path | Path |
Report
Maps to SSRS Report object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Description | Scanned Description |
| CreatedDate | Created at |
| CreatedBy | Created by |
| ItemID | ID |
| IsHidden | Is hidden |
| ModifiedDate | Modified at |
| ModifiedBy | Modified by |
| Type | Type |
| URL | URL |
| ContentSize | Content Size |
| ExecutionFlag | Execution Flag |
| ExecutionTime | Execution Time |
| LastExecParameters | Parameters |
| LastExecTimeDataRetrieval | Data Retrieval ms |
| LastExecTimeEnd | End Time |
| LastExecTimeProcessing | Processing ms |
| LastExecTimeRendering | Rendering ms |
| LastExecTimeStart | Start Time |
| LastExecTotalDuration | Total Duration ms |
| LastExecUser | User |
| MimeType | Mime Type |
| Path | Path |
| SnapshotLimit | Snapshot Limit |
| SubType | Subtype |
Report Data Source
Maps to SSRS Report Data Source object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Description | Scanned Description |
| ItemID | ID |
| SharedDatasourceURL | URL |
| ConnectionString | Connection String |
| DataProvider | Data Provider |
| IsShared | Is Shared |
| SharedDataSourceName | Shared Data Source Name |
Report Dataset
Maps to SSRS Report Dataset object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Description | Scanned Description |
| ItemID | ID |
| SharedDatasetURL | URL |
| CommandText | Command Text |
| CommandType | Command Type |
| DataProvider | Data Provider |
| DataSource | Data Source |
| IsShared | Is Shared |
| SharedDatasetName | Shared Dataset Name |
Report Parameter
Maps to SSRS Report Parameter object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Nullable | Nullable |
| State | State |
| Type | Type |
| AllowBlank | Allow Blank |
| DefaultValues | Default Values |
| Dependencies | Dependencies |
| DynamicDefaultValue | Dynamic Default Values |
| DynamicPrompt | Dynamic Prompt |
| DynamicValidValues | Dynamic Valid Values |
| HasDefaultValues | Has Default Values |
| HasDependencies | Has Dependencies |
| HasValues | Has Values |
| MultiValue | Multivalue |
| Prompt | Prompt |
| PromptUser | Prompt User |
| UsedInQuery | Used in Query |
| Values | Values |
Report Power BI
Maps to SSRS Report Power BI object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Description | Scanned Description |
| CreatedDate | Created at |
| CreatedBy | Created by |
| ItemID | ID |
| IsHidden | Is hidden |
| ModifiedDate | Modified at |
| ModifiedBy | Modified by |
| Type | Type |
| URL | URL |
| ContentSize | Content Size |
| ExecutionFlag | Execution Flag |
| ExecutionTime | Execution Time |
| LastExecParameters | Parameters |
| LastExecTimeDataRetrieval | Data Retrieval ms |
| LastExecTimeEnd | End Time |
| LastExecTimeProcessing | Processing ms |
| LastExecTimeRendering | Rendering ms |
| LastExecTimeStart | Start Time |
| LastExecTotalDuration | Total Duration ms |
| LastExecUser | User |
| MimeType | Mime Type |
| Path | Path |
| SnapshotLimit | Snapshot Limit |
| SubType | Subtype |
Shared Dataset
Maps to SSRS Shared Dataset object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Description | Scanned Description |
| CreatedDate | Created at |
| CreatedBy | Created by |
| ItemID | ID |
| IsHidden | Is hidden |
| ModifiedDate | Modified at |
| ModifiedBy | Modified by |
| URL | URL |
| CommandText | Command Text |
| ContentSize | Content Size |
| DataSource | Data Source |
| Path | Path |