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 a Microsoft SQL Server Reporting Services 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 the Asset Discovery help.