Is it possible to connect a class to multiple external databases?
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,