web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Programatically readin...

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

Suggested Answer

Programatically reading large amount of data from business central

(0) Share

Report

Report

Posted on by goodwill1120

5

As title, my customer has some custom tables storing their POS transaction and membership data in D365 BC online, we need to do data analysis with some custom build tool, whats the easiest way to read large data stored inside D365 BC? Is there some sort of ADO.NET / ODBC way we can use?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

MahGah 15,613 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

My suggestion is try to store those data in data lake. Based on my experience anytime you read lots of data from BC then it slows down BC for other users. But if you extract data to data lake then you can use data lake.

Some options are github.com/.../bc2adls

or

appsource.microsoft.com/.../PUBID.efoqus-5058796|AID.replicator|PAPPID.18a4d438-88d1-44ee-a38d-3c0ea0d77338

or

lyftron.com/.../

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 677 Super User 2026 Season 1

#2

YUN ZHU 521 Super User 2026 Season 1

#3

Khushbu Rajvi. 306 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans