Table of Contents
Local Data Sources and Live Data Sources Send comments on this topic.

There are two kinds of Data Sources that can be created: Local Data Sources and Live Data Sources.

Local Data Sources are Data Sources whose data needs to be imported into a local in-memory database before it can be used.  Live Data Sources are Data Sources whose data can be queried directly.

 

Here is a list of supported local and live Data Sources:

 

Local Data Sources Microsoft Excel
Microsoft Access
Comma Separate Value files (CSV)
Amazon Simple Storage Service (S3) Logs
Google Spreadsheets
Live Data Sources  Microsoft SQL Server
Oracle
MySQL
Microsoft Analysis Services (OLAP)

 

When a dashboard is created over a local Data Source, the data is imported from the source into an in-memory database.  Therefore, the dashboard file will also contain the imported raw data.

This is not true in the case of live Data Sources.  When a dashboard is created over a live Data Source, the source is queried directly for results and therefore the raw data is not included with the dashboard file.