Need a special offer?Find out if your project fits.
+

Mondrian - Configuring username/password protection

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.

Overview

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:

  • Providing credentials to connect to the data source.
  • Supporting different roles and access levels for users.

Here are step-by-step instructions on how to configure a secure connection with username/password protection.

Requirements

  • Flexmonster Pivot version 2.205 or higher
  • A relational database with a Mondrian schema
  • Java JRE 1.7+

Step 1: Create a default user for Flexmonster Accelerator

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).

Step 2: Configure Flexmonster Accelerator

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).