Menu
Free Trials

Supported data sources

Pivot table component supports the most common data sources. We offer to process the data from the following data sources:


MS Analysis Services

ssas

Pivot table component offers the connection to Microsoft Analysis Services in two ways: XMLA and Flexmonster Accelerator. XMLA is an industry standard for data access in analytical systems. In case you need advanced features, like faster data transfer, try Flexmonster Accelerator for Microsoft Analysis Services cubes – a special server-side proxy that helps you to increase data loading speed from server to customer’s browser.

Follow our detailed guides on how to work with MS Analysis Services:


Mondrian

Pentaho Mondrian

You can connect to Mondrian via XMLA or via Flexmonster Accelerator. XMLA is an industry standard but it may take too much time and memory to load and process the data. In this case, we recommend Flexmonster Accelerator for Pentaho Mondrian cubes – a special server-side proxy that helps you to increase data loading speed from server to customer’s browser.

Read our step-by-step guides:


icCube

icCube

Combine icCube and Flexmonster pivot table to analyze data from OLAP cubes. Connection to icCube is provided by XMLA protocol.

For all the details read our guide: Connecting to icCube via XMLA.


SQL databases

Pivot table component supports the following databases:

  • Oracle
  • MySQL
  • Microsoft SQL Server
  • PostgreSQL
  • Other ADO.NET / ODBC / JDBC databases

Our component offers Flexmonster Data Compressor – a special server-side compression tool that helps you to increase data loading speed from server to customer’s browser. Flexmonster Compressor is available for .NET, Java and PHP. Follow detailed tutorials for each technology:


CSV data source

In Flexmonster component you can easily:

  1. build a report based on CSV data source;
  2. load CSV data from a file;
  3. refer CSV file as data source.

Using CSV data source you can indicate how data will be interpreted by Pivot table component. Check our guides:

Flexmonster Data Compressor can be used to accelerate loading speed for CSV files. Please find the examples for the following technologies:


JSON data source

Our component supports a certain format of JSON – array of objects, where each object is an unordered set of name/value pairs. The first object in JSON array can be used to define data types, captions, group fields under one dimension, hierarchies, etc.

JSON data can easily be loaded from the file. The customer can choose Connect > To local JSON in the toolbar and choose a file from the computer. Also, JSON file can be referred as data source inside of the report.

To display data which already is on your page you can include JSON directly into your code and build a report based on it. For inline JSON addJSON(JSON) method is used.

Read more in the following guides: