The Azure Synapse JDBC driver can be used in Collibra Catalog in the section ‘Collibra provided drivers’ to register Azure Synapse 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:
- Primary keys
- Foreign keys
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 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.
Data is transferred to Azure Synapse via the upload of CSV data to Azure Blob, which is then copied to Azure Synapse.
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 )
- Collibra Cloud
- Collibra 5.7.5 and newer
- MSSQL 2008 and newer
- Azure Synapse Analytics
- Azure SQL Data Warehouse
- A relational database service
License and Usage 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.
Use of this solution requires a license to Collibra Catalog and the purchase of Metadata Connectors at a volume commensurate with desired use. Please contact your sales representative or Customer Success Manager for more information.