Unsupported Screen Size: The viewport size is too small for the theme to render properly.
Published by Collibra Catalog

JDBC Driver for SQL Server

Request Information

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

Media

More details

Release Notes

The driver has been certified with the username/password authentication scheme for the following:

  • Ingestion of technical metadata from the source.
  • Profiling of the registered data source and calculation of 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.

Functionality
Required 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 )
Compatibility
  • Collibra Cloud
  • Collibra 5.7.5 and newer
Dependency
  • N/A
License and Usage Requirements
  • Collibra Catalog
  • Metadata Integration

Release History

Version 21.0.7867
July 16, 2021
Release Notes

The driver has been certified with the username/password authentication scheme for the following:

  • Ingestion of technical metadata from the source.
  • Profiling of the registered data source and calculation of 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.

Functionality
Required 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 )
Compatibility
  • Collibra Cloud
  • Collibra 5.7.5 and newer
Dependency
  • N/A
License and Usage Requirements
  • Metadata Integration
Version 21.0.7807
May 17, 2021
Release Notes

The driver has been certified with the username/password authentication scheme for the following:

  • Ingestion of technical metadata from the source.
  • Profiling of the registered data source and calculation of 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.

Functionality
Required 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 )
Compatibility
  • Collibra Cloud
  • Collibra 5.7.5 and newer
Dependency
  • N/A
License and Usage Requirements
  • Metadata Integration
Version 20.0.7662
December 23, 2020
Release Notes

The driver has been certified with the username/password authentication scheme for the following:

  • Ingestion of technical metadata from the source.
  • Profiling of the registered data source and calculation of 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.

Functionality
Required 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 )
Compatibility
  • Collibra Cloud
  • Collibra 5.7.5 and newer
Dependency
  • N/A
License and Usage Requirements
  • Metadata Integration

Support is provided in accordance with the Marketplace Terms.

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.

Submit a support ticket

Use of this solution requires a license to Collibra Data Intelligence Cloud and the purchase of Metadata Integrations at a volume commensurate with desired use. Please contact your sales representative or Customer Success Manager for more information.

Reviews

Rating
Leave a review