Question
JP Morgan Chase
IN
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)
Accepted Solution
Pegasystems
IN
No such options are available.
Pegasystems
IN
You are using RDB-List with a Rule-Connect-SQL. Please see the section "Identifying a database table or a Pega 7 Platform class" in the following help article
https://community.pega.com/sites/default/files/help_v72/procomhelpmain.htm
JP Morgan Chase
IN
Can you confirm about
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)
JP Morgan Chase
IN
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.
Pegasystems
IN
There is an option of using alternate database with list views / summary views. Would this help?
https://community.pega.com/sites/default/files/help_v55/procomhelpmain.htm
JP Morgan Chase
IN
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.