Register Default Data Sources
This document describes how to provide a Web Dashboard with a set of default data sources, which are available for end-users.
To do this, create the required data sources at runtime using the following data source types:
- SQL data source
- OLAP data source (XMLA only)
- Excel data source
- Object data source
- Entity Framework data source
- Extract data source
After you created the required data sources, register them in a data source storage using the DashboardConfigurator.SetDataSourceStorage method. Note that you can use a predefined implementation of the in-memory storage (DataSourceInMemoryStorage) or you can implement the IDataSourceStorage interface to provide custom data source storage.
Important
The Web Dashboard saves user credentials used by data sources to the dashboard XML definition. Use the boolean 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:
- Implement the IDataSourceWizardConnectionStringsProvider interface to create a data connections provider. Pass the created provider as the DashboardConfigurator.SetConnectionStringsProvider method’s parameter.
- Handle the DashboardConfigurator.ConfigureDataConnection event to provide the required connection parameters at runtime.