Question4Replies827Views Suresh4347 Member since 2017 81 posts Accenture Posted: January 20, 2017Last activity: May 2, 2017 Closed Question related to integrating different tablesHow 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 popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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: 3 years agoHaritha12 PEGA replied to Suresh4347Hi, 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: 3 years agoMahesh Midthuru PEGA replied to Suresh4347Hi 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: 3 years agoRatan Areteans replied to Suresh4347Getting 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: 3 years agoIceDragon HTC Global replied to RatanYes, how can i achieve this in pega? Any suggestions or workarounds?