Skip to main content

Open support ticket Help & Documentation

Help & Documentation

Search term

Help & DocumentationGetting DataConnecting to Data Sources

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 External Report Auto Synchronization Overview
- 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 via Plugin Config Page
- 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
- 2.1 Storing data in Microsoft SQL Server 2016+
- 2.2 Setting up Windows Server Shared Folder
3. How to Link to External BI Tools
- 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 Setting Element's Discoverability
- 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?
4. Configuring Remote Data Processors
- 4.1 Configuring a Remote Data Processor (v6+)
- 4.2 Configuring a Remote Data Processor on Windows Servers
- 4.3 Troubleshooting a Remote Data Collector/Processor
- 4.4 Upgrading Insightd on Windows Servers
- 4.5 Upgrading Insightd on Linux Servers
5. JDBC Connections
- 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 Workfront
- 6.1 Establish Connectivity to Adobe Workfront
- 6.2 Create Dataset from Adobe Workfront
- 6.3 Adobe Workfront Plugin Capabilities
7. Sourcing Data from Athena
- 7.1 Establish Connectivity to Amazon Athena
- 7.2 Create Dataset from Amazon Athena
8. Sourcing Data using Amazon S3 Plugin
- 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
- 9.1 Establish Connectivity to Apache Superset
- 9.2 Create External Report from Apache Superset
10. Sourcing Data from Apple App Store Connect
- 10.1 Establish Connectivity to Apple App Store Connect
- 10.2 Create Dataset from Apple App Store Connect
11. Sourcing Data from Atlassian Confluence
- 11.1 Establish Connectivity to Atlassian Confluence
- 11.2 Create a Dataset from Atlassian Confluence
12. Sourcing Data using Atlassian Jira
- 12.1 Establish Connectivity to Atlassian Jira
- 12.2 Create Dataset from Atlassian Jira
- 12.3 Atlassian Jira Plugin Capabilities
13. Sourcing Data from Azure Analysis Services
- 13.1 Establish Connectivity to Azure Analysis Services
- 13.2 Create Dataset from Azure Analysis Services
14. Sourcing Data from Azure Data Lake Storage
- 14.1 Establish Connectivity to Azure Data Lake Storage
- 14.2 Create Dataset from Azure Data Lake Storage
- 14.3 Azure Data Lake Storage Plugin Capabilities
15. Sourcing Data from Cognos
- 15.1 IBM Cognos Plugin Capabilities
- 15.2 Establish Connectivity to IBM Cognos
- 15.3 Create Dataset from IBM Cognos
- 15.4 External Report Auto Synchronization for IBM Cognos
- 15.5 Pre-Filtering Cognos Data (Dataset Example)
16. Sourcing Data from Databricks
- 16.1 Establish Connectivity to Databricks
- 16.2 Create Dataset from Databricks
17. Sourcing Data from Denodo
- 17.1 Establish Connectivity to Denodo
- 17.2 Create Dataset and Report from Denodo
18. Sourcing Data from Domo
- 18.1 Domo Plugin Capabilities
- 18.2 Prerequisites for Connecting to Domo
- 18.3 Establish Connectivity to Domo
- 18.4 Create Dataset from Domo
- 18.5 Filtering in Domo External Reports
- 18.6 Create External Report from Domo Card
- 18.7 Create External Report from Domo Dashboard
19. Sourcing Data from Dropbox Paper
- 19.1 Prerequisites for Connecting to Dropbox Paper
- 19.2 Establish Connectivity to Dropbox Paper
- 19.3 Create External Report from Dropbox Paper
20. Sourcing Data using File Metadata Plugin
- 20.1 Establish Connectivity to File Metadata
- 20.2 Create Dataset from File Metadata
- 20.3 File Metadata Plugin Capabilities
21. Sourcing Data from FlexIt Analytics
- 21.1 Establish Connectivity to FlexIt Analytics
- 21.2 Create Dataset from FlexIt Analytics
- 21.3 FlexIt Analytics Plugin Capabilities
22. Sourcing Data from Graphite
- 22.1 Establish Connectivity to Graphite
- 22.2 Create Dataset from Graphite
23. Sourcing Data from Local Filesystem
- 23.1 Establish Connectivity to Local Filesystem
- 23.2 Create a Dataset from Local Filesystem
- 23.3 Create External Content from Local Filesystem
- 23.4 Viewer for Excel, Word, PowerPoint from Local Filesystem
- 23.5 Configure File Groups for Other External Content
24. Sourcing Data from Looker
- 24.1 Looker Plugin Capabilities
- 24.2 Establish Connectivity to Looker
- 24.3 Create Dataset from Looker
- 24.4 Create External Report from Looker
- 24.5 Find Filter Names and Values in Looker
25. Sourcing Data from Microsoft Purview
- 25.1 Prerequisites for Connecting to Microsoft Purview
- 25.2 Establish Connectivity to Microsoft Purview
- 25.3 Create Dataset from Microsoft Purview
26. Sourcing Data from Microsoft SharePoint Online
- 26.1 Create Permissions for SharePoint Online
- 26.2 Prerequisites for Connecting to Microsoft SharePoint Online
- 26.3 Establish Connectivity to Microsoft SharePoint and OneDrive
- 26.4 Create Dataset from Microsoft SharePoint Lists
- 26.5 Create Dataset from Microsoft SharePoint Excel Workbooks
- 26.6 Create External Content with Microsoft SharePoint
- 26.7 Configure Custom Field Data Synchronization for Microsoft SharePoint
- 26.8 Configure Sending Attachments via Bursts for MS SharePoint
- 26.9 Configure File Groups for Other External Content
- 26.10 Configure External Content Auto Synchronization
27. Sourcing Data from Microsoft SharePoint Server
- 27.1 Establish Connectivity to Microsoft SharePoint Server 2019
- 27.2 Create Dataset from Microsoft SharePoint Lists
- 27.3 Create Dataset from Microsoft SharePoint Excel Workbooks
- 27.4 Create External Content with Microsoft SharePoint
- 27.5 Configure Kerberos Auth for SharePoint Server 2019 Plugin
28. Sourcing Data from Microsoft SSRS
- 28.1 Establish Connectivity to Microsoft SSRS
- 28.2 Create External Report form Microsoft SSRS
- 28.3 Create Metric from Microsoft SSRS
- 28.4 How SSRS Report Data Is Obtained
- 28.5 Pre-Filtering Microsoft SSRS Data (Dataset Example)
29. Sourcing Data from MicroStrategy
- 29.1 MicroStrategy Plugin Capabilities
- 29.2 Establish Connectivity to MicroStrategy
- 29.3 Create Dataset from MicroStrategy
- 29.4 External Report Auto Synchronization for MicroStrategy
- 29.5 Pre-Filtering MicroStrategy Data (Dataset example)
- 29.6 Create a Dimension with values automatically fetched from MicroStrategy
30. Sourcing Data from MicroStrategy Cube
- 30.1 Establish Connectivity to MicroStrategy Cube
- 30.2 Create Dataset from MicroStrategy Cube
- 30.3 MicroStrategy Cube Plugin Capabilities
31. Sourcing Data from MongoDB
- 31.1 Establish Connectivity to MongoDB
- 31.2 How to Collect Data using MongoDB Plug-in
- 31.3 MongoDB Plugin Capabilities
32. Sourcing Data from MI Portal Pages
- 32.1 Establish Connectivity to MI Portal Page
- 32.2 Create External Report from MI Portal Page
33. Sourcing Data from QlikView
- 33.1 QlikView Plugin Capabilities
- 33.2 QlikView Overview
- 33.3 Download Instructions for PoC
- 33.4 Prerequisites to Connecting to QlikView Server
- 33.5 Establish Connectivity to QlikView
- 33.6 Find Filter Names and Aliases in QlikView
- 33.7 Create External Report from QlikView
- 33.8 External Report Auto Synchronization for QlikView
- 33.9 Filtering in QlikView External Reports
- 33.10 Create a Dimension with values fetched from QlikView
34. Sourcing Data using RSS
- 34.1 Establish connectivity to RSS
- 34.2 How to collect data using RSS plugin
35. Sourcing Data from Salesforce Reports
- 35.1 Establish Connectivity to Salesforce Reports
- 35.2 Create Dataset from Salesforce Reports
- 35.3 Embedding MI Content in Visualforce Pages
- 35.4 Salesforce Integration Architecture
36. Sourcing Data from Salesforce SOQL
- 36.1 Salesforce Reports vs Salesforce SOQL: key distinctions
- 36.2 Setting Up Salesforce OAuth
- 36.3 Establish Connectivity to Salesforce SOQL
- 36.4 Create Metric from Salesforce SOQL
- 36.5 Why does my Salesforce OAuth token expire?
- 36.6 Embedding MI Content in Visualforce Pages
- 36.7 Salesforce Integration Architecture
37. Sourcing Data from SAP Analytics Cloud
- 37.1 Establish Connectivity to SAP Analytics Cloud
- 37.2 Filtering in SAP Analytics Cloud External Reports
- 37.3 Create External Report from SAP Analytics Cloud
- 37.4 External Report Auto Synchronization for SAP Analytics Cloud
38. Sourcing Data from SAP BusinessObjects
- 38.1 Establish Connectivity to SAP BusinessObjects
- 38.2 Create Dataset from SAP BusinessObjects
- 38.3 External Report Auto Synchronization for SAP Business Objects
- 38.4 Pre-Filtering SAP BusinessObjects Data (Dataset Example)
39. Sourcing Data from SAP HANA
- 39.1 Establish Connectivity to SAP HANA
- 39.2 Create Dataset from SAP HANA
40. Sourcing Data from Script Plugin
- 40.1 Configure Scripts for Dataset Creation
- 40.2 Establish Connectivity to Script Plugin
- 40.3 Create a Dataset from Script Plugin
41. Sourcing Data from ServiceNow
- 41.1 ServiceNow Plugin Capabilities
- 41.2 Establish Connectivity to ServiceNow
- 41.3 Create Dataset from ServiceNow
- 41.4 Create External Report from ServiceNow
42. Sourcing Data from S/FTP Server
- 42.1 Establish Connectivity to S/FTP Server
- 42.2 Create a Dataset using S/FTP
- 42.3 Create an External Report using S/FTP
43. Sourcing Data from R Shiny
- 43.1 Create External Content from R Shiny
44. Sourcing Data from Sigma
- 44.1 Sigma Plugin Capabilities
- 44.2 Prerequisites for Connecting to Sigma
- 44.3 Establish Connectivity to Sigma
- 44.4 Create Dataset from Sigma
- 44.5 Create External Report from Sigma
45. Sourcing Data from Sisense
- 45.1 Establish Connectivity to Sisense
- 45.2 How to collect data from Sisense
- 45.3 How to create an External Report from Sisense
- 45.4 Create a Dimension with values automatically fetched from Sisense
- 45.5 Pre-filtering Sisense data (Version 5.1)
46. Sourcing Data from Splunk
- 46.1 Establish Connectivity to Splunk
- 46.2 Create a Dataset from Splunk
- 46.3 Create an External Report from Splunk
47. Sourcing Data from Tibco Spotfire
- 47.1 TIBCO Spotfire Plugin Capabilities
- 47.2 Prerequisites for Connecting to TIBCO Spotfire (prior to v10.3 )
- 47.3 Prerequisites for Connecting to TIBCO Spotfire (v10.3+)
- 47.4 Configure Kerberos Auth on TIBCO Spotfire Server
- 47.5 Establish Connectivity to TIBCO Spotfire Analytics
- 47.6 Create Dataset from TIBCO Spotfire Analytics
- 47.7 Create External Report from TIBCO Spotfire Analytics
- 47.8 External Report Auto Synchronization for TIBCO Spotfire
- 47.9 Create External Report Template
48. Sourcing Data from Tibco WebFOCUS
- 48.1 Establish Connectivity to TIBCO WebFOCUS
- 48.2 Create External Report from TIBCO WebFOCUS
- 48.3 Create External Report Template
- 48.4 Tibco WebFOCUS Plugin Capabilities
49. Sourcing Data from ThoughtSpot
- 49.1 Establish Connectivity to ThoughtSpot
- 49.2 Create a Dataset from ThoughtSpot
- 49.3 Create an External Report from ThoughtSpot
- 49.4 ThoughtSpot Integration Options
50. Sourcing data from Treasure Data
- 50.1 Establish connectivity to Treasure Data
- 50.2 How to collect data from Treasure Data
51. Sourcing Data from Trino
- 51.1 Establish Connectivity to Trino
- 51.2 Create Dataset from Trino
52. Sourcing Data from UptimeRobot
- 52.1 Establish Connectivity to UptimeRobot
- 52.2 Create Dataset Using UptimeRobot
- 52.3 Uptime Robot Plugin Capabilities
53. Sourcing Data from Zendesk
- 53.1 Obtaining Credentials for Zendesk Plugin (prior to v6.2.3)
- 53.2 Establish Connectivity to Zendesk
- 53.3 Create Dataset from Zendesk
54. Sourcing Data from Zendesk Explore
- 54.1 Establish Connectivity to Zendesk Explore
- 54.2 Create External Report from Zendesk Explore

