Mondrian / Сonfiguring username/password protection
Flexmonster Pivot Component supports credentials to access the data source. It is commonly used for the following purposes:
- provide credentials for data source connectivity
- provide access for users with different roles and access levels
Here are the step-by-step instructions to configure secure connection with username/password protection.
- Flexmonster Pivot Component version 2.205 or higher
- Relational database and Mondrian schema for it
- Java JRE 1.7+
Step 1: Create a default user for Accelerator
We recommend creating a default user for Accelerator with default privileges. It is used to start the Accelerator, check connection to the data source and connect anonymous users. Refer to the documentation of your database to create a new user (i.e. MySQL, Oracle).
Step 2: Configure Accelerator
flexmonster.config and specify user and password in the
CONNECTION_STRING parameters. After editing,
flexmonster.config should look like the following:
Accelerator is ready to be launched. Just execute the following command in terminal:
java -jar flexmonster-proxy-mondrian.jar
You can check the Accelerator is up and running by navigating to its URL in the browser (i.e. http://localhost:50006).