Question

1
Replies
1062
Views
MarkM379 Member since 2015 6 posts
Siemens
Posted: 4 years ago
Last activity: 4 years ago
Closed
Solved

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: 

  1. Create a pega case
  2. A property is set on the case to determine if it needs to check data from Instance A or Instance B
  3. 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

Data Integration
Moderation Team has archived post
Share this page LinkedIn