Sonal Vasisth (SonalVasisth06)
JP Morgan Chase & Co.

JP Morgan Chase & Co.
SonalVasisth06 Member since 2016 10 posts
JP Morgan Chase & Co.
Posted: December 19, 2019
Last activity: January 24, 2020
Posted: 19 Dec 2019 17:40 EST
Last activity: 24 Jan 2020 14:39 EST

Joining data from 2 external databases in PEGA

We are on PEGA 8.2.2. Our pega database is an oracle DB. For a workflow requirement, we have also connected to an external MSSQL database. Let's say database server name is '123'. In '123' MS Sql Db, there are multiple databases 'ABC' and 'DEF' on same server. We need to do some joins of tables across these 2 DBs and display in PEGA.

1. We configured these 2 databases as different data sources in IBM websphere console with same J2C authentication data as one db user has access to all DBs on '123' server.

2. Created 2 databases instance rules in PEGA and mapped to web console JNDI names

3. Created 2 classes and 2 database tables instances and mapped them to these 2 database instances along with schema name and table name

4. Created a connect sql rule and in the browse tab, doing join of these 2 tables.

When we run the query, PEGA is not able to understand the second table from the join. It works fine if we write query with either one of the 2 classes so, there is no issue with Db connections but if we do join across databases in sql query, it fails.

Please suggest.

***Edited by Moderator Marissa to update platform capability tags****

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.