Passing security information to a report over a JDBC connection

Pentaho Report Designer

Part Number

You can use one of two options when you want to pass security-related information, (such as user name and password), associated with a report over a JDBC connection:

  • Choose from the list of predefined environment variables; for example, env::username or env::roles
  • Define your own specific environment variables to pass to the connection, (session or global), using the formula function, ENV, inside a hidden parameter. For example, =ENV("session:xaction_parameter_password") or =ENV("global:xaction_parameter_password") where xaction_parameter_password is the parameter defined in an .xaction.

Passing security information a JDBC connection

The available selections appear as drop-down options under JDBC Security Configuration when you click Edit Security in the JDBC Data Source dialog box.