Hi experts
I am working on an integration where I receive input data from an external system. Based on that data, I perform certain actions in Business Central, such as canceling or posting sales invoices. As an output, I need to push the resulting sales credit memo data into a SQL database.
My main question is: how can I send or insert data into SQL Server from Business Central after an action is completed?
I want the process to be minimal and lightweight. The SQL Server I am referring to is an online (cloud-based) SQL Server, not an on-premises one.
Additionally, there are a few other scenarios where I need to push data from Business Central to SQL. I am looking for a simple solution that:
Does not involve Azure Functions for token handling or transaction processing
Does not use Power Automate
Allows me to log all changes in a log table within Business Central so I can track actual data pushes and their success rates
Also, do I need to use any middleware for this integration, or can it be done directly?