Get Free Trial
  1. API reference
Connecting to Data Source
  1. Supported data sources
  2. Connecting to other data sources
Configuring the component
  • Documentation for older versions
  • Table of contents

    Introduction to Flexmonster Data Server

    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.

    The diagram below shows how Flexmonster Data Server fetches your data:

    How The diagram below shows how Flexmonster Data Server fetches your data

    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:

    What’s next?

    You may be interested in the following articles: