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:
What is cataloged
The collector catalogs the following information.
Object | Information cataloged |
---|---|
Report |
|
Linked Report |
|
Data Source |
|
Dataset |
|
KPI |
|
Folder |
|
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.
Resource page | Relationship |
---|---|
Report |
|
Linked Report |
|
Dataset |
|
KPI |
|
Data Source |
|
Folder |
|
Lineage for SSRS
Object | Lineage available |
---|---|
Dataset |
|
Data source |
|
Report |
|
Versions supported
The collector supports SQL Server Reporting Services 2022 configured for Native mode. SSRS running in Sharepoint Mode is not supported.
Authentication supported
The collector supports Basic authentication and NTLM authentication for SSRS.