Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Collapse]Dashboard
 [Expand]Getting Started
 [Expand]Basic Concepts and Terminology
 [Collapse]Main Features
  [Collapse]Connecting to a Data Source
    Supported Data Sources
    Data Processing Modes
    How to Specify a Custom Connection String for the SQL Data Source
   Data Preparation
   Binding to Data
  [Expand]Data Shaping
  [Expand]Interactivity
  [Expand]Appearance Customization
  [Expand]Advanced Analytics
   Dashboard Layout
   Printing and Exporting
   WinForms and Web Specifics
 [Expand]Building the Designer and Viewer Applications
 [Expand]Creating Dashboards
 [Expand]Examples
 [Expand]Design-Time Features
  Video Tutorials
  End-User Documentation
  Localization
 [Expand]Redistribution and Deployment
 [Expand]Member Tables
 [Expand]API Reference
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Connecting to a Data Source

The DevExpress Dashboard allows you to connect to any supported data source by using either special Data Source wizards or the API provided by the DevExpress.DataAccess library.


The table below lists ways of establishing a connection to data depending on the selected platform/data source type.

Data Source Type

API

WinForms Designer

Web Dashboard

SQL Data Source DashboardSqlDataSource
  • By default, end-users can establish a connection to various types of SQL databases by specifying required connection parameters in the Data Source wizard. As an alternative, add the required connection strings in the application's configuration file to supply end-users with a set of default data connections. To learn more, see Connecting to SQL Databases.
  • Use the DashboardSqlDataSource class to create a predefined SQL data source available to end-users.
OLAP Data Source DashboardOlapDataSource
  • By default, end-users can establish a connection to OLAP cubes by specifying connection parameters in the Data Source wizard. As an alternative, add required connection strings in the application's configuration file to supply end-users with a set of default data connections. To learn more, see OLAP Data Source.
  • Use the DashboardOlapDataSource class to create a predefined OLAP data source available to end-users.
Excel Data Source DashboardExcelDataSource
  • End-users can connect to an Excel workbook or CSV file using the Data Source wizard. To learn more, see Excel Data Source.
  • Use the DashboardExcelDataSource class to create a predefined Excel data source available to end-users.
Entity Framework Data Source DashboardEFDataSource
  • End-users can connect to an Entity Framework data source using the Data Source wizard. To supply the end-users with this capability, add an Entity Framework model to your project. To learn more, see Entity Framework Data Source.
  • Use the DashboardEFDataSource class to create a predefined Entity Framework data source available to end-users.
Object Data Source DashboardObjectDataSource
  • End-users can connect to an Object data source using the Data Source wizard. To supply the end-users with this capability, define an object data source in a separate class within a project. To learn more, see Object Data Source.
  • Use the DashboardObjectDataSource class to create a predefined Object data source available to end-users.
Extract Data Source DashboardExtractDataSource
  • End-users can create a new data extract or establish a connection to an existing data extract using the Data Source wizard. To learn more, see Extract Data Source.
  • Use the DashboardExtractDataSource class to create a predefined Extract data source available to end-users.

Expanded See Also

How would you rate this topic?​​​​​​​