Sudha Sundaramoorthy (SudhaS14)

SudhaS14 Member since 2015 22 posts
Posted: December 18, 2018
Last activity: March 14, 2019
Posted: 18 Dec 2018 20:28 EST
Last activity: 14 Mar 2019 15:06 EDT

Pega 7.4 External database Synonym Class mappping


I have a requirement to connect to external database synonym. In the Database Table Class Mapping, the synonym is not listed under Table name (I infer Pega is filtering only the Table Object names). If I type the synonym name I get "Error encountered investigating table: Database-NonexistentTable".

If I directly create a Class with all the required Properties of the database synonym and Create a Database Table, then I am able to access the synonym but the actual Primary keys(of the synonyms actual table) are not recognized. If the Class do not have any key then Test Connectivity has no issues in connecting to the table. But If I set the Class key (similar to primary key columns) then Test Connectivity throws Primary Key mismatch error.

It would be of great help if anyone share your experience of connecting to synonym from pega prpc. I cannot connect to the actual table because the table belong to external system and it cannot be accessed directly as table.

Enterprise Application Development Dev/Designer Studio 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.