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 12
- 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
2. Storing Data 1
- 2.1 Storing data in Microsoft SQL Server 2016+
3. How to Link to External BI Tools 5
- 3.1 What are External Reports?
- 3.2 How to link to an External Report
- 3.3 Why do I see an empty page when I set my External Report to display in Viewer?
- 3.4 How to link to Other External Content
- 3.5 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 2
- 47.1 Establish Connectivity to Zendesk
- 47.2 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

Inline referenced article

×