Establish Connectivity to Microsoft SSRS

This article details how to connect to MS SSRS to build Elements in Metric Insights.

VERSION SUPPORTED:

  • SSRS 2019 15.0.7243.37714

NOTE: Versions outside of this list may be supported but are not actively tested. If you have an older or newer version, please work with [email protected] so that we understand your requirements.

1. Access Admin > Collection & Storage > Data Sources

  1. [+New Data Source]
  2. Choose "Microsoft SSRS" from the Other drop-down list
  3. [Next Step]

2. Provide the Required Microsoft SSRS Parameters

  1. Set a descriptive Data Source Name
  2. Provide Report Server URL for accessing the SSRS reports
  3. Specify the host name of the SSRS Server
  4. Enter Username and Plugin Password

Optionally, toggle on Enable On-Demand Element Creation 

3. Specify Optional Microsoft SSRS Paremeters


Description
1

Enter a domain if SSRS login requires it
2

Specify if you want to use specific SSRS folders only

4. Advanced Configuration

  1. Use Remote Data Processor defaults to "no". 
    • Set to "yes" and add an RDP via [+New Data Processor] that will appear below 
  2. Defaults to "automatically" and requires selecting Object List Refresh Trigger
    • Set to "manually" to add reports one-by-one or via a CSV file

What's next?

How to Collect Data from SSRS