Register Default Data Sources

  • 2 minutes to read

This document describes how to provide Dashboard Configurator with a set of default data sources available for end users.

WebDesigner_DefaultDataSources

User can create data sources at runtime after you register them in the Web Dashboard. The Web Dashboard supports the following data source types:

ASP.NET Core ASP.NET MVC
SQL data source SQL data source
OLAP data source (XMLA only) OLAP data source
Excel data source Excel data source
Object data source Object data source
Entity Framework data source Entity Framework data source
Extract data source Extract data source
JSON data source JSON data source
XPO data source XPO data source
Federated data source Federated data source

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 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: