SQL Server Reporting Services operating model

The harvester collects SQL Server Reporting Services metadata and sends it to the Collibra Data Lineage server. Collibra processes the metadata and creates new SSRS assets and relations in Data Catalog. You can see them on the asset page overview or visualize them in a diagram or in a technical lineage.

Note 
  • The assets have the same names as their counterparts in SQL Server Reporting Services. Full names and Names cannot be changed in Data Catalog.
  • Assets ingested from SQL Server Reporting Services are called SSRS assets in Data Catalog.
  • Asset types are only created if you have all specific SQL Server Reporting Services and Data Catalog permissions.
  • All SSRS asset types are created in the same domain.
  • Relations that were manually created between SSRS assets and other assets via a relation type in the SQL Server Reporting Services operating model, are deleted after synchronizing the SQL Server Reporting Services metadata.

SQL Server Reporting Services metadata overview

The following image shows the relations between SSRS asset types.

Harvested metadata per asset type

This table shows the harvested SQL Server Reporting Services metadata for each SSRS asset type, assuming you have the necessary subscriptions and configurations for a full ingestion.

Asset type Harvested SQL Server Reporting Services metadata in Data Catalog
SSRS Column
  • Full name
  • NameDisplay name
  • Description
  • Technical Data Type
  • BI Data Model contains / is part of BI Data Attribute
  • Column is source for / is target of Data Attributes
  • Data Element targets / sources Data Element
  • Data Entity contains / is part of Data Attribute
SSRS Data Model
  • Full name
  • NameDisplay name
  • Description
  • Certified
  • URL
  • Document creation date
  • Document modification date
  • Document size
  • Visible on server
  • Location
  • BI Data Model contains / is part of BI Data Attribute
  • Data Asset is source for / source BI report
  • BI Folder contains / contained in Data Asset
  • Data Entity is part of / contains Data Model

SSRS Folder
  • Full name
  • NameDisplay name
  • Description
  • URL
  • Document creation date
  • Document modification date
  • Visible on server
  • Location
  • BI Folder assembles / is assembled in BI Folder
  • Business Dimension groups / is grouped into Report
  • BI Folder contains / contained in Data Asset
  • Server hosts / is hosted in Business Dimension

SSRS KPI
  • Full name
  • NameDisplay name
  • Description
  • Certified
  • URL
  • Document creation date
  • Document modification date
  • Document size
  • Visible on server
  • Location
  • Report Attribute contained in / contains Report
  • Report related to / impacted by Business Asset
  • Data Asset is source for / source BI Report
  • Business Dimension groups / is grouped into Report
SSRS Parameter
  • Full name
  • NameDisplay name
  • Description
  • Report Attribute contained in / contains Report
  • Report Attribute sourced from / is source of Data Attribute
  • Business Asset represents / represented by Data Asset
SSRS Report
  • Full name
  • NameDisplay name
  • Description
  • Certified
  • URL
  • Document creation date
  • Document modification date
  • Document size
  • Visible on server
  • Location
  • Report uses / is used in Report
  • Data Asset is source for / source BI Report
  • Report related to / impacted by Business Asset
  • Business Dimension groups / is grouped into Report
SSRS Server
  • Full name
  • NameDisplay name
  • Description
  • Server hosts / is hosted in Business Dimension

Example of ingested SQL Server Reporting Services metadata

The following image shows an example structure after SQL Server Reporting Services ingestion.