Topics

1. General Information about Data Sources 23
2. Storing Data 2
- 2.1 Storing data in Microsoft SQL Server 2016+
- 2.2 Setting up Windows Server Shared Folder
3. How to Link to External BI Tools 8
4. Configuring Remote Data Processors 5
5. JDBC Connections 4
6. Sourcing Data from Adobe Workfront 3
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
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 Create a Dataset from Atlassian Confluence
12. Sourcing Data using Atlassian Jira 3
13. Sourcing Data from Azure Analysis Services 2
- 13.1 Establish Connectivity to Azure Analysis Services
- 13.2 Create Dataset from Azure Analysis Services
14. Sourcing Data from Azure Data Lake Storage 3
15. Sourcing Data from Cognos 5
16. Sourcing Data from Databricks 2
- 16.1 Establish Connectivity to Databricks
- 16.2 Create Dataset from Databricks
17. Sourcing Data from Denodo 2
- 17.1 Establish Connectivity to Denodo
- 17.2 Create Dataset and Report from Denodo
18. Sourcing Data from Domo 7
19. Sourcing Data from Dropbox Paper 3
20. Sourcing Data using File Metadata Plugin 3
21. Sourcing Data from FlexIt Analytics 3
22. Sourcing Data from Graphite 2
- 22.1 Establish Connectivity to Graphite
- 22.2 Create Dataset from Graphite
23. Sourcing Data from Local Filesystem 5
24. Sourcing Data from Looker 5
25. Sourcing Data from Microsoft Purview 3
26. Sourcing Data from Microsoft SharePoint Online 10
27. Sourcing Data from Microsoft SharePoint Server 5
28. Sourcing Data from Microsoft SSRS 5
29. Sourcing Data from MicroStrategy 6
30. Sourcing Data from MicroStrategy Cube 3
31. Sourcing Data from MongoDB 3
32. Sourcing Data from MI Portal Pages 2
- 32.1 Establish Connectivity to MI Portal Page
- 32.2 Create External Report from MI Portal Page
33. Sourcing Data from QlikView 10
34. Sourcing Data using RSS 2
- 34.1 Establish connectivity to RSS
- 34.2 How to collect data using RSS plugin
35. Sourcing Data from Salesforce Reports 4
36. Sourcing Data from Salesforce SOQL 7
37. Sourcing Data from SAP Analytics Cloud 4
38. Sourcing Data from SAP BusinessObjects 4
39. Sourcing Data from SAP HANA 2
- 39.1 Establish Connectivity to SAP HANA
- 39.2 Create Dataset from SAP HANA
40. Sourcing Data from Script Plugin 3
41. Sourcing Data from ServiceNow 4
42. Sourcing Data from S/FTP Server 3
43. Sourcing Data from R Shiny 1
- 43.1 Create External Content from R Shiny
44. Sourcing Data from Sigma 5
45. Sourcing Data from Sisense 5
46. Sourcing Data from Splunk 3
47. Sourcing Data from Tibco Spotfire 9
48. Sourcing Data from Tibco WebFOCUS 4
49. Sourcing Data from ThoughtSpot 4
50. Sourcing data from Treasure Data 2
- 50.1 Establish connectivity to Treasure Data
- 50.2 How to collect data from Treasure Data
51. Sourcing Data from Trino 2
- 51.1 Establish Connectivity to Trino
- 51.2 Create Dataset from Trino
52. Sourcing Data from UptimeRobot 3
53. Sourcing Data from Zendesk 3
54. Sourcing Data from Zendesk Explore 2
- 54.1 Establish Connectivity to Zendesk Explore
- 54.2 Create External Report from Zendesk Explore

Other Resources

Getting Started
Metric Insights Overview
Jump Start Guide for Administrators
Jump Start Guide for Regular Users
Use Case Workflows

Getting Data
Connecting to Data Sources
Automating the Collection of Data
API Access
Working with Tableau
Working with Qlik Sense
Working with Microsoft Power BI
Working with Google Services

Creating Content
Datasets
Creating Basic Metrics and Reports
Creating Dimensions
Creating Dimensioned Metrics and Reports
Governance
Portal Pages

Alerting
Alerting

Collaboration and Sharing
Adding Context to Metrics
Pushing Information to Users
Chatbot Integrations

System Administration
Announcements
Controlling Access to Metric Insights
Controlling Access within Metric Insights
Deployment & Configuration
FAQs
How-to Videos
Identity Profiles
Maintenance
Managing the Metric Insights Environment
Release Notes