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

how to download cloud table data ? to sql server or file

(0) Share

Report

Posted on by UbootMike

hello, we want to change our local erp system to BC cloud version. but i have a lot of extra software programmed with microsoft access where i connect it with the local erp sql server: tables and views.

but how do i connect my local ms access to the tables from the bc cloud versio ? i only find a /not so cheap/ cdata-odbc-driver....

but i think there must be another solution for that ?!

thanks for your help

regards, mike

Categories:

Business Central

All responses (3)

Answers (0)

UbootMike 14 on at

Like (0)

Report

how to connect local ms access to BC online data ?

hello, thanks for your answers, but i am no really an expert in the suggested solutions.

our case has changed, i think it is easier now: i only need from about 5 tables from the cloud a download from the table every 1 hour to a local sql server or file (i will then import it).

is there an easy way to get the cloud table data and download it ?

regards, mike
Suggested answer

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (0)

Report

how to connect local ms access to BC online data ?

Maybe you could consider Power BI. This can link BC with some other local databases, similar to cdata.

More details: https://learn.microsoft.com/en-us/training/paths/use-power-bi/?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU
Suggested answer

gdrenteria 12,167 Most Valuable Professional on at

Like (0)

Report

how to connect local ms access to BC online data ?

Hi

I would advise you to access Business Central through web services and APIs.

REST API Web Services - Business Central | Microsoft Learn

SOAP and ODATA web services - Business Central | Microsoft Learn

Best Regards

Gerardo