Open support ticket Help & Documentation

Help & Documentation

Connecting To Data Sources

1. General Information about Data Sources
- 1.1 Understanding Data Sources
- 1.2 Overview of using existing Elements as Data Sources
- 1.3 Insightd System Requirements
- 1.4 MI Preflight: Plugin pre-check tool
- 1.5 Create New SQL Data Source
- 1.6 Create a New Plugin Data Source
- 1.7 What does the Refresh Metadata button do?
- 1.8 Metric Insights' Plugins
- 1.9 MIQL Syntax Guide for Plugins
- 1.10 Populate a Data Source with an uploaded List of Reports
- 1.11 Getting data from the Metric Insights database
- 1.12 Plugin URL Editor
- 1.13 Handling Date/Time columns for various Plug-ins
- 1.14 Supported Date Formats
2. Storing Data
- 2.1 Storing data in Microsoft SQL Server 2016+
- 2.2 Installing a Microsoft SQL Agent to improve INSERT performance when storing data in SQL Storage
3. How to Link to External BI Tools
- 3.1 What are External Reports?
- 3.2 Filtering in External Reports (Pre-filtering BI tools)
- 3.3 How to omit Filters from External Reports
- 3.4 Make External Reports Discoverable
- 3.5 Create a new External Report Type
- 3.6 How to link to Other External Content
- 3.7 Why do I see an empty page when I set my External Report to display in Viewer?
- 3.8 Set Custom Access Request Messages for External Reports
- 3.9 Handle "All Values" as Filter Value in Tableau
4. Configuring Remote Data Collectors
- 4.1 Configure a Remote Data Collector/Processor
- 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/Processor
- 4.7 Configuring a Remote Data Processor on Windows Servers
5. JDBC Connections
- 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 Adobe Analytics
- 6.1 Establish connectivity to Adobe Analytics
- 6.2 Collect data from Adobe Analytics
7. Sourcing Data from Adaptive Planning
- 7.1 Establish connectivity to Adaptive Planning
- 7.2 Collect data from Adaptive Planning
8. Sourcing Data from Atlassian Confluence
- 8.1 Establish connectivity to Atlassian Confluence
- 8.2 Collect data from Atlassian Confluence
9. Sourcing Data using Atlassian Jira
- 9.1 Establish connectivity to Atlassian Jira
- 9.2 Collect data from Atlassian Jira
- 9.3 Fetch Commands for JIRA
10. Sourcing Data from SAP BusinessObjects
- 10.1 Establish connectivity to SAP BusinessObjects
- 10.2 Collect data from SAP BusinessObjects
- 10.3 Pre-filtering SAP BusinessObjects data
11. Sourcing Data from Beckon
- 11.1 Establish connectivity to Beckon
- 11.2 Collect data from Beckon
- 11.3 Create a External Report from Beckon
12. Sourcing Data from Cognos
- 12.1 Establish connectivity to IBM Cognos
- 12.2 Collect data from IBM Cognos
- 12.3 Pre-filtering Cognos data
13. Sourcing Data from CSV Plugin
- 13.1 Establish connectivity to a CSV file via a CSV Plugin
14. Sourcing Data from Dropbox Paper
- 14.1 Establish connectivity to Dropbox Paper
- 14.2 Collect images from Dropbox Paper
15. Sourcing Data using Elasticsearch
- 15.1 Establish connectivity to Elasticsearch
- 15.2 How to collect data using Elasticsearch
- 15.3 How to collect data using Elasticsearch (prior to Version 5.3)
16. Sourcing Data using File Data Plugin
- 16.1 Establish connectivity to File Data
- 16.2 How to collect data with File Data
17. Sourcing Data using File Metadata Plugin
- 17.1 Establish connectivity to File Metadata
- 17.2 How to collect data with File Metadata
18. Sourcing Data from Fogbugz
- 18.1 Establish connectivity to FogBugz
- 18.2 How to collect data from Fogbugz
19. Sourcing Data from Graphite
- 19.1 Establish Connectivity to Graphite
20. Sourcing Data from IBM CoreMetrics
- 20.1 Establish connectivity to IBM Coremetrics
- 20.2 How to collect data from IBM Coremetrics
21. Sourcing Data from Marketo
- 21.1 Establish Connectivity to Marketo
22. Sourcing Data from MicroStrategy
- 22.1 Establish Connectivity to MicroStrategy
- 22.2 How to collect data using Microstrategy plugin
- 22.3 Pre-filtering MicroStrategy data (Dataset example)
- 22.4 Create a Dimension with values automatically fetched from MicroStrategy
23. Sourcing Data from Mixpanel
- 23.1 Establish Connectivity to Mixpanel
- 23.2 How to Collect Data from Mixpanel
24. Sourcing Data from MongoDB
- 24.1 Establish Connectivity to MongoDB
- 24.2 How to Collect Data using MongoDB Plug-in
25. Sourcing Data from OBIEE (Oracle Business Intelligence)
- 25.1 Establish Connectivity to Oracle Business Intelligence
- 25.2 Collect data from Oracle Business Intelligence
- 25.3 Pre-filtering Oracle Business Intelligence data
26. Sourcing Data using OLAP
- 26.1 Establish Connectivity to OLAP
- 26.2 How to Collect Data from OLAP
27. Sourcing Data from QlikView
- 27.1 QlikView Overview
- 27.2 Download Instructions for PoC
- 27.3 Prerequisites to connecting to QlikView server
- 27.4 Establish Connectivity to QlikView
- 27.5 How to Collect Data using QlikView Plug-in
- 27.6 Create External Report from QlikView
- 27.7 How to create an External Report from QlikView
- 27.8 Create a Dimension with values fetched from QlikView
- 27.9 Identifying QlikView filters
28. Sourcing Data from Re:dash
- 28.1 Establish Connectivity to Re:dash
- 28.2 How to collect data from Re:dash
29. Sourcing Data using RSS
- 29.1 Establish connectivity to RSS
- 29.2 How to collect data using RSS plugin
30. Sourcing data using Salesforce Reports
- 30.1 Establish connectivity to Salesforce Reports
- 30.2 How to collect data using Salesforce Reports
31. Sourcing data using Salesforce SOQL
- 31.1 Salesforce Reports vs Salesforce SOQL: key distinctions
- 31.2 Setting up Salesforce OAuth
- 31.3 Establish connectivity to Salesforce SOQL
- 31.4 How to collect data using Salesforce SOQL
32. Sourcing Data from Sisense
- 32.1 Establish Connectivity to Sisense
- 32.2 How to collect data from Sisense
- 32.3 How to create an External Report from Sisense
- 32.4 Create a Dimension with values automatically fetched from Sisense
- 32.5 Pre-filtering Sisense data (Version 5.1)
33. Sourcing Data from Splunk
- 33.1 Establish Connectivity to Splunk
- 33.2 How to Collect Data from Splunk
34. Sourcing Data from Microsoft SSRS
- 34.1 Establish Connectivity to Microsoft SSRS
- 34.2 How to Collect Data from SSRS
- 34.3 How SSRS report data is obtained
36. Sourcing data from Tibco Spotfire
- 36.1 Prerequisites for connecting to Tibco Spotfire
- 36.2 Establish Connectivity to Tibco Spotfire
- 36.3 Create an External Report from Tibco Spotfire
37. Sourcing Data from ThoughtSpot
- 37.1 Establish Connectivity to ThoughtSpot
- 37.2 Create a Dataset from ThoughtSpot
38. Sourcing data from Treasure Data
- 38.1 Establish connectivity to Treasure Data
- 38.2 How to collect data from Treasure Data
39. Sourcing Data from Uptimerobot
- 39.1 Establish Connectivity to Uptimerobot
- 39.2 How to Collect Data using Uptimerobot
40. Sourcing Data using a Web Service
- 40.1 Connecting to a Web Service
41. Sourcing Data from Zendesk
- 41.1 Obtaining Credentials for Zendesk plugin
- 41.2 Establish Connectivity to Zendesk
- 41.3 How to Collect Data from Zendesk (Dataset)