Discussion

External database connection and Synonym

Hello,

I'm trying to connect to an external database, after configuring Database rule, I'm using the wizard as described here. Instead of reading from a table, I need to read data from Synonym, but when I add the synonym in "Table" field, step 4 of the guide, I got the following error:

pyMetadata:** Error encountered investigating table: Table XXXX does not exist in database YYYY

 

It seems I can connect to a table, to a view, but not to a synonym, is this a known limitation?

 

Note: it is an Oracle database, connecting to it with Toad, I'm able to execute a query on this synonym without any schema prefix, and in the Pega wizard I'm not adding any schema too.

 

Thanks for your help.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

Pega
March 24, 2016 - 7:50am

The best solution is to remove the synonyms. If the application must use them, set a Dynamic System Setting or edit context.xml to set a default schema for the target database (in the same way you set the PegaRULES and DATA default schemas). Use the following structure, replacing the italic text:

<Environment

name="prconfig/database/databases/DatabaseName/defaultSchema"

value="default_schema_name"

type="java.lang.String" />