416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Create a KPI or Dataset using two or more different data connectors

Hide navigation
RSS
Modified on Tue, 02 Sep 2014 04:11 PM Categorized as Data, Data Connectors, Data Preparation, Datasets, KPIs, Level-Advanced, Virtual Tables

Overview

In Dundas Dashboard, KPIs and Datasets are created from their respective virtual tables based on the data from their data connectors. Two or more virtual tables from the same data connector can be joined into one table and a KPI or a Dataset can be created. However, currently there is no in-built functionality that allows combining virtual tables from multiple data connectors.

This article provides options on how to create a virtual table from different data sources and hence create their respective KPIs or Datasets:

Options

Use one of the following options depending on the scenario.

Create SQL View

If the data within two databases is on the same instance of the SQL server, create a view that will join the data from two databases and then connect to the database in Dundas Dashboard that contains this view. This way data can be easily combined from the two databases to create the dashboards.

SSIS Package

If the data within two databases is running on two different instances of the SQL server, create a SQL Server Integration Services (SSIS) package that will import the data to the database on the same SQL server and schedule the package to run on regular basis.

Sync Database Caching

This option uses the sync caching capabilities of Dundas Dashboard to get the data from multiple data connectors into the Sync Database. To use this option, enable sync database caching on the data connectors that you wish to join information from.

  • In each of the data connectors, go to the caching tab and set up Sync Database Caching on an appropriate schedule and select Run Now. This will cause the Virtual Tables created from this data connector to copy their contents into the Dashboard Sync database at the specified schedule. Please refer to this article for details: Sync Caching

  • Add a new data connector that connects to the Dundas Dashboard Sync database. Since they will all be from the same connector all the tables can be added to the same Virtual Table and joined. Match the new sync tables with the original database tables by looking at the content.

Related Topics

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.