Analyzing the information from a database often comes with the necessity to secure the data properly. Database access management should be configured in accordance with business logic.
Occasionally our customers are interested whether it is possible to connect to the database directly. This feature is not supported in Flexmonster due to security reasons. Connecting to the database requires login/password. Since Flexmonster is a fully client-side component, the direct connection to the database would require storing login/password in the browser and sending it in an insecure way.
To avoid the vulnerability, the connection to the database is always made on a server side. Our team developed a tool capable of compressing the database response. This helps to reduce the amount of data transferred to the client side. Our compressing tool is embedded in your back-end application. It is called Flexmonster Data Compressor and it ships together with Flexmonster Pivot.
Security aspects of using Flexmonster Data Compressor are covered in the sections below: