SSRS and PBRS operating model

The lineage harvester collects SQL Server Reporting Services (SSRS) 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 SSRS and Power BI Report Server (PBRS). Full names and Names cannot be changed in Data Catalog.
  • Assets ingested from SSRS and PBRS are called SSRS assets in Data Catalog, except for PBRS reports which are called Power BI Report assets.
  • Asset types are only created if you have all specific Data Catalog permissions.
  • All SSRS and PBRS assets are created in the same domain.
  • Relations that were manually created between SSRS assets or PBRS assets and other assets via a relation type in the SSRS and PBRS operating model, are deleted after synchronizing the metadata.

SSRS and PBRS metadata overview

The following image shows the relations between SSRS asset types and the Power BI Report asset type.

Harvested metadata per asset type

This table shows the harvested SSRS and PBRS metadata for each SSRS asset type and Power BI Report asset type, assuming you have the necessary subscriptions and configurations for a full ingestion.

Asset type Harvested SSRS metadata in Data Catalog
SSRS Column
  • Full name
  • NameDisplay name
  • Description
  • Technical Data Type
  • BI Data Model contains / is part of BI Data Attribute
  • 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 / 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
Power BI Report
  • Full name
  • Name
  • Description
  • Certified
  • URL
  • Document creation date
  • Document modification date
  • Document size
  • Visible on server
  • Location
  • Business Dimension groups / is grouped into Report
  • Report related to / impacted by Business Asset
  • Report uses / used in Report
  • Data Asset is source for / source BI Report
SSRS Server
  • Full name
  • NameDisplay name
  • Description
  • Server hosts / is hosted in Business Dimension
SSRS Table
  • Full name
  • Display name
  • Description
  • Data Entity contains / is part of Data Attribute
  • Data Entity is part of / contains Data Model

Example of ingested SSRS and PBRS metadata

The following image shows an example structure after SSRS and PBRS ingestion.