Question

1
Replies
470
Views
 Sangeetha R (RSANGEETHA)
Cognizant

Cognizant
IN
RSANGEETHA Member since 2013 3 posts
Cognizant
Posted: February 15, 2019
Last activity: February 15, 2019
Posted: 15 Feb 2019 5:57 EST
Last activity: 15 Feb 2019 10:37 EST
Closed

Connect-SQL with External and Pega DB

Hi,

We have requirement to join 3 tables and fetch the datas. But 2 tables are present in External DB and one table is present in Pega DB. Is it possible to join external and Pega DB tables in Connect-SQL to write a query.

Any suggestions will be really helpful.

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.
Posted: 2 years ago
Posted: 15 Feb 2019 10:37 EST
Laurence Brannigan (LaurenceB_GCS)
PEGA
Senior Software Solutions Engineer
PEG
GB

It's nothing that I've tried before. But I can't see how it would be able to run the query unless you have some kind of DBLink between the two databases.


Even then they would need to be issued as a single db user (I believe).


Otherwise if you only have the option to perform this as two separate queries you may want run two Connect-SQL rules (or one for the external data and standard Pega techniques such as obj-browse) to collect data from the two sources, then merge them in the application code.