This topic provides a conceptual overview of the data source components available in Ignite UI for jQuery®.
The following table lists the concepts and topics required as a prerequisite to understanding this topic.
Concept
Topics
The data source components available in the Ignite UI for jQuery suite are client-side components intended to serve as a mediator between the actual data and the visual components that visualize the data. Multiple kinds of input data are supported. Ignite UI for jQuery data source components fall into the following categories:
igDataSource™) used for feeding data-bound controls that visualize standard, ”flat” and hierarchical data (i.e. data that is not multidimensional) in the form of a regular table (grid)igOlapFlatDataSource™, igOlapXmlaDataSource™) used for visualizing data as an OLAP data slice in a pivot grid. The original supplied data set at that can be either in authentic OLAP format (and fed to the igOlapXmlaDataSource component) or in standard “flat” data (and fed to the igOlapFlatDataSource component). (In the latter case, “flat” data can be visualized in a pivot grid as OLAP data.)The following table provides summaries of the purpose and capabilities of the Ignite UI for jQuery data source components. Additional details about each component are available after the table, including links to dedicated topics about the component.
| Component | Description |
|---|---|
| igDataSource | The standard Ignite UI for jQuery component for binding to various kinds and sources of data. The igDataSource transforms source data format into a format that can be fed to data-bound controls like the igGrid™. |
| igOlapXmlaDataSource | A component for feeding multi-dimensional (OLAP) data visualization controls with OLAP data from a Microsoft® SQL Server® Analysis Services (SSAS) server. |
| igOlapFlatDataSource | A component for feeding multi-dimensional (OLAP) data visualization controls with flat data to be presented in OLAP format. This allows for OLAP-like analysis on a flat data collection. |
The igDataSource component is the standard Ignite UI for jQuery component for binding to various kinds and sources of data. It serves as an intermediate layer between the data-bound controls like igGrid and the actual data,which can be either local (e.g. JSON, XML, JavaScript Array, etc.) or remote (REST services, WCF services, etc.). Paging, filtering, and sorting are supported, too.
igOlapXmlaDataSource is a component for feeding multi-dimensional (OLAP) data visualization controls with OLAP data from a Microsoft SSAS server. igOlapXmlaDataSource handles the communication between a JavaScript client and an msmdpump.dll HTTP provider for SSAS data. Its interaction with the OLAP data visualization control is transparent.
igOlapFlatDataSource is a component for feeding multi-dimensional (OLAP) data visualization controls with flat data to be presented in OLAP format. This allows for OLAP-like analysis on a flat data collection. By making all necessary data aggregations and summarizations. Its interaction with the OLAP data visualization control is transparent.
The following topics provide additional information related to this topic.
igDataSource: This is a group of topics explaining the igDataSource component and its use.
igOlapXmlaDataSource: This is a group of topics explaining the igOlapXmlaDataSource component and its use.
igOlapFlatDataSource: This is a group of topics explaining the igOlapFlatDataSource component and its use.
igGrid: This is a group of topics explaining the igGrid control and its use.
igPivotGrid: This is a group of topics explaining the igPivotGrid™ control and its use.
igPivotDataSelector: This is a group of topics explaining the igPivotDataSelector™ control and its use.
The following samples provide additional information related to this topic.
XML Binding: This sample demonstrates how to bind our jQuery Data Source component to XML data.
Binding to Flat Data Source: This sample demonstrates how to bind the igPivotGrid to an igOlapFlatDataSource and uses an igPivotDataSelector for data selection.
Binding to Xmla Data Source: This sample demonstrates how to bind the igPivotGrid to an igOlapXmlaDataSource and uses an igPivotDataSelector for selection.
View on GitHub