How to reflect Collibra Assets and relations in a Database/Data Warehouse, etc

Question

Hello to all!

In some former experiences I had with Collibra in other companies, all the assets in Collibra and their relations were reflected in a Data Warehouse or Data Lake outside Collibra itself.

This was helpful because with simple SQL queries I was able to put together reports and double checks I needed.

One simple example, I have a Power BI report that checks the assets that have or not Owners attached to them. Of course I can extract this information from a Collibra view, but with this kind of integration with a Database, I could connect my Power BI report directly to the database and with one button update it,without the necessity of downloading new files each time.

Does anybody use this kind of solution? How to do it? API?

Thanks!

Grant Rollerson · Answer

Three ways to extract datasets (check out Data export best practices)

Data Usage Insights (https://productresources.collibra.com/docs/collibra/latest/Content/Reporting/to_insights-data-access-intro.htm) a paid SKU
Output Module (What's new)
GraphQL (Common concepts)

and bring it into your own DG/RDL (data governance reporting layer) database. from there add SCD. Then SQL query or use as data source for your BI tools.

Hopefully it'll be exposed in a normal form SCD canonical via Collibra Data Notebooks ;-)

1	Grant Rollerson SUNCORP CORPORATE SERVICES PTY LTD
2	Tom Friesen Algonquin College
3	SB S Benson Plus3 IT
4	S stefan_busch
5	Brian Lloyd USA TODAY Co.
6	D daverichard