How to Collect Data from SSRS
This article will show you how to create a Metric or Internal Report using a SSRS as a data source. It assumes that you have already established connectivity to the SSRS data source desired.
1. Access New > Metric
Provide the basic information required for creating a new metric:
- Specify this Metric's Measure. If you do not see the measure that you want to use, scroll down to the bottom of the drop-down list and create a new one by clicking Add New Measure
- Select the Measurement Interval that applies to your element
- Give the element a unique Name
- Optionally, assign a Category
- Click Next: define details to proceed with data collection
2. Full Editor displays the Data Collection tab
- Select the Microsoft SSRS connection profile serving as a Data Source for this Metric
- Set the Data Collection Trigger which is going to initiate updating information in a Metric
- Report: Choose a Microsoft SSRS Report that should serve as a basis for a future Metric
- Construct a Plugin command that should list the data you would like to include into the Metric (manually of via the Visual Editor). Please note that Metrics represent time series data, so one of the columns should contain dates.
- Validate your Plug-in Command. If your statement is valid, the statement box is green; if there are any errors, the box is colored in red and errors will be explained in the field below.
- Collect Data and Enable and Publish
2.1. Example using the Visual Editor
The SSRS Query Builder is called by Visual Editor link
- Select Fields and set Expressions
- You can pre-filter the information before fetching it into Metric Insights. To do so, add Filters in the Query Builder
- Optionally you can add 'ascending' and 'descending' Sorting to the field values
Save your settings. Command validation will start automatically.