Using Custom Data Sources

Top Previous Next

Overview

Custom Data Sources allow you to reach outside of InFocus and draw from third-party data sources for analysis.

Custom Data Sources differ from External Data Sources in that the connection to the data source is established from within the Analytic Dashboard Designer. Custom Data Sources feature a wizard walk through and a native Query Builder.

Supported data sources include:

•	Database - SQL Database connection

•	Olap - Connect to an OLAP cube in a MS Analysis Services database

•	Microsoft Excel workbook / CSV File - Excel or CSV connection

•	Data extract - Used to work with data extracts

Tutorial

To add a Custom Data Source, complete the following from the Analytic Dashboard Designer (UT>Analytic Dashboard Designer):

1.	Click the Data Source tab from the toolbar

2.	Click Add Custom Data Source. The Data Source Wizard will launch.

3.	Complete the steps in the wizard to establish connection to the data source.

4.	Click Finish

The data source will load with the related query outputs (e.g. SQL Query, Excel Sheet info, etc.).