Posted: 18 Mar 2016 6:10 EDT Last activity: 22 Mar 2016 3:42 EDT
Querying the PRPC Database
PRPC version V5.5 SP1
We query the Database using RDB-List method, the generated Java for the method shows: tools.getDataBase().listRDB(). There are 2 questions:
1. A SQL rule is created in class (mapped to a table in the PegaRULES database), but the query is referring to a Schema and Table outside the PegaRULES database(DB config/datsource defined in Application Server). How does PRPC identify during execution, which Database to query?
2. Also, if the Query is going to hit an external Database, is it possible to dynamically alter the Data source of the DB (say overriding some API or changing any configuration on App Server)
We have a initiative,where we would having a new Data Source, but the existing would Data Source would remain in tact. So in essence, in essence, with the same query, we would like to hit a different data source (if possible by overriding an API).The intention is that, since the queries are configured at multiple places (via List Views, stand alone queries), rather than introducing an if/else logic invoking the RDB-List method (at all places), if we can make the change at one place, in order the solve the purpose.
Can we do anything at the App Server Level, by overriding the Driver or place some logic to use a different Data source at run time.
No, this wont solve the purpose, as it would be on run time that I would need to decide which data source to use. Plus the approach, which I am looking for, is not just restricted to reports, rather to simple SQL queries as well.
Kindly suggest, if any other options available,by overriding an API.