Question 4 Replies 888 Views × Close popover Suresh p (Suresh4347) Accenture Application Development Senior Analyst Accenture IN View Profile Send Message Suresh4347 Member since 2017 81 posts Accenture Posted: January 20, 2017 Last activity: May 2, 2017 Posted: 20 Jan 2017 21:26 EST Last activity: 2 May 2017 2:54 EDT Closed Question related to integrating different tables How to connect two diiffrent tables …I have one table in SQl & one is Oracle …How to get the data from two tables…? Is it possible…? ***Moderator Edit: Vidyaranjan | Updated Categories & Title*** Data Integration × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover 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: 4 years ago Posted: 21 Jan 2017 10:21 EST × Close popover Haritha Damarla (Haritha12) PEGA Technical Solutions Engineer Pegasystems Inc. IN View Profile Send Message Haritha12 PEGA replied to Suresh4347 Hi, I think, it has nothing to do with report-definition from pega end. Probably, you can write use Connect-SQl method in an activity to extract data from two tables in two different data bases. It is possible by creating hetrogenious connectivity (between Oracle and MSSQL) , where you can query the other db using the dblinks created from Oracle . Thanks, Haritha.D Posted: 4 years ago Posted: 21 Jan 2017 11:03 EST × Close popover Umamaheshwar Reddy Midthuru (Mahesh Midthuru) PEGA Sr. Software Solutions Engineer Pegasystems Inc. US View Profile Send Message Mahesh Midthuru PEGA replied to Suresh4347 Hi Suresh, Adding to haritha suggestion, you can also map your external table to the Pega class using External Class mapping wizard explained here. Then you can use this classes to fetch the data from the databases. Regards Mahesh Posted: 4 years ago Posted: 21 Jan 2017 11:08 EST × Close popover Ratan Balaji (Ratan) Areteans Lead Consultant Areteans AU View Profile Send Message Ratan Areteans replied to Suresh4347 Getting data from 2 different tables that belongs to 2 different databases is not possible in Pega, provided you are trying to access the data in a single Rd rule using joins. Is this what you are looking for? Posted: 4 years ago Posted: 2 May 2017 2:54 EDT × Close popover Tapeshvar Arunkumar (IceDragon) Commonwealth Bank of Australia Tapeshvar Arunkumar Commonwealth Bank of Australia IN View Profile Send Message IceDragon Commonwealth Bank of Australia replied to Ratan Yes, how can i achieve this in pega? Any suggestions or workarounds?