Pivot table component supports the following databases:
Our component offers Flexmonster Data Server – a special server that implements the custom data source API and allows connecting to SQL databases in a convenient way. Follow detailed tutorials for each database:
In Flexmonster component you can easily:
Check our guide on how to connect to the CSV data source: How to build a report based on CSV data source.
To gain better performance while working with the CSV data source, use Flexmonster Data Server – a special server implementing the custom data source API. With the Data Server, it is possible to visualize large CSV files up to 1GB conveniently and fast. Learn more about connecting to CSV using the Data Server: Connecting to CSV using Flexmonster Data Server.
Our component supports two kinds of JSON format – array of objects, where each object is an unordered set of name/value pairs, and array of arrays, where each sub-array contains ordered values.
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.
Read more in the following guide: How to build a report based on JSON data source.
Working with large JSON datasets is possible with Flexmonster Data Server – a special server implementing the custom data source API. The Data Server is a cross-platform solution that allows visualizing the datasets up to 1GB. To connect to JSON data source with the Data Server, see our guide: Connecting to JSON using Flexmonster Data Server.
To retrieve the data from a MongoDB database easily, Flexmonster suggests you using the MongoDB Connector. When embedded into your back end, this special server-side tool retrieves already summarized data from MongoDB and prepares the data for Flexmonster.
For more details, read our step-by-step guides:
The custom data source API is a custom communication protocol allowing you to fetch already aggregated data from a server to Flexmonster Pivot. With the custom data source API, you can combine different data sources even if they aren’t supported by Flexmonster directly, visualize reports on large datasets, and have full control over the data processing.
To start implementing the custom data source API, follow the tutorial: Implementing the custom data source API server.
Flexmonster supports OLAP cubes created in both tabular and multidimensional modes. 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 analytic systems. In case you need advanced features, e.g. 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:
Combine Elasticsearch and Flexmonster Pivot to analyze data directly in the browser.
The key feature is that there is no need to load all the raw data into the pivot table to build the cube – a multi-dimensional representation of the data. Flexmonster sends a sequence of queries to get the summarized data from Elasticsearch.
For more details read our guide: Connecting to Elasticsearch.
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 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: