Before you start the SSRS-PBRS integration, you have to enable Collibra to access your SSRS-PBRS data.
You need the following roles, with user access to the server from which you want to ingest:
- A system-level role that is at least a System user role.
- An item-level role that is at least a Content Manager role.
We recommend that you use SQL Server 2019 Reporting Services or newer. We can't guarantee that older versions will work.
Limitations
- Transformations are not included in the integration. Therefore, no transformations details are shown on the Sources tab page.
- Some of the more complex SQL queries might not be supported.
- There are known limitations to the metadata returned by the API when integrating PBRS. For example, Power BI reports in PBRS are ingested as Power BI Report assets in Data Catalog, but there is no technical lineage for the reports.