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 if 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

Known SSRS Collector limitations

...

{
        "myDSN": {
            "host": "myhost",
            "database": "mydatabase"
        }
    }

...