Extract Data Source

  • 2 minutes to read

Extract Data Source is a compressed snapshot of data from a regular data source.

This data is saved to a local file and can be updated from the original data source at any time.

ExtractDiagram

The extract data file is optimized for data grouping. It reduces the initial dashboard load time.

The Extract Data Source improves performance when a complex query or a stored procedure takes a significant amount of time to get data from a database.

The Dashboard API provides the DashboardExtractDataSource class that can be used as any other Dashboard.DataSources. You should specify the original data source and the extract data file.

A special in-memory cache allows you to improve performance when accessing extract data. You can use the static class ExtractCacheOptions to specify a cache type for better results.

Use the AccessSettings class to explicitly allow the path to the data file. To accomplish this, configure rules in the DataResources property to restrict file system access to the specified folders. You can call the SetRules(IAccessRule[]) method when the application starts to specify rules before a dashboard control sets its rules. The SetRules(IAccessRule[]) method can be called only once at the application startup. Otherwise, the method will raise an exception. Alternatively, you can use the TrySetRules(IAccessRule[]) method, which does not raise an exception.

The following topics are available:

Examples:

WinForms

Web