Page Comparison

About Collectors

Collectors are extractors that are developed and managed by you (A customer of K).

...

• Python 3.6 - 3.10

• Support SQL SSRS 2016+ where the database is called ReportServer$RS

  • if your SSRS databases differs from this, please Advise KADA of the SSRS version and what the database is called.

  • The collector will need access to the underlying SQLServer Database with permissions to read the following tables:

    • ReportServer$RS.DBO.CATALOG

    • ReportServer$RS.DBO.EXECUTIONLOG3

    • ReportServer$RS.DBO.USERS

• Access to K landing directory

• Access to the KADA Collector repository that contains the SSRS 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 SSRS whl (e.g. kada_collectors_extractors_ssrs-#.#.#-py3-none-any.whl)

• Check your SSRS 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

...

Some python packages also have dependencies on the OS level packages, so you may be required to install additional OS packages if the below fails to install.

You can download the latest Core Library and whl via Platform Settings → Sources → Download Collectors

...

Run the following command to install the collector

pip install kada_collectors_extractors_ssrs-3.0.0-py3<version>-none-any.whl

You will also need to install the common library kada_collectors_lib -1.0.0 for this collector to function properly.

pip install kada_collectors_lib-1.0.0-py3<version>-none-any.whl

...