Register Default Data Sources

  • 2 minutes to read

The Dashboard Configurator requires you to configure data source storage to supply users with a set of default data sources.

WebDesigner_DefaultDataSources

A user can add data sources to a dashboard after you add them to the data source storage. The Web Dashboard supports the following data source types:

ASP.NET Core ASP.NET MVC
SQL SQL
OLAP OLAP
Excel Excel
Object Object
Entity Framework Entity Framework
Data Extract Data Extract
JSON JSON
XPO XPO
MongoDB MongoDB
Data Federation Data Federation

Call the DashboardConfigurator.SetDataSourceStorage method to register the created data source in data source storage. You can use a predefined implementation of the in-memory storage (DataSourceInMemoryStorage) or you can implement the IDataSourceStorage interface to create a custom data source storage.

Protect User Data

The Web Dashboard saves user credentials used by data sources to the dashboard XML definition.

Use the DashboardConfigurator.PassCredentials property to specify whether to pass this information to the client side (web browser). Set this property to false and provide connection parameters in one of the following ways to avoid any security issues:

The following examples configure the Dashboard control so that it loads data based on the current user. You can identify a user in the current session and handle the events to select the underlying data source.

View Example: ASP.NET Core Dashboard View Example: ASP.NET MVC