Flexmonster supports the following databases:
Our component offers Flexmonster Data Server – a special server that implements the custom data source API and is a convenient way to connect to SQL databases. Below are detailed tutorials for each database:
In Flexmonster you can easily:
Check out our guide on how to connect to a CSV data source: How to build a report based on a CSV data source.
To improve performance while working with a CSV data source, use Flexmonster Data Server – a special server that implements the custom data source API. With the Data Server, it is possible to conveniently and quickly visualize CSV files up to 1GB. Learn more about connecting to CSV using the Data Server: Connecting to CSV using Flexmonster Data Server.
Our component supports two kinds of JSON formats – an array of objects, where each object is an unordered set of name/value pairs, and an array of arrays, where each sub-array contains ordered values.
JSON data can easily be loaded from a file. Customers can click Connect > To local JSON in the Toolbar and choose a file from the computer. Additionally, a JSON file can be referred to as a data source inside the report.
To display data that 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 a JSON data source.
Working with large JSON datasets is possible with Flexmonster Data Server – a special server that implements the custom data source API. The Data Server is a cross-platform solution that allows visualizing datasets up to 1GB. To connect to a JSON data source with the Data Server, see our guide: Connecting to JSON using Flexmonster Data Server.
To retrieve data from MongoDB easily, Flexmonster recommends using the MongoDB Connector. When embedded into your server, this special 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 that allows 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 this tutorial: Implementing the custom data source API server.
Flexmonster supports OLAP cubes created in both tabular and multidimensional modes. The component supports connecting to Microsoft Analysis Services in two ways: XMLA and Flexmonster Accelerator. XMLA is an industry standard for data access in analytic systems. To use advanced features such as faster data transfer, try Flexmonster Accelerator for Microsoft Analysis Services cubes – a special server-side proxy that helps you to increase data loading speeds from the server to the 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 summarized data from Elasticsearch.
For more details, read our guide: Connecting to Elasticsearch.