This section illustrates how to connect to a data source using Flexmonster Data Server.
Flexmonster Data Server is a special server-side tool implementing the custom data source API. It is responsible for fetching data from a data source, processing, and aggregating it. Then the data is passed to Flexmonster Pivot in a ready-to-show format. The Data Server significantly reduces the time of data loading and enables analyzing large datasets.
Flexmonster Data Server supports the following data sources:
- CSV and JSON files
- MySQL databases
- Microsoft SQL Server databases
- PostgreSQL databases
- Oracle databases
- Microsoft Azure SQL databases
Advantages of Flexmonster Data Server:
Larger datasets. Despite Flexmonster Pivot can connect to a CSV or JSON file directly, the browser’s capability limits the size of a file (on average, up to 100 MB). Flexmonster Data Server can process files more than 1GB — the maximum file size depends on your RAM capacity and the number of unique members in the dataset.
Reduced browser memory usage. Loading, processing, filtering, and aggregating of the data is made on the server side, so Flexmonster gets the ready-to-show data. Thus, the data is visualized faster, and the browser’s resources are used more efficiently.
Built-in security configurations. The Data Server allows establishing authorized access to data and managing security in a convenient way.
A convenient way of connecting to a database. Though there are several ways of fetching data from a database, the speed and capacity of the Data Server make it the best way to load the data from a database.
Cross-platform solution. Flexmonster Data Server is available for popular operating systems: Windows, Ubuntu/Linux, and macOS.
There are the following ways to use Flexmonster Data Server:
You may be interested in the following articles: