Pass database url as parameter at run time

0

I have 2  similar oracle databases in 2 different pdbs using the same reports.

Is it possible to pass the database url as parameter to jasperserver at runtime?

The idea is to use one instance of jasperserver to run the reports from 2 database sources.

Example URL sent to jasperserver :   MyOracleServer.com:8080/jasperserver/flow.html?_flowId=viewReportFlow&database_url=jdbc:oracle:thin:@MyOracleServer.com:1521/pdb1.MyServiceName.com&report=MyReport...

                                                             MyOracleServer.com:8080/jasperserver/flow.html?_flowId=viewReportFlow&database_url=jdbc:oracle:thin:@MyOracleServer.com:1521/pdb2.MyServiceName.com&report=MyReport...

didier.lebon's picture
Joined: Jun 12 2019 - 7:37am
Last seen: 1 month 1 week ago

1 Answer:

0

If you have Pro version then most probably you can do following trick:
create 2 datasources, then combine them in 1 with Virtual Datasource,define different aliases, build your report with parametrized schema name, when running report - switch schema.

ogavavka's picture
162
Joined: Mar 12 2012 - 2:10pm
Last seen: 1 week 4 days ago
Feedback