Hi team,
Can anyone suggest on how to achieve change data capture on SQL server in outsytems? Is there any configuration change needed for this? or any other way to achieve this?
Hey @Sneha Kumari
I was looking through outsystems documentation I was not able to find CDC in outsystems. There are some components that do CDC but most of them are used for auditing like this business solutionhttps://www.outsystems.com/forge/component-overview/15522/dx-compliance
There are some other workarounds that are possible:
1) Access the Database and check periodically for any changes https://success.outsystems.com/support/enterprise_customers/maintenance_and_operations/access_the_database_of_your_outsystems_cloud/
2) You can make wrappers on your database crud actions and call the API on any changeshttps://success.outsystems.com/documentation/best_practices/architecture/designing_the_architecture_of_your_outsystems_applications/integration_patterns_for_core_services_abstraction/
Let me know if that helps
Regards,Kshitij
@Kshitij Raheja Thank you for the reply. I am going through the links you have provided. I will update if these solve my use case.