News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Integration with other...

Business Central forum

Suggested answer

Integration with other systems

(1) Share

Report

Report

Posted on by GM-27061209-0

6

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

GM

Categories:

Integration with Dynamics 365 products

Integration to Power BI, Power Apps, Power Automate and Dataverse

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 63,013 Super User on at

Like (0)

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 6,365 Super User on at

Like (0)

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 4,232 Super User 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

Helpful resources

News and Announcements

Just out! June 2024 Dynamics 365 Community Newsletter

Community forum and blog attachments are now available!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,876 Super User

#2

Martin Dráb 225,425 Super User

#3

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans