Need a special offer?Find out if your project fits.
+
Get Free Trial
Get Free Trial
  1. API reference
  • Introduction
    • JavaScript
    Angular
    Vue
    React
    Other integrations
    Troubleshooting
    Connecting to Data Source
    1. Supported data sources
      2. JSON
      CSV
      Database
      1. Connecting to SQL databases
      2. Connecting to a MySQL database
      3. Connecting to a MariaDB database
      4. Connecting to a Microsoft SQL Server database
      5. Connecting to a PostgreSQL database
      6. Connecting to an Oracle database
      Flexmonster Data Server
      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
    • Table of contents

    Connecting to SQL databases using Flexmonster Data Server

    This section illustrates how to connect to a relational database using Flexmonster Data Server – a special server developed by Flexmonster. This server communicates with the client using the custom data source API - our custom communication protocol allowing you to retrieve already aggregated data from a server to Flexmonster Pivot.

    This approach has the following advantages:

    • You have full control over data loading. Flexmonster Data Server allows splitting the data from your database into different subsets, so you can work with that part of the data you need at the time. In addition, this reduces the amount of data filtrations performed by the server so it will work faster.
    • Saving browser’s resources. 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.
    • 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.
    • Built-in security configurations. The Data Server allows establishing authorized access to data and managing security in a convenient way.
    • 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).

    Supported databases

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

    To connect to MongoDB, use Flexmonster MongoDB Connector. If you use other NoSQL databases or data warehouses, refer to our Connecting to other data sources tutorial.

    Guides

    With Flexmonster Data Server, you can connect to a MySQL, MariaDB, Microsoft SQL Server, PostgreSQL, Oracle, or Microsoft Azure SQL database. Follow detailed tutorials for each database: