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 23
- 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
- 1.18 Configure Plugin Parameter Values
- 1.19 Building Reliability into Data Collection
- 1.20 Advanced Data Source Configuration
- 1.21 Understanding Setup Image
- 1.22 Long Images Display
- 1.23 Using the Compact mode for External Reports
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
- 3.3 How to omit Filters from External Reports
- 3.4 Make External Reports Discoverable - Obsolete
- 3.5 Set Discoverability & Custom Access Request Messages for External Reports
- 3.6 Create a New External Report Type
- 3.7 External Content Overview
- 3.8 Why do I see an empty page when I set my External Report to display in Viewer?
- 3.9 Handle "All Values" as Filter Value in Tableau
4. Configuring Remote Data Processors 4
- 4.1 Configuring a Remote Data Processor on Windows Servers
- 4.2 Upgrading Insightd on Windows Servers
- 4.3 Upgrading Insightd on Linux Servers
- 4.4 Configuring a Remote Data Processor (v6+)
5. JDBC Connections 4
- 5.1 Establish a JDBC Connection
- 5.2 Add a New JDBC Driver (prior to v6.1)
- 5.3 Validation errors: "Value '0000-00-00' can not be represented as java.sql.Date"
- 5.4 Add a New JDBC Driver (v6.1+)
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 Athena 2
- 7.1 Establish Connectivity to Amazon Athena
- 7.2 Create Dataset from Amazon Athena
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 Apache Superset 2
- 9.1 Establish Connectivity to Apache Superset
- 9.2 Create External Report from Apache Superset
10. Sourcing Data from Apple App Store Connect 2
- 10.1 Establish Connectivity to Apple App Store Connect
- 10.2 Create Dataset from Apple App Store Connect
11. Sourcing Data from Atlassian Confluence 2
- 11.1 Establish connectivity to Atlassian Confluence
- 11.2 Collect data from Atlassian Confluence
12. Sourcing Data using Atlassian Jira 3
- 12.1 Establish Connectivity to Atlassian Jira
- 12.2 Collect data from Atlassian Jira
- 12.3 Fetch Commands for JIRA
13. Sourcing Data from Cognos 4
- 13.1 Establish Connectivity to IBM Cognos
- 13.2 Create Dataset from IBM Cognos
- 13.3 Pre-Filtering Cognos Data (Dataset Example)
- 13.4 Content Auto Synchronization
14. Sourcing Data from CSV Plugin 1
- 14.1 Establish connectivity to a CSV file via a CSV Plugin
15. Sourcing Data from Denodo 2
- 15.1 Establish Connectivity to Denodo
- 15.2 Create Dataset and Report from Denodo
16. Sourcing Data from Domo 6
- 16.1 Prerequisites for Connecting to Domo
- 16.2 Establish Connectivity to Domo
- 16.3 Create Dataset from Domo
- 16.4 Filtering in Domo External Reports
- 16.5 Create External Report from Domo Card
- 16.6 Create External Report from Domo Dashboard
17. Sourcing Data from Dropbox Paper 2
- 17.1 Establish connectivity to Dropbox Paper
- 17.2 Collect images from Dropbox Paper
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 2
- 20.1 Establish Connectivity to Graphite
- 20.2 Create Dataset from Graphite
21. Sourcing Data from Local Filesystem 6
- 21.1 Establish Connectivity to Local Filesystem
- 21.2 Create a Dataset from Local Filesystem
- 21.3 Create External Content from Local Filesystem
- 21.4 Viewer for Excel, Word, PowerPoint from Local Filesystem
- 21.5 Configure File Groups for Other External Content
- 21.6 External Content Auto Synchronization
22. Sourcing Data from Looker 4
- 22.1 Establish Connectivity to Looker
- 22.2 Create Dataset from Looker
- 22.3 Create External Report from Looker
- 22.4 Find Filter Names and Values in Looker
23. Sourcing Data from MicroStrategy 5
- 23.1 Establish Connectivity to MicroStrategy
- 23.2 Create Dataset from MicroStrategy
- 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 MongoDB 2
- 24.1 Establish Connectivity to MongoDB
- 24.2 How to Collect Data using MongoDB Plug-in
25. Sourcing Data from OBIEE (Oracle Business Intelligence) 3
- 25.1 Establish Connectivity to Oracle Business Intelligence
- 25.2 Create Dataset from Oracle Business Intelligence
- 25.3 Filtering in Oracle Business Intelligence External Reports
26. Sourcing Data using OLAP 2
- 26.1 Establish Connectivity to OLAP
- 26.2 How to Collect Data from OLAP
27. Sourcing Data from MI Portal Pages 2
- 27.1 Establish Connectivity to MI Portal Page
- 27.2 Create External Report from MI Portal Page
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 Filter Names and Aliases in QlikView
- 28.6 Create External Report from QlikView
- 28.7 Filtering in QlikView External Reports
- 28.8 Content Auto Synchronization
- 28.9 Create a Dimension with values fetched from QlikView
29. Sourcing Data from Salesforce Reports 4
- 29.1 Establish Connectivity to Salesforce Reports
- 29.2 How to collect data using Salesforce Reports
- 29.3 Embedding MI Content in Visualforce Pages
- 29.4 Salesforce Integration Architecture
30. Sourcing Data from Salesforce SOQL 7
- 30.1 Salesforce Reports vs Salesforce SOQL: key distinctions
- 30.2 Setting Up Salesforce OAuth
- 30.3 Establish Connectivity to Salesforce SOQL
- 30.4 Create Metric from Salesforce SOQL
- 30.5 Why does my Salesforce OAuth token expire?
- 30.6 Embedding MI Content in Visualforce Pages
- 30.7 Salesforce Integration Architecture
31. Sourcing Data from SAP Analytics Cloud 3
- 31.1 Establish Connectivity to SAP Analytics Cloud
- 31.2 Filtering in SAP Analytics Cloud External Reports
- 31.3 Create External Report from SAP Analytics Cloud
32. Sourcing Data from SAP BusinessObjects 4
- 32.1 Establish Connectivity to SAP BusinessObjects
- 32.2 Create Dataset from SAP BusinessObjects
- 32.3 Pre-Filtering SAP BusinessObjects Data (Dataset Example)
- 32.4 Content Auto Synchronization
33. Sourcing Data from Script Plugin 3
- 33.1 Configure Scripts for Dataset Creation
- 33.2 Establish Connectivity to Script Plugin
- 33.3 Create a Dataset from Script Plugin
34. Sourcing Data from ServiceNow 3
- 34.1 Establish Connectivity to ServiceNow
- 34.2 Create Dataset from ServiceNow
- 34.3 Create External Report from ServiceNow
35. Sourcing Data from S/FTP Server 3
- 35.1 Establish Connectivity to S/FTP Server
- 35.2 Create a Dataset using S/FTP
- 35.3 Create an External Report using S/FTP
36. Sourcing Data from Microsoft SharePoint 8
- 36.1 Prerequisites for Connecting to Microsoft SharePoint
- 36.2 Establish Connectivity to Microsoft SharePoint and OneDrive
- 36.3 Create Dataset from Microsoft SharePoint Lists
- 36.4 Create External Content with Microsoft SharePoint
- 36.5 Configure Custom Field Data Synchronization for Microsoft SharePoint
- 36.6 Configure Sending Attachments via Bursts for MS SharePoint
- 36.7 Configure File Groups for Other External Content
- 36.8 Configure External Content Auto Synchronization
37. Sourcing Data from R Shiny 1
- 37.1 Create External Content from R Shiny
38. Sourcing Data from Sisense 5
- 38.1 Establish Connectivity to Sisense
- 38.2 How to collect data from Sisense
- 38.3 How to create an External Report from Sisense
- 38.4 Create a Dimension with values automatically fetched from Sisense
- 38.5 Pre-filtering Sisense data (Version 5.1)
39. Sourcing Data from Splunk 3
- 39.1 Establish Connectivity to Splunk
- 39.2 Create a Dataset from Splunk
- 39.3 Create an External Report from Splunk
40. Sourcing Data from Microsoft SSRS 4
- 40.1 Establish Connectivity to Microsoft SSRS
- 40.2 Create Metric from Microsoft SSRS
- 40.3 How SSRS Report Data Is Obtained
- 40.4 Pre-Filtering Microsoft SSRS Data (Dataset Example)
41. Sourcing Data from Tibco Spotfire 7
- 41.1 Prerequisites for Connecting to TIBCO Spotfire (prior to v10.3 )
- 41.2 Prerequisites for Connecting to TIBCO Spotfire (v10.3+)
- 41.3 Configure Kerberos Auth on TIBCO Spotfire Server
- 41.4 Establish Connectivity to TIBCO Spotfire Analytics
- 41.5 Create Dataset from TIBCO Spotfire Analytics
- 41.6 Create External Report from TIBCO Spotfire Analytics
- 41.7 Create External Report Template
42. Sourcing Data from ThoughtSpot 4
- 42.1 Establish Connectivity to ThoughtSpot
- 42.2 Create a Dataset from ThoughtSpot
- 42.3 Create an External Report from ThoughtSpot
- 42.4 ThoughtSpot Integration Options
43. Sourcing data from Treasure Data 2
- 43.1 Establish connectivity to Treasure Data
- 43.2 How to collect data from Treasure Data
44. Sourcing Data from Uptimerobot 2
- 44.1 Establish Connectivity to Uptimerobot
- 44.2 How to Collect Data using Uptimerobot
45. Sourcing Data from Zendesk 3
- 45.1 Obtaining Credentials for Zendesk Plugin (prior to v6.2.3)
- 45.2 Establish Connectivity to Zendesk
- 45.3 Create Dataset from Zendesk
46. Sourcing Data from Zendesk Explore 2
- 46.1 Establish Connectivity to Zendesk Explore
- 46.2 Create External Report from Zendesk Explore

Generate Manual PDF

Other Resources

Inline referenced article

×