Adding Data Sources (Advanced)

Overview

 Advanced Users 

Each Analytic Model relies on a data source for the data it contains. Analytic Dashboards support both native (InFocus) and third party data sources- selected when building the design. This means that, in addition to your InFocus data, you can now visualize outside data across other areas of business- making InFocus a central hub for business analysis.

Third party data sources are considered either External (e.g. SQL Database, etc.) or Custom (e.g. SQL, OLAP, Microsoft Excel / CSV, etc.). External Data Sources can be configured globally in AD>Global Settings for use in the designer or the SQL Query applet. Custom Data Sources are only added when designing with the Analytic Dashboard Designer.

Once a data source is added to a dashboard view and saved, that data source and it's connection info is embedded in the dashboard definition. Until the data source is removed from the design, the connection will be preserved. If a dashboard view is exported for use in another InFocus database, the connection info is preserved in the new dashboard definition file (.dashboard) until otherwise removed from it.

Please Note: Most users will simply use the default InFocus data source.