This section illustrates how to connect to a relational database using the sample .NET Core server implementing the custom data source API.
This approach has the following advantages:
You have full control over data loading. Our sample .NET Core server allows splitting the data from your database into different subsets, thus 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.
You can implement your own security logic. With the custom data source API, you can manage the data access and data security the way you want.
Reduced browser’s memory usage. Flexmonster loads only the data needed for the report, and that data is already summarized, so the client side is less loaded.
- Microsoft SQL Server
To connect to MongoDB, use the Flexmonster MongoDB Connector. If you use other NoSQL databases or data warehouses please refer to our Connecting to other databases tutorial.
With .NET Core server, you can connect to a MySQL, Microsoft SQL Server, PostgreSQL, or Oracle database. Follow detailed tutorials for each database: