Question
1
Replies
1271
Views
Saltech Consulting
Posted: 2 years ago
Last activity: 2 years 1 month ago
External Database Table Class Mapping to a View
Scenario:
- Pega Version is 7.4
- We have a set of legacy systems with different data sources
- There is a virtual data port (VDP) technology that connects to these systems.
- In the virtual data port several views are created for the purposes of access this data for the pega application.
- The data is needed to be read and used in our Pega application preferably in data pages.
The initial approach was to try to use the New External Database Table Class Mapping button on the Data Model Classes and Properties landing page but this doesn't seem to be working as normal when used on a table failing to create the class and properties but it does create a database table instance.
Question:
Does the Pega product support mapping to a view in an external database (or VDP)?
Posted: 2 years ago
Hi Michael,
As long as you have configured the external data configuration in the prconfig file or on the database rule in pega it should work. Before doing this have just tried creating a class and map that class to the external DB and table. And then do the test connectivity this will tell you whether it is able connect to database or not. If not then probably something is missing in the configuration either jar files or db user details etc by checking the logs you will come to know the issue.
If the connection is working fine then check that user has all the permissions to perform CRUD operations on that external DB.
Thanks,
Naresh.