JDBC Driver for SQL Server
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
August 2022 release with latest updates and, where relevant, bug fixes.
Compatibility
- Collibra Data Intelligence Cloud
- Collibra 5.7.5 and newer
Dependency
- N/A
License and Usage Requirements
- Metadata Integration
Release History
Release Notes
April 2022 release with latest updates and, where relevant, bug fixes.
Compatibility
- Collibra Data Intelligence Cloud
- Collibra 5.7.5 and newer
Dependency
- N/A
License and Usage Requirements
- Collibra Catalog
- Metadata Integration
Release Notes
- No longer throws error:
The SQL Error Number is 102, State is 1, Severity is 15, Error is ‘Incorrect syntax near ‘.’.’, Server name is <server name>, Line number is <line number>.The Token Type is <token type>.
- Issue cause: https://docs.microsoft.com/
en-us/sql/relational- databases/databases/database- identifiers?redirectedfrom= MSDN&view=sql-server-ver15 - Solution release note: CData JDBC Driver for SQL Server – Changelog (see build number 8081).
Compatibility
- Collibra Data Intelligence Cloud
- Collibra 5.7.5 and newer
Dependency
- N/A
License and Usage Requirements
- Metadata Integration
- Collibra Catalog
Release Notes
Performed the testing with the latest driver (Build 21.0.8013)
This allows us to set up Edge connection without explicit Database property and both ingestion and profiling works.
Compatibility
- Collibra Data Intelligence Cloud
- Collibra 5.7.5 and newer
Dependency
- N/A
License and Usage Requirements
- Metadata Integration
- Collibra Catalog
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.
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.
