SQL Server (via Collector method)

This page outlines the SQL Server Collector versions that are available.

We always recommend using the latest Collector Method to ensure that you can access the latest features.


Integration details

Scope

Included

Comments

Scope

Included

Comments

Metadata

YES

 

Lineage

YES

Requires logging to be enabled

Usage

YES

 

Sensitive Data Scanner

NO

Sensitive data scanner does not currently support SQL Server

Known limitations

  • Queries, macros and procedures must include fully qualified names in order to be correctly parsed.


Latest Version - V3.0

  • Access instructions on how to connect using SQL Sever Collector Method V3.0.1

  • This version is compatible with K platform versions: 5.24

  • Key upgrades include:

    • New types metadata that will be extracted include:

      • host

      • meta_only


SQL Server Version History

Version Number

Release Month

K Platform Compatibility

Collector Core Library Compatibility

Release changes

Version Number

Release Month

K Platform Compatibility

Collector Core Library Compatibility

Release changes

V3.01

Mar 2023

5.24+

1.0

 

  • New types metadata that will be extracted include:

    • host

    • meta_only

V3.0.0

Nov 2022

5.23+

1.0

  • Compress metadata included

  • Introduction of Kada collector common library Collector that will need to be installed for the collector to operate

V2.0.0 V2.0.3

May 2022

5.17 - 5.22

N/A