View in admin portal

Skip to main content

Open support ticket Help & Documentation

Help & Documentation

Search term

Help & DocumentationGetting DataConnecting to Data SourcesHow to Link to External BI Tools

Connecting to Data Sources

3. How to Link to External BI Tools

View all chapters

Topics

1. General Information about Data Sources 17
- 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 Content Auto Synchronization
- 1.15 Create External Report Template
- 1.16 Supported Time and Date Formats
- 1.17 On-Demand Element Creation
2. Storing Data 3
- 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
- 2.3 Setting up Windows Server Shared Folder
3. How to Link to External BI Tools 9
- 3.1 External Report Overview
- 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 7
- 4.1 Configure a Remote Data Collector/Processor
- 4.2 Configuring a Remote Data Processor on Windows Servers
- 4.3 Troubleshooting a Remote Data Collector/Processor
- 4.4 Installing Insightd on Windows Servers
- 4.5 Upgrading Insightd on Windows Servers
- 4.6 Installing Insightd on Linux Servers
- 4.7 Upgrading Insightd on Linux Servers
5. JDBC Connections 3
- 5.1 Establish 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 2
- 6.1 Establish connectivity to Adobe Analytics
- 6.2 Collect data from Adobe Analytics
7. Sourcing Data from Adaptive Planning 2
- 7.1 Establish connectivity to Adaptive Planning
- 7.2 Collect data from Adaptive Planning
8. Sourcing Data using Amazon S3 Plugin 3
- 8.1 Establish Connectivity to Amazon S3
- 8.2 Create a Dataset from Amazon S3
- 8.3 Create an External Report from Amazon S3
9. Sourcing Data from Atlassian Confluence 2
- 9.1 Establish connectivity to Atlassian Confluence
- 9.2 Collect data from Atlassian Confluence
10. Sourcing Data using Atlassian Jira 3
- 10.1 Establish Connectivity to Atlassian Jira
- 10.2 Collect data from Atlassian Jira
- 10.3 Fetch Commands for JIRA
11. Sourcing Data from Beckon 3
- 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 4
- 12.1 Establish connectivity to IBM Cognos
- 12.2 Collect data from IBM Cognos
- 12.3 Pre-filtering Cognos data
- 12.4 Content Auto Synchronization
13. Sourcing Data from CSV Plugin 1
- 13.1 Establish connectivity to a CSV file via a CSV Plugin
14. Sourcing Data from Denodo 2
- 14.1 Establish Connectivity to Denodo
- 14.2 Collect Data from Denodo
15. Sourcing Data from Dropbox Paper 2
- 15.1 Establish connectivity to Dropbox Paper
- 15.2 Collect images from Dropbox Paper
16. Sourcing Data using Elasticsearch 3
- 16.1 Establish connectivity to Elasticsearch
- 16.2 How to collect data using Elasticsearch
- 16.3 How to collect data using Elasticsearch (prior to Version 5.3)
17. Sourcing Data using File Data Plugin 2
- 17.1 Establish connectivity to File Data
- 17.2 How to collect data with File Data
18. Sourcing Data using File Metadata Plugin 2
- 18.1 Establish connectivity to File Metadata
- 18.2 How to collect data with File Metadata
19. Sourcing Data from Fogbugz 2
- 19.1 Establish connectivity to FogBugz
- 19.2 How to collect data from Fogbugz
20. Sourcing Data from Graphite 1
- 20.1 Establish Connectivity to Graphite
21. Sourcing Data from IBM CoreMetrics 2
- 21.1 Establish connectivity to IBM Coremetrics
- 21.2 How to collect data from IBM Coremetrics
22. Sourcing Data from Marketo 1
- 22.1 Establish Connectivity to Marketo
23. Sourcing Data from MicroStrategy 5
- 23.1 Establish Connectivity to MicroStrategy
- 23.2 How to collect data using Microstrategy plugin
- 23.3 Pre-filtering MicroStrategy data (Dataset example)
- 23.4 Content Auto Synchronization
- 23.5 Create a Dimension with values automatically fetched from MicroStrategy
24. Sourcing Data from Mixpanel 2
- 24.1 Establish Connectivity to Mixpanel
- 24.2 How to Collect Data from Mixpanel
25. Sourcing Data from MongoDB 2
- 25.1 Establish Connectivity to MongoDB
- 25.2 How to Collect Data using MongoDB Plug-in
26. Sourcing Data from OBIEE (Oracle Business Intelligence) 3
- 26.1 Establish Connectivity to Oracle Business Intelligence
- 26.2 Collect data from Oracle Business Intelligence
- 26.3 Pre-filtering Oracle Business Intelligence data
27. Sourcing Data using OLAP 2
- 27.1 Establish Connectivity to OLAP
- 27.2 How to Collect Data from OLAP
28. Sourcing Data from QlikView 9
- 28.1 QlikView Overview
- 28.2 Download Instructions for PoC
- 28.3 Prerequisites to connecting to QlikView server
- 28.4 Establish Connectivity to QlikView
- 28.5 Find Field Name and Alias in QlikView
- 28.6 Create an External Report from QlikView
- 28.7 Pre-filtering QlikView Data
- 28.8 Content Auto Synchronization
- 28.9 Create a Dimension with values fetched from QlikView
29. Sourcing Data from Re:dash 2
- 29.1 Establish Connectivity to Re:dash
- 29.2 How to collect data from Re:dash
30. Sourcing Data using RSS 2
- 30.1 Establish connectivity to RSS
- 30.2 How to collect data using RSS plugin
31. Sourcing data using Salesforce Reports 2
- 31.1 Establish connectivity to Salesforce Reports
- 31.2 How to collect data using Salesforce Reports
32. Sourcing data using Salesforce SOQL 5
- 32.1 Salesforce Reports vs Salesforce SOQL: key distinctions
- 32.2 Setting up Salesforce OAuth
- 32.3 Establish connectivity to Salesforce SOQL
- 32.4 How to collect data using Salesforce SOQL
- 32.5 Why does my Salesforce OAuth token expire?
33. Sourcing Data from SAP BusinessObjects 4
- 33.1 Establish Connectivity to SAP BusinessObjects
- 33.2 Collect data from SAP BusinessObjects
- 33.3 Pre-filtering SAP BusinessObjects data
- 33.4 Content Auto Synchronization
34. Sourcing Data from Sisense 5
- 34.1 Establish Connectivity to Sisense
- 34.2 How to collect data from Sisense
- 34.3 How to create an External Report from Sisense
- 34.4 Create a Dimension with values automatically fetched from Sisense
- 34.5 Pre-filtering Sisense data (Version 5.1)
35. Sourcing Data from Splunk 3
- 35.1 Establish Connectivity to Splunk
- 35.2 Create a Dataset from Splunk
- 35.3 Create an External Report from Splunk
36. Sourcing Data from Microsoft SSRS 3
- 36.1 Establish Connectivity to Microsoft SSRS
- 36.2 How to Collect Data from SSRS
- 36.3 How SSRS report data is obtained
37. Sourcing Data from Tableau - see Working with Tableau 0
38. Sourcing data from Tibco Spotfire 4
- 38.1 Prerequisites for connecting to Tibco Spotfire
- 38.2 Establish Connectivity to TIBCO Spotfire Analytics
- 38.3 Create External Report from TIBCO Spotfire Analytics
- 38.4 Create External Report Template
39. Sourcing Data from ThoughtSpot 3
- 39.1 Establish Connectivity to ThoughtSpot
- 39.2 Create a Dataset from ThoughtSpot
- 39.3 Create an External Report from ThoughtSpot
40. Sourcing data from Treasure Data 2
- 40.1 Establish connectivity to Treasure Data
- 40.2 How to collect data from Treasure Data
41. Sourcing Data from Uptimerobot 2
- 41.1 Establish Connectivity to Uptimerobot
- 41.2 How to Collect Data using Uptimerobot
42. Sourcing Data using a Web Service 1
- 42.1 Connecting to a Web Service
43. Sourcing Data from Zendesk 3
- 43.1 Obtaining Credentials for Zendesk plugin
- 43.2 Establish Connectivity to Zendesk
- 43.3 How to Collect Data from Zendesk (Dataset)
44. Sourcing Data from S/FTP Server 3
- 44.1 Establish Connectivity to S/FTP Server
- 44.2 Create a Dataset using S/FTP
- 44.3 Create an External Report using S/FTP
45. Sourcing Data from Local Filesystem 3
- 45.1 Establish Connectivity to Local Filesystem
- 45.2 Create a Dataset from Local Filesystem
- 45.3 Create an External Report from Local Filesystem

Generate Manual PDF

Other Resources

Inline referenced article

×