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

Integration with other systems

(1) Share

Report

Posted on by GM-27061209-0

Hello,
I have to read a write from a to another sql database, different from that of my Business Central database.
My BC is On Premise but I would implement a solution that is easily portable to the cloud and I want to avoid to use solutions like sql server stored procedures.
What is the best solution?
Is it to create a middle application that interacts with bc and the other db with rest api calls? Or what?

Thank you

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 77,981 Super User 2025 Season 1 on at

Like (1)

Report

Integration with other systems

You can also consider using Power Automate, which includes standard BC connectors and SQL connectors.

However, the standard API on the BC side does not include all tables and fields, and customized APIs may also be required.

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Valentin Castravet 26,349 Super User 2025 Season 1 on at

Like (1)

Report

Integration with other systems

Is it to create a middle application that interacts with bc and the other db with rest api calls? Or what?

That can work but my preferred way is to build a custom solution inside of Business Central that will interact with the APIs
Suggested answer

gdrenteria 14,559 Most Valuable Professional on at

Like (0)

Report

Integration with other systems

Hi

I hope this information helps you, you have many possibilities that will allow you to be scalable.

Integration overview for Business Central - Business Central | Microsoft Learn

BR

GR