Question
Pega Systems
IN
Last activity: 22 Jan 2018 14:24 EST
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.
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.
Accepted Solution
Pegasystems Inc.
US
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.
JPMorgan Chase & Company
US
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.
Pegasystems Inc.
US
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
Pega Systems
IN
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?
Accepted Solution
Pegasystems Inc.
US
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.