Overview
The SQL Server JDBC driver can be used in the Collibra Catalog in the section ‘Collibra provided drivers’ to register SQL Server sources. Leveraging this driver, Collibra Catalog will be able to register database information and extract the structure of the source into its schemas, tables and columns.
Collibra JDBC drivers can retrieve the following technical metadata from the source:
- Schemas
- Tables
- Views
- Columns
- Primary keys
- Foreign keys
More details
Release Notes
The driver has been tested with the username/password authentication scheme for the following:
- Ingestion of technical metadata from the source.
- Profiling of the registered data source and calculate statistics that describe the data.
You can use this JDBC Driver to connect to any instance of Microsoft SQL Server, Azure SQL Server, or Azure Data Warehouse.
Required database permissions
In order for Collibra Catalog to access your database, the user requires the following database permissions.
Structural Metadata Ingestion CONNECT SQL (system level)
VIEW DEFINITION (database level)Data Profiling SELECT (table level – grant this to every table to be profiled )
Dependencies
- Collibra Platform 5.7
- MSSQL Server versions 2008 (or later) or Azure SQL Database or Azure Synapse Analytics or Azure SQL Data Warehouse
- MSSQL Server Linked Servers are supported.
License Requirements
- Collibra Catalog
- Metadata Connector
Release Notes
The driver has been tested with the username/password authentication scheme for the following:
- Ingestion of technical metadata from the source.
- Profiling of the registered data source and calculate statistics that describe the data.
Dependencies
- Collibra Platform 5.7
- MSSQL Server versions 2008, 2012, 2014, 2016, and 2019.
License Requirements
- Collibra Catalog
- Metadata Connector
Release Notes
The driver has been tested with the username/password authentication scheme for the following:
- Ingestion of technical metadata from the source.
- Profiling of the registered data source and calculate statistics that describe the data.
Dependencies
- Collibra Platform 5.7
- MSSQL Server versions 2008, 2012, 2014, 2016, and 2019.
License Requirements
- Collibra Catalog
- Metadata Connector
Release Notes
The driver has been tested with the username/password authentication scheme for the following:
- Ingestion of technical metadata from the source.
- Profiling of the registered data source and calculate statistics that describe the data.
Dependencies
- Collibra Platform 5.7
- MSSQL Server versions 2008, 2012, 2014, 2016, and 2019.
License Requirements
- Collibra Catalog
- Metadata Connector
Support is provided for the template as downloaded from the Marketplace, without changes to the way it works. These drivers are designed to only work with Collibra Catalog and cannot be used for other purposes.
You require a license to download and use JDBC drivers. Please contact your sales representative or Customer Advisory Manager for more information.
The license fee for JDBC drivers depends on the number of Connected Systems. This can be any data source which you register on Collibra Platform using any certified JDBC driver available on Collibra Marketplace.
This license fee covers metadata ingestion and basic profiling, regardless of volume and amount of tables or columns. In the context of the SQL Server driver, the Connected System is the SQL Server database.
