Small and medium business | Business Central, N...

BC 365 insert Azure SQL Server

(0) Share

Report

Posted on by elkin

greetings to all

I am new to the community, and I would like to know if certain data can be sent from business central 365, a database in azure sql server, if possible, how can I achieve this objective, I hope to have your valuable help

All responses (2)

Answers (0)

elkin 10 on at

Like (0)

Report

RE: BC 365 insert Azure SQL Server

Perfect, thank you very much, I will validate the information. If I have doubts I will be posting again.
Suggested answer

Inge M. Bruvik 993 Super User 2024 Season 1 on at

Like (0)

Report

RE: BC 365 insert Azure SQL Server

There are several ways to do that and the best approach is dependant on the datavolume and the update frequency that is needed for your project.

Both Business Central and Azure SQL have API's that you use to read / write data between the systems.

learn.microsoft.com/.../

learn.microsoft.com/.../

The Business Central API's can be customized if you need data that is not covered by the API.

You can also use Power Automate to handle this because there is connector to both Azure SQL and Business Central from Power Automate.