Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sangeetha Ramakrishnan (SangeethaR16857911)
CBA

CBA
IN
SangeethaR16857911 Member since 2023 3 posts
CBA
Posted: Feb 15, 2019
Last activity: Feb 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.

To see attachments, please log in.
Data Integration

Posted: 6 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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice