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).
flexmonster.config and specify the user and password in the
CONNECTION_STRING parameter. After your edits,
CONNECTION_STRING should look like this:
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).