NOTE: new features and further improvements are no longer released for the Mondrian data source.
Instead of Mondrian, our team highly recommends considering Flexmonster Data Server. Just like Mondrian, this tool aggregates data on the server side and can handle large datasets.
You can see the full list of available data sources here: Supported data sources.
Flexmonster Pivot Table and Charts supports the use of credentials to restrict access to the data source. They are commonly used for the following purposes:
Here are step-by-step instructions on how to configure a secure connection with username/password protection.
We recommend creating a default user for Flexmonster Accelerator with default privileges. This user will be used to start the Accelerator, check the connection to the data source, and connect anonymous users. Refer to the documentation of your database to find out how to create a new user (e.g. MySQL, Oracle).
Open flexmonster.config and specify the user and password in the CONNECTION_STRING parameter. After your edits, CONNECTION_STRING should look like this:
CONNECTION_STRING=Jdbc=jdbc:mysql://localhost:3306/foodmart?user=flexmonster&password=password;JdbcDrivers=com.mysql.jdbc.Driver;
The Accelerator is ready to be launched. Just execute the following command in terminal:
java -jar flexmonster-proxy-mondrian.jar
You can check if the Accelerator is up and running by navigating to its URL in the browser (http://localhost:50006 by default).
