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.
Please provide some specific details. What database/version is your PegaRULES and this external database? Is the actual database table in a different schema on the same database that PegaRULES is on or a different server entirely. For the table what is the schema name and table of the actual table and then what is your synonym name? What is the database user who is being used in the external database connection?