View in admin portal

Skip to main content

Open support ticket Help & Documentation

Help & Documentation

Search term

Help & DocumentationGetting DataConnecting To Data SourcesSourcing Data from Microsoft SSRS

Connecting To Data Sources

41. Sourcing Data from Microsoft SSRS

View all chapters

Topics

1. General Information about Data Sources 13
- 1.1 Understanding Data Sources
- 1.2 Overview of using existing Elements as Data Sources
- 1.3 Insightd System Requirements
- 1.4 Create New SQL Data Source
- 1.5 Create a New Plugin Data Source
- 1.6 What does the Refresh Metadata button do?
- 1.7 Metric Insights' Plugins
- 1.8 MIQL Syntax Guide for Plugins
- 1.9 Populate a Data Source with an uploaded List of Reports
- 1.10 Getting data from the Metric Insights database
- 1.11 Handling Date/Time columns for various Plug-ins
- 1.12 Plugin URL Editor
- 1.13 Supported Date Formats
2. Storing Data 1
- 2.1 Storing data in Microsoft SQL Server 2016+
3. How to Link to External BI Tools 4
- 3.1 What are External Reports?
- 3.2 Why do I see an empty page when I set my External Report to display in Viewer?
- 3.3 How to link to Other External Content
- 3.4 Create a new External Report Type
4. Configuring Remote Data Collectors 6
- 4.1 Configure a Remote Data Collector
- 4.2 Installing Insightd on Windows Servers
- 4.3 Upgrading Insightd on Windows Servers
- 4.4 Installing Insightd on Linux Servers
- 4.5 Upgrading Insightd on Linux Servers
- 4.6 Troubleshooting a Remote Data Collector
5. JDBC Connections 3
- 5.1 Establishing a JDBC Connection
- 5.2 Add a new JDBC Driver
- 5.3 Validation errors: "Value '0000-00-00' can not be represented as java.sql.Date"
6. Sourcing Data from 1010data 3
- 6.1 Establish connectivity to 1010data
- 6.2 How to collect data from 1010data
- 6.3 Creating 1010data macro code for your 1st Basic Metric
7. Sourcing Data from Adobe Analytics 2
- 7.1 Establish connectivity to Adobe Analytics
- 7.2 How to collect data from Adobe Analytics
8. Sourcing Data from Adaptive Planning 2
- 8.1 Establish connectivity to Adaptive Planning
- 8.2 How to collect data from Adaptive Planning
9. Sourcing Data from Atlassian Confluence 2
- 9.1 Establish connectivity to Atlassian Confluence
- 9.2 How to collect data from Atlassian Confluence
10. Sourcing Data using Atlassian Jira 3
- 10.1 Establish connectivity to Atlassian Jira
- 10.2 How to collect data using Atlassian Jira Plugin
- 10.3 Fetch Commands for JIRA
11. Sourcing Data from SAP BusinessObjects 3
- 11.1 Establish connectivity to SAP BusinessObjects
- 11.2 How to collect data from SAP Business Objects
- 11.3 Pre-filtering SAP BusinessObjects data
12. Sourcing Data from Basecamp 2 2
- 12.1 Establish connectivity to Basecamp 2
- 12.2 How to collect data from Basecamp 2
13. Sourcing Data from Beckon 3
- 13.1 Establish connectivity to Beckon
- 13.2 How to collect data from Beckon
- 13.3 How to collect External Reports from Beckon
14. Sourcing Data from Cognos 3
- 14.1 Establish connectivity to IBM Cognos
- 14.2 How to collect data from IBM Cognos
- 14.3 Pre-filtering Cognos data
15. Sourcing Data from CSV Plugin 1
- 15.1 Establish connectivity to a CSV file via a CSV Plugin
16. Sourcing Data from Dropbox Paper 2
- 16.1 Establish connectivity to Dropbox Paper
- 16.2 How to collect data from Dropbox Paper
17. Sourcing Data using Elasticsearch 2
- 17.1 Establish connectivity to Elasticsearch
- 17.2 How to collect data using Elasticsearch (prior to Version 5.3)
18. Sourcing Data using File Data Plugin 2
- 18.1 Establish connectivity to File Data
- 18.2 How to collect data with File Data
19. Sourcing Data using File Metadata Plugin 2
- 19.1 Establish connectivity to File Metadata
- 19.2 How to collect data with File Metadata
20. Sourcing Data from Fogbugz 2
- 20.1 Establish connectivity to FogBugz
- 20.2 How to collect data from Fogbugz
21. Sourcing Data from Google Analytics 4
- 21.1 Registering Your Server with Google to use their Plugin Resources
- 21.2 Obtaining Client Application credentials from Google Projects
- 21.3 Establish connectivity to Google Analytics
- 21.4 How to collect data from Google Analytics
22. Sourcing Data from Google BigQuery 2
- 22.1 Establish connectivity to Google BigQuery
- 22.2 How to collect data from Google BigQuery
23. Sourcing Data from Google Calendar 2
- 23.1 Establish connectivity to Google Calendar
- 23.2 How to collect data from Google Calendar
24. Sourcing Data from Google Drive 1
- 24.1 Establish Connectivity to Google Drive
25. Sourcing Data from Google Play Console 2
- 25.1 Establish connectivity to Google Play Console
- 25.2 How to collect data from Google Play Console
26. Sourcing Data from Google Sheets 4
- 26.1 Establish connectivity to Google Sheets (5.3 or later)
- 26.2 How to collect data from Google Sheets (5.3 or later)
- 26.3 Establish connectivity to a Google Spreadsheet (prior to 5.3)
- 26.4 How to Collect data from a Google Spreadsheet (prior to 5.3)
27. Sourcing Data from Graphite 1
- 27.1 Establish Connectivity to Graphite
28. Sourcing Data from IBM CoreMetrics 2
- 28.1 Establish connectivity to IBM Coremetrics
- 28.2 How to collect data from IBM Coremetrics
29. Sourcing Data from Marketo 1
- 29.1 Establish Connectivity to Marketo
30. Sourcing Data from MicroStrategy 4
- 30.1 Establish Connectivity to MicroStrategy
- 30.2 How to collect data using Microstrategy plugin
- 30.3 Pre-filtering MicroStrategy data
- 30.4 Create a Dimension with values automatically fetched from MicroStrategy
31. Sourcing Data from Mixpanel 2
- 31.1 Establish Connectivity to Mixpanel
- 31.2 How to Collect Data from Mixpanel
32. Sourcing Data from MongoDB 2
- 32.1 Establish Connectivity to MongoDB
- 32.2 How to Collect Data using MongoDB Plug-in
33. Sourcing Data using OLAP 2
- 33.1 Establish Connectivity to OLAP
- 33.2 How to Collect Data from OLAP
34. Sourcing Data from QlikView 8
- 34.1 QlikView Overview
- 34.2 Download Instructions for PoC
- 34.3 Prerequisites to connecting to QlikView server
- 34.4 Establish Connectivity to QlikView
- 34.5 How to Collect Data using QlikView Plug-in
- 34.6 How to create an External Report from QlikView
- 34.7 Create a Dimension with values fetched from QlikView
- 34.8 Pre-filtering QlikView data
35. Sourcing Data from Re:dash 2
- 35.1 Establish Connectivity to Re:dash
- 35.2 How to collect data from Re:dash
36. Sourcing Data using RSS 2
- 36.1 Establish connectivity to RSS
- 36.2 How to collect data using RSS plugin
37. Sourcing data from Salesforce 2
- 37.1 Establish connectivity to Salesforce
- 37.2 How to collect data from Salesforce
38. Sourcing data from Salesforce SOQL 4
- 38.1 Establish connectivity to Salesforce SOQL
- 38.2 Setting up Salesforce OAuth
- 38.3 How to collect data from Salesforce SOQL
- 38.4 What is the difference between SalesForce plug-in and SalesForce SOQL plug-in?
39. Sourcing Data from Sisense 5
- 39.1 Establish Connectivity to Sisense
- 39.2 How to collect data from Sisense
- 39.3 How to create an External Report from Sisense
- 39.4 Create a Dimension with values automatically fetched from Sisense
- 39.5 Pre-filtering Sisense data (Version 5.1)
40. Sourcing Data from Splunk 2
- 40.1 Establish Connectivity to Splunk
- 40.2 How to Collect Data from Splunk
41. Sourcing Data from Microsoft SSRS 3
- 41.1 Establish Connectivity to Microsoft SSRS
- 41.2 How to Collect Data from SSRS
- 41.3 How SSRS report data is obtained
42. Sourcing Data from Tableau - see Working with Tableau 0
43. Sourcing data from Tibco Spotfire 3
- 43.1 Prerequisites for connecting to Tibco Spotfire
- 43.2 Establish Connectivity to Tibco Spotfire
- 43.3 How to Collect Data Using the Tibco Spotfire Plugin
44. Sourcing data from Treasure Data 2
- 44.1 Establish connectivity to Treasure Data
- 44.2 How to collect data from Treasure Data
45. Sourcing Data from Uptimerobot 2
- 45.1 Establish Connectivity to Uptimerobot
- 45.2 How to Collect Data using Uptimerobot
46. Sourcing Data using a Web Service 1
- 46.1 Connecting to a Web Service
47. Sourcing Data from Zendesk 3
- 47.1 Obtaining Credentials for Zendesk plugin
- 47.2 Establish Connectivity to Zendesk
- 47.3 How to Collect Data from Zendesk
48. Sourcing Data from Google AdWords 1
- 48.1 Establish connectivity to Google AdWords

Generate Manual PDF

Other Resources

Getting Started
Jump Start Guide for Administrators
Jump Start Guide for Regular Users
Getting Data
Connecting To Data Sources
Automating the Collection of Data
Working with Tableau
Working with Qlik Sense
Working with Microsoft Power BI
API Access
Creating Content
Datasets
Creating Basic Metrics and Reports
Creating Dimensions
Creating Dimensioned Metrics and Reports
JavaScript Charting
Alerting
Alerting
Collaboration and Sharing
Adding Context to Metrics
Pushing Information to Users
Chatbot Integrations
System Administration
Deployment & Configuration
Controlling Access to Metric Insights
Controlling Access within Metric Insights
Managing the Metric Insights Environment
Maintenance
How-to Videos
Release Notes

Inline referenced article

×