Data Sources

  • 2 min to read

To visualize data within dashboard items, you have to establish a connection to a data source.

A data source collects underlying data and passes it to a data engine that performs aggregation and summarization before data analysis.

The following data source types are supported.

  • SQL Data Source

    Allows you to establish a connection to various types of SQL databases.

    In code, use the DashboardSqlDataSource class.

  • OLAP cubes

    Connects to an OLAP cube in the Microsoft Analysis Services database.

    In code, use the DashboardOlapDataSource class.

  • Excel Data Source

    The Excel Data Source retrieves data from Microsoft Excel workbooks (XLS, XLSX or XLSM), or from CSV files.

    In code, use the DashboardExcelDataSource class.

  • Entity Framework Data Source

    You can connect to an Entity Framework data source defined within the current project or you can use an external assembly containing the required context.

    In code, use the DashboardEFDataSource class.

  • Object Data Source

    The Object Data Source retrieves data from a class in the current project.

    In code, use the DashboardObjectDataSource class.

  • JSON Data Source

    The JSON data source allows you to extract JSON data from a Web-service endpoint URI, text file, or a string in JSON format.

    In code, use the DashboardJsonDataSource class.

  • XPO Data Source

    The XPO data source allows you to obtain data that XPO (eXpress Persistent Object) retrieves from a data source.

    In code, use the DashboardXpoDataSource class.

  • Extract Data Source

    A data extract is a compressed snapshot of data from a regular data source. This data is contained in a local file and can be updated from the original data source at any time. You have an option to work with an external SQL data source or you can use the Extract Data Source as an intermediate layer.

    In code, use the DashboardExtractDataSource class.

  • Federation Data Source

    The Federation Data Source establishes relationships and combines SQL Data Source queries, Excel Data Sources, and Object Data Sources to provide uniform access.

    In code, use the DashboardFederationDataSource class.

Note

The DevExpress Dashboard uses database servers that can be configured to use case-sensitive table/column names. For this reason, a database scheme used in dashboards is case-sensitive to prevent any problem when the product is used with such servers.

See Also