How can we fetch data from an external database table when it’s not exposing services ,only it’s url and credentials are provided?
How can we fetch data from an external database table when it’s not exposing services ,only it’s url and credentials are provided?
We are using Postgres’s sql and we want to fetch currency exchange rates from an external database,without using connectors as the external system is not exposing services
***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Posted: 3 months ago
MOD
Pegasystems Inc.
GB
To fetch data from an external database table using Postgres SQL without using connectors, follow these steps:
- Install client libraries for Postgres.
- Create a Database rule with the JDBC URL, Username, and Password.
- Create a Database Table instance and map it to the internal Pega class.
- Use a Connect-SQL rule to define and execute SQL queries to fetch the data.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
How to connect to external DB?
How to configure external DB connections from Designer Studio