We want to use Pentaho Reporting as the reporting tool for our application which runs against Oracle. Different users work in different Oracle schemas, ie they have different usernames and passwords which give them access to separate sets of tables and views. When a report is run, it needs to access the same set of tables and views depending on their Oracle login.

I think the ideal way to do this would be to set up different JNDI entries in Pentaho and pass the name of the relevant one as a parameter in the URL when calling the report from our application. Then the reporting engine would use it to connect to the correct datasource. Is it possible to do this? If not, can anyone think of a different way we can achieve this result?