Page Comparison

About Collectors

...

• Python 3.6 - 3.10

• Access to the KADA Collector repository that contains the SQL Server whl

  • The repository is currently hosted in KADA’s Azure Blob Storage. You will be given a SAS token to access the repository. Reach out to KADA Support (support@kada.ai) if you do not have access.

  • Download the SQL Server whl (e.g. kada_collectors_extractors_sqlserver_azure-#.#.#-py3-none-any.whl)

• Access to K landing directory

• Access to SQL Server (see section below)

• Check the SQLServer instance port

  • Run the following query and note the local tcp port.

    Code Block
    SELECT local_tcp_port FROM sys.dm_exec_connections WHERE session_id = @@SPID GO

...

{
    "server": "",
    "host": "",
    "username": "",
    "password": "",
    "databases": [""],
    "sqlserver_version": "2016",
    "driver": "ODBC Driver 17 for SQL Server",
    "events_path": "/tmp/Extendedevents*.xel",
    "output_path": "/tmp/output",
    "mask": true,
    "compress": true,
    "meta_only": true
}

...

Step 5: Run the Collector

...