Question
REST Service Vs Direct Update to External DB Table
Our System Of Records is an external DB.
Whenever there is an update required as determined by flow in pega, we need to update the SOR DB Table.
Legacy system is a .Net implementation.
Two patterns we are considering to make these updates to the SOR db table.
- From Pega directly update the table using connect integration
- Use a REST service to pass the data update.
What are the pros and cons of these approaches?
Performance, extensible, security - if we consider these aspects.
You mean to say REST is better from performance stand point?
Hi Sharma,
- From Pega directly update the table using connect integration -> are you talking about Connect-SQL rule?
If so then performance wise Connect-SQL rule is good, but in terms of design practice perspective REST service is best.
Hope it is helpful to you.
Regards
Mahesh
That's right, Connect SQL.
Another aspect is - maintaining another layer of services (REST) which again does a DB update. Now from Which design practice perspective you say REST is best?
If we compare with the Connect SQL implementation i told that REST service is better in terms of design practice. Generally if you don't have any external service to connect to the external system then you can try to go with Connect SQL rule. If the external system provides any service to connect with it then its better to use with that service whether it can REST/SOAP/etc.
Yeah, I got what you are saying.
I just extended my question.
Thanks for your response.
Hi,
If number of interaction more as per the requirement you can use REST service with enabling TLS/SSL or else you can go with directly update.