Skip to main content

About the SQL Server Reporting Services (SSRS) collector

Important

The SSRS collector can be run in the cloud or on-premise using Docker or Jar files.

Note

The latest version of the Collector is 2.249. To view the release notes for this version and all previous versions, please go here.

This collector is designed to provide you with an effective solution for extracting metadata from your SSRS environment into the data.world catalog. The integration facilitates the automated extraction, organization, and presentation of specific metadata elements from the SSRS system. It gives valuable insights into your datasets, data sources, folders, KPIs, reports, and linked reports – all within the data catalog in data.world.

With the SSRS collector, you can:

  • Learn more about your reports and data, including who created a report or dataset and when they were last updated, helping you understand and trust your data

  • See the lineage of which datasets were used in a report, allowing you a comprehensive view of the data flowing into a report

  • Keep track of KPIs from SSRS and integrate them with business metrics from other source systems, all within one easy-to-use catalog, leading to better data-informed decisions

An example of metadata from an SSRS Report, including Lineage:

ssrs_collector_sample.png
SSRS2.png

What is cataloged

The collector catalogs the following information.

Table 1.

Object

Information cataloged

Report

  • ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Data Sources, Favorite, Content Type, Policies

Linked Report

  • ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Content Type, Policies

Data Source

  • ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Parent Folder ID, Connection String, Connection String Overridden, Data Source Type, Credential Retrieval, Content Type, Enabled, Original Connection String Expression Based, Policies

Dataset

  • ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Policies

KPI

  • ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Content Type, Currency, Value Format, Visualization, Content Type, Policies

Folder

  • ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Content Type, Policies



Relationships between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.

Table 2.

Resource page

Relationship

Report

  • Integrated Data Source contained within the Report

  • Referenced Datasets contained within the Report

  • Integrated Datasets contained within the Report

Linked Report

  • The Report that the Linked Report links to / parameterizes

Dataset

  • Referenced Data Source embedded within the Dataset

KPI

  • Dataset referenced by KPI

  • Data source associated with the KPI Report

Data Source

  • Dataset that contain a Data Source

Folder

  • SSRS Resources (KPI, Datasets, Data Sources, Reports, Linked Report) Contained in Folder

  • Sub-folders contained within the Folder



Lineage for SSRS

Table 3.

Object

Lineage available

Dataset

  • Data Source that the dataset sources its data from

  • Reports that use its data from the dataset

Data source

  • Datasets that sources data from this data source

  • Reports that use data from this data source

Report

  • Datasets from which this report sources data

  • Data sources from which this report sources data



Versions supported

  • The collector supports SQL Server Reporting Services 2022 configured for Native mode. SSRS running in Sharepoint Mode is not supported.

Authentication supported