Need a special offer?Find out if your project fits.
+
Get Free Trial
Get Free Trial
All documentation
  • Introduction
    • JavaScript
    React
    Angular
    Vue
    Other integrations
    Troubleshooting
    Connecting to Data Source
    1. Supported data sources
      2. JSON
      CSV
      Database
      Flexmonster Data Server
      1. Introduction to Flexmonster Data Server
      2. Installing Flexmonster Data Server as a service
      3. Flexmonster Admin Panel guide
      4. Data sources guide
      5. Security and authorization guide
        6. The Data Server as a DLL
        The Data Server as a console application
      MongoDB
      Microsoft Analysis Services
      Custom data source API
      Elasticsearch
    2. Connecting to other data sources
    Configuring the component
    Saving component configs
    Customizing
    Charts
    License keys
    Accessibility
    Security
    Updating to the latest version
    Flexmonster CLI Reference
  • Browser compatibility
  • Documentation for older versions

    • 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
    • MariaDB 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 1 GB — 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 (32-bit and 64-bit), Ubuntu/Linux (64-bit and ARM64), and macOS (64-bit and ARM64).

    There are the following ways to use Flexmonster Data Server:

    What's next?

    You may be interested in the following articles: