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, Ubuntu/Linux, and macOS.
- Microsoft SQL Server
- 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.
With Flexmonster Data Server, you can connect to a MySQL, Microsoft SQL Server, PostgreSQL, Oracle, or Microsoft Azure SQL database. Follow detailed tutorials for each database: