Page Comparison

About Collectors

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

...

1. Deploying and orchestrating the extract code

2. Managing a high water mark so the extract only pull the latest metadata

3. Storing and pushing the extracts to your K instance.

...

Pre-requisites

...

Collector Server Minimum Requirements

SSRS Requirements

• 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

• 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

...

1. Teradata IP Reference Only Data Source

2. SAP NetWeaver Data Source

3. XML Data Source

4. Web Service Data Source

5. XML Document Data Source

6. Sharepoint Data Source

The following catalog item types are currently NOT supported:

1. Linked Reports

2. Files

3. Power BI Desktop Files

4. Report Models

Parameter resolution is not supported.

SSAS query syntax is not supported

Some TSQL syntax is not support. These are mostly statements that contain not standard ANSI SQL constructs. Examples include:

1. Variables (DECLARE)

2. Flow control (IF BEGIN .. )

...

Step 1: Create the Source in K

...