Microsoft SQL Server
Installation
Section titled “Installation”The Microsoft SQL Sercer connector is based on the node-mssql, which uses Tedious and the TDS protocol. The driver is installed automatically with the Katalogue backend API service.
This connector also support both the Microsoft SQL Server and Azure SQL Server.
Authentication
Section titled “Authentication”Curently, the SQL Server connector only support SQL Server Username/Password authentication and “Windows authentication” through NTLM/domain authentication. Kerberos and Microsoft Entra ID authentication is not yet supported.
Required Permissions
Section titled “Required Permissions”By default, Katalogue requires read access to the following resources:
- information_schema.columns
- information_schema.key_column_usage
- information_schema.table_constraints
- information_schema.referential_constraints
- sys.databases
- sys.schemas
- sys.objects
- sys.tables
- sys.columns
- sys.extended_properties
- sys.partitions
- sys.indexes
- sys.allocation_units
Note that other permissions might be required if custom import queries are used.
Limitations
Section titled “Limitations”Lineage
Section titled “Lineage”The Microsoft SQL Server connector does not provide dataset/table lineage out of the box as this is missing in the information schema.