Overview of SSRS and PBRS steps

The SQL Server Reporting Services (SSRS) and Power BI Report Server (PBRS) integration in Collibra Data Intelligence Cloud enables you to harvest SSRS and PBRS metadata and create new SSRS and Power BI assets in Data Catalog. Collibra analyzes and processes the BI metadata and presents it as assets of specific types, retaining their original names.

Important In the global assignment of each asset type included in the SSRS-PBRS operating model, ensure that none of the characteristics that are in the operating model have a maximum cardinality of “0”. If the maximum cardinality is set to “0” for any such characteristics, ingestion will fail.

Note While SSRS and PBRS use the same API, we can access less information from PBRS reports than from SSRS data. As a result, we do not support stitching and lineage information for PBRS reports.

Roles and permissions in SSRS or PBRS.

To ingest SSRS and PBRS metadata into Data Catalog, the lineage harvester connects to the SSRS or PBRS web portal. You need a role with user access to the server from which you want to ingest:

• You have a system-level role, which is at least a System user role.
• You have an item-level role, which is at least a Content Manager role.

Note You can ingest SSRS and PBRS with any report server subscription. We highly recommend to install and use the latest version of SSRS and PBRS .

Steps

The table below shows the steps and prerequisites required to integrate SSRS in Data Catalog.

{
 "general": {
  "catalog": {
   "url": "https://<organization>.collibra.com",
   "username": "<your-collibra-username>"
  },
  "useCollibraSystemName": false
 },
 "sources": {
  "collibraSystemName" : "",
  "id": "<unique-id>",
  "type": "<SSRS or PBRS>",
  "url": "http://<IP address>/Reports",
  "username": "<user-name>",
  "domainId": "<domain-resource-id>",
  "folderFilter":  ["/Folder1/*", "Folder2"]
 }
}