Collibra Data Lineage supports the integration of SQL Server Reporting Services (SSRS) and Power BI Report Server (PBRS) in Collibra. We refer to this integration as the "SSRS-PBRS integration".
The following table shows the required steps for integration.
| # | Step | Description |
|---|---|---|
| 1 | Review the preflight checks. | Key considerations to help ensure successful integration, including required Edge, technical lineage, and data source-specific permissions, network requirements and more. |
| 2 | Optionally, create a new target domain for asset ingestion. | You can choose an existing domain or create a new one. |
| 3 |
Create an SSRS-PBRS connection. |
Create a connection to allow Collibra Data Lineage to connect to and retrieve metadata from SQL Server Reporting Services or Power BI Report Server. |
| 4 |
Add the Technical Lineage for SSRS/PBRS capability. |
Add the technical lineage capability to your Edge or Collibra Cloud site. The capability allows the lineage harvester to retrieve data from your data source. |
| 5 | Synchronize the technical lineage. |
You can synchronize your technical lineage manually or automatically by adding a synchronization schedule. |
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.
Helpful resources
- SSRS-PBRS preflight checks
- SSRS-PBRS operating model
- SSRS-PBRS terminology
- SSRS-PBRS asset types and domain types
- SSRS-PBRS source configuration for Edge
- Edge harvester network requirements
- Connect to a Collibra Data Lineage service instance via OAuth authentication
- Connect to a proxy server
- Automatic stitching for technical lineage
- Technical lineage admin options
- Delete a technical lineage
- Sharing database models across data sources