Microsoft SQL Server Reporting Services (SSRS) is a server-based report generating software system. It is part of a suite of Microsoft SQL Server services. You can use SSRS to prepare interactive and printed reports. SQL administrators can connect to SQL databases and use SSRS tools to format SQL reports.
Objects extracted
Metadata Command Center extracts the following objects from an SSRS source system:
•Folders
•Projects
•DataSets
•Fields
•Reports
•PlSql DataSet Statements
•Calculations
Note: If you run catalog sources created prior to the July 2023 release with Retain as the Metadata Change Option, duplicate calculations appear in Data Governance and Catalog. To avoid duplicate calculations and to view complete lineage information, run catalog sources created prior to the July 2023 release with Delete as the Metadata Change Option.
Data Lineage
Lineage data is available for Microsoft SQL Server Reporting Services (SSRS) assets that connect to the following source systems:
•Microsoft SQL Server
•Oracle
For more information about data lineage, see Data Lineage in the Working With Assets help.