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.
Data classification for Microsoft SQL Server Reporting Services objects
Configure data classification for Microsoft SQL Server Reporting Services catalog sources to classify and organize data in your organization.
You can choose one of the following options:
•Data Classification Rules. Choose from predefined or custom data classifications.
•Generated Data Classifications. CLAIRE automatically generates data classifications for the data elements.
You can view the data classification results in Data Governance and Catalog.
For more information about data classifications, see Data classification in the Administration help.
Glossary association
Enable glossary association and configure settings for the catalog source to automatically associate or recommend glossary terms as business names for data elements in technical assets.
The following table describes the settings:
Property
Description
Enable auto-acceptance
When enabled, this option automatically associates glossary terms with data elements based on the threshold limit that you specify. The automatically accepted glossary terms appear as business names of data elements in Data Governance and Catalog.
Confidence Score Threshold for Auto-Acceptance
Specify a percentage from 80 to 100 inclusive to set a threshold limit. If a glossary term matches a data asset within the threshold specified, Metadata Command Center automatically assigns the matching glossary term to the data element. The name and description of the glossary term with the highest confidence score appears as the name and description of the data element asset in Data Governance and Catalog.
Enable below-threshold recommendations
If you enable auto-acceptance, you can select this option to receive glossary association recommendations below the auto-acceptance threshold.
Confidence score threshold for recommendations
If you enable auto-acceptance, specify a percentage between 80% and the selected confidence score threshold for auto-acceptance.
If you disable auto-acceptance, specify a percentage between 80% and 100%.
Assign business names and descriptions
Choose to automatically assign business names and descriptions to technical assets.
Keep existing business names and descriptions
Applicable if you choose to assign business names and descriptions.
Choose to retain existing assignments and only assign business names and descriptions to assets that don't have assignments, or allow overwrite of existing assignments.
By default, existing assignments are retained.
Ignore Keywords
Choose to ignore specific parts of data elements when making recommendations. You can enter multiple unique prefix and suffix keywords. Keyword values are case insensitive.
Glossary Association Scope
Choose specific top-level business glossary assets to associate with technical assets. Selecting a top-level asset selects its child assets as well.
For more information about the glossary association settings, see the Administrator help.