Schedule SQL Server Reporting Services and Power BI Report Server ingestion jobs

You can use Task Scheduler on Windows or Crontab on Mac and Linux to enable the lineage harvester to run scheduled jobs. In a scheduled job, the lineage harvester uploads the SQL Server Reporting Services and Power BI Report Server metadata to Collibra.

Collibra automatically creates new assets and relations at specific times, dates or intervals, using the information in the lineage harvester configuration file.

Example You created a lineage harvester configuration file with connection information to your SQL Server Reporting Services or Power BI Report Server environment. You schedule the lineage harvester job to run each Sunday at 23:00. As a result, your SQL Server Reporting Services and Power BI Report Server metadata is automatically refreshed on a weekly basis.

Warning When you run the lineage harvester, Collibra Data Lineage creates all SSRS and Power BI assets in the same Catalog BI domain. We highly recommend that you do not move these assets to another domain. If you move assets to another domain, they will be deleted and recreated in the initial Catalog BI domain when you synchronize SQL Server Reporting Services or Power BI Report Server. As a consequence, all manually added data of those assets is lost.

Warning Relations that were manually created between SSRS and Power BI Report assets and other assets via a relation type in the operating model, are deleted after a refresh of the metadata.