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

 Sivakrishna Tammisetty (Sivakrishna)
Virtusa
Technical lead
Virtusa
IN
Sivakrishna Member since 2016 2 posts
Virtusa
Posted: Aug 13, 2019
Last activity: Aug 28, 2019
Posted: 13 Aug 2019 3:33 EDT
Last activity: 28 Aug 2019 2:17 EDT
Closed

How to fetch the data from External DB using report definitions

How to fetch the data from External DB using report definitions, is it possible or not ?

To see attachments, please log in.
Pega Knowledge
Pega Platform
Data Integration

Posted: 5 years ago
Updated: 5 years ago
Posted: 13 Aug 2019 6:41 EDT
Updated: 14 Aug 2019 8:39 EDT
Kiran Chitmalla (KiranC34)
EY

EY
IN

thats what is report definition is used for.

 

***Moderator Edit-Vidyaranjan: Edited content to adhere to community guidelines of engagement***

To see attachments, please log in.
Posted: 5 years ago
Posted: 13 Aug 2019 6:42 EDT
Bhanu Prakash Reddy Anugu (BhanuPrakashAnugu)
TMHCC
Senior Pega Engineer
TMHCC
GB

Hi Siva,

You can fetch the data from the external DB using Report Definition, but you have to configure the below rules in PEGA

  • Database rule to map the external database
  • Database table rule & Class to map the external table in the external database.
  • Create the report definition in the class created in the second step.(you might need to create the properties in PEGA with the column names you want to fetch into PEGA)

Thanks!

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