Is it possible to connect a class to multiple external databases?
Hi,
I currently have an application which interacts with an external Oracle database, this database is linked to an integration class using a database table rule.
I now have a requirement where Pega will need to interact with another instance of the same database (structure) but use the same rules as the original integration class. Is this possible? It appears that the only way to control which database a connect-sql rule is the ClassName (which has to be exact so I cannot use inheritance), RequestType and Access.
In summary what I am trying to achieve is:
- Create a pega case
- A property is set on the case to determine if it needs to check data from Instance A or Instance B
- The same connect-sql rule is reused but depending on the property set in step 2, the case checks the relevant instance
Thanks in advance,
Mark
Accepted Solution
Incessant Technologies
IN
In connect SQL while writing queries to interact with external DB, we can use properties to get the values from external DB and likewise we can use some notation to specify the target table where this query will be executed. There two forms to specify the target table-name. 1. using table keyword another 2. using Class keyword.
In connect SQL while writing queries to interact with external DB, we can use properties to get the values from external DB and likewise we can use some notation to specify the target table where this query will be executed. There two forms to specify the target table-name. 1. using table keyword another 2. using Class keyword.
In Class keyword we can specify exact class name [eg {class:ClassName}] which will be used to know the DB and Table name where query will be executed. In other form we can use {class: {page.property}. I think in this syntax you can use the property which will give value of another instance in same DB to perform DB operation. Please check this page, it discusses in detail on how to write query in Connect- SQL rule.
https://community.pega.com/sites/default/files/help_v721/procomhelpmain.htm
Hope it will help.
Rajesh