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:
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, MariaDB, Microsoft SQL Server, PostgreSQL, Oracle, or Microsoft Azure SQL database. Follow detailed tutorials for each database: