Question

6
Replies
202
Views
SubhajitChattopadhya Member since 2010 36 posts
Infosys Australia
Posted: 3 years ago
Last activity: 2 years 10 months ago
Closed

External Database Listening

Dear Team,

I have a requirement where I need to connect to an external database which is used by external systems in the organization and the data is needed on a daily basis to be fed into Pega at non-business hours. We have created the DB connection creating an instance for Data-Admin-DB-Name class. The connection also is successful.

My approach to the requirement was to write an agent that would hit the external DB at 11:00 pm and would populate the corresponding tables in the Pega Schema which can be later referred by Pega.

What is the best approach or practice for the above requirement?

What if the requirement in the future changes to fetch the external data for more than once? In that case, I guess my approach would not be ideal if performance is considered.

Please help with the suggestions and guidance.

Thanks and Regards,

Subhajit

**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.

Data Integration
Moderation Team has archived post
Share this page LinkedIn