Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Supported data sources

Supported data sources

Flexmonster supports many of the common data sources including:

Relational databases

Flexmonster supports the following databases:

  • MySQL
  • Microsoft SQL Server
  • Microsoft Azure SQL
  • PostgreSQL
  • Oracle

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:

CSV data source

In Flexmonster you can easily:

  1. build a report based on a CSV data source
  2. load CSV data from a file
  3. add data generated by a server-side script

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.

JSON data source

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.

MongoDB databases

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

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.

MS Analysis Services

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:

Elasticsearch

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.

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 data. In this case, we recommend Flexmonster Accelerator for Pentaho Mondrian cubes – a special server-side proxy that helps you to increase data loading speeds from the server to the customer’s browser.

Read our step-by-step guides: