Bind a Dashboard to a SQL Database

• Oct 23, 2019
• 2 minutes to read

This tutorial describes how to bind a dashboard to a SQL database.

Create a Data Model and Dashboard

1. Define data models that obtain the necessary data from your data providers. For this tutorial, prepare a data model connected to a SQL database.

2. Open an existing dashboard or create a new dashboard as described in the Create and Customize Dashboards topic.

Bind the Dashboard to Data

Do the following to obtain a dashboard’s dynamic data from a SQL data model:

1. Click the main menu button and select Data Sources.

2. In the Used Data Sources section, click Add to create a new data source.

3. On the first page of the invoked Dashboard Data Source Wizard , select a SQL data model and click Next to proceed.

4. Choose tables, views and/or stored procedures to add to the data source.

View the Result

The Data Sources screen now contains the added data source and displays the available data fields.

You can add a new query or calculated field to the data source if required.