Skip to main content

Preparing to run the SQL Server Reporting Services (SSRS) collector

Setting up pre-requisites for running the collector

Make sure that the machine from where you are running the collector meets the following hardware and software requirements.

Table 1.

Item

Requirement

Hardware (for on-premise runs only)

Note: The following specs are based upon running one collector process at a time. Please adjust the hardware if you are running multiple collectors at the same time.

RAM

8 GB

CPU

2 Ghz processor

Software (for on-premise runs only)

Docker

Click here to get Docker.

data.world specific objects (for both cloud and on-premise runs)

Dataset

You must have a ddw-catalogs dataset set up to hold your catalog files when you are done running the collector.

If you are using Catalog Toolkit , follow these instructions to prepare the datasets for collectors.



Setting up SSRS

Configuring Authentication

The collector harvests from SSRS using Basic Authentication:

  1. If your SSRS instance does not basic authentication configured, follow the instructions in the Microsoft documentation to set up basic authentication on your SSRS environment.

  2. Create a user that the collector will use for authentication and harvesting of SSRS objects.

  3. Apply the Browser role to the user you just created.

These authentication details are used while configuring the CLI for the collector.