Question

1
Replies
1105
Views
Mark Moss (MarkM379)
Siemens

Siemens
GB
MarkM379 Member since 2015 6 posts
Siemens
Posted: August 26, 2016
Last activity: September 30, 2016
Posted: 26 Aug 2016 7:35 EDT
Last activity: 30 Sep 2016 11:43 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.