Extended Properties in Catalog Ingestion

Question

In our SQL Server databases we have included table and column definitions as extended properties. Can I extract these extended properties and load them into Collibra using Collibra Catalog data ingestion?

constancebarton · Answer

I have been informed that the only way to do this via Collibra Catalog is to use a JDBC driver that supports that function (as part of the parameters when connecting to the database). Unfortunately I haven’t found a commercially available JDBC driver for MSSQL Server that supports this function.

Other alternative is to use a custom integration using Java and the REST API. This is probably what we will use.

Former User · Answer

We would be interested in loading the extended properties as well.

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