Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Seynabou Jeannette Diop (SeynabouJeannettD)
ATOS

ATOS
RS
SeynabouJeannettD Member since 2015 3 posts
ATOS
Posted: Jul 8, 2015
Last activity: Jul 9, 2015
Posted: 8 Jul 2015 11:41 EDT
Last activity: 9 Jul 2015 5:22 EDT
Closed

Integration with external table

Hi,

I want to populate a dropdown with data stored in an external table.How to create a jdbc connection to connect to my database?I am in Pega 7.

Can someone help me please?

To see attachments, please log in.
Data Integration

Posted: 9 years ago
Posted: 8 Jul 2015 11:55 EDT
Ravi Padwal (RaviP@incessant)
NIIT Technologies Limited

NIIT Technologies Limited
AU

1) Create a D-A-DB-Name instance and map it to your external database

2) Go to Data Model => Database Table class mapping landing page

3) Click on new database table mapping and provide required details, this will create class and properties.

4) Create a report definition on this class to fetch the values you required for dropdown

5) Create a data page with report definition as source

6) Configure this data page as source of dropdown control

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice