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.
Permissions
Get a Report Server user with permission to view and download reports and shared data sources from the SSRS administrator. Depending on the scenario, you need to get the Report Builder Role and the Publisher Role or the System User Role.
Connection properties
On the Registration page, you can choose to connect with one of the following SSRS reader modes:
Note: When you create a new catalog source, use the Web service reader mode. Use the Files reader mode only for backward compatibility. Don't use it when you create a new catalog source.
Web service reader mode
Use this option to extract metadata from the SSRS Report Server. Enter the following properties to connect with the Web service reader mode:
Property
Description
Web Service URL
URL of the SSRS Report Server. For example: http://<DomainName>/ReportServer/ReportService2010.asmx
Web Service Domain
Domain name of the SSRS Report Server. For example: domain01
You don't have to prefix a Windows domain.
Web Service Username
User name of the SSRS Report Server in the following format: <user name>
Web Service Password
Password of the SSRS Report Server in the following format: <password>
Files reader mode
Use this option to extract metadata from files and directories in the file system. Specify the path to the Report XML files that you want to extract. Verify that the Secure Agent can access files in the directory. The following example shows the path to a source directory on Linux: /home/ssrs/*.xml
Configuration parameters for metadata extraction
On the Metadata Extraction tab of the Configuration page, expand Catalog Source Configuration Options to configure the following parameters for extracting metadata from an SSRS source system:
Parameter
Description
Default variables values file
Path to the file with default variables values.
File format consists of [VARIABLES] and/or [FUNCTIONS] section.