Data Source Wizard
- 2 minutes to read
The Data Source Wizard allows you to configure a data source for a Dashboard.
To invoke the Data Source Wizard, click the New Data Source button in the Data Source ribbon tab.
The first page of the invoked Data Source Wizard dialog allows you to create or select an existing data connection.
If you chose a new connection, the next page allows you to select the data connection type.
The search panel allows you to filter the connection type list:
You can select a provider and click the “star” icon to pin frequently used database providers as favorites. Favorite providers appear at the top of the list for quick access:
Users can configure the following data source types in the wizard:
| Type | Description |
|---|---|
| SQL Databases | Different types of data providers to SQL data sources |
| OLAP | OLAP cube in the Microsoft Analysis Services database |
| Entity Framework | Microsoft Entity Framework |
| Object Binding | A data object that implements the IList, IList<T> or IEnumerable<T> interface |
| Microsoft Excel workbook / CSV file | Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files |
| Data extract | A compressed snapshot of data from a regular data source |
| Data Federation | A federated data source type that retrieves data from multiple data sources |
| eXpress Persistent Objects (XPO) | DevExpress Object-Relational Mapping Library |
| JSON data | Connects to JSON-formatted data |
| MongoDB | Connects to a MongoDB instance |
| Custom Connection String | Allows you to pass additional connection parameters and establish a connection to any SQL database. |
The XPO Data Source is hidden from the list of data sources available in the Data Source Wizard. Use the DashboardDesignerDataSourceWizardSettings.AvailableDataSourceTypes property to specify the data connections displayed on the page.
Click Next to proceed to the next wizard page that depends on the selected data connection type.
You can customize this wizard to skip certain pages or change the list of available data providers. For more information, refer to the following topics: