web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Saas and SQL ODBC
Small and medium business | Business Central, N...
Suggested Answer

Saas and SQL ODBC

(0) ShareShare
ReportReport
Posted on by swenger 172

Previously we hosted Business Central on our own server as well as our own SQL server. I had an ODBC SQL set up which allowed me to run queries in Access directly to the Business Central Tables. Now that we moved to Saas and Azure our data is hosted in the cloud. Is it possible to set up an ODBC to the data to run Queries. I know in Excel there is the ability to do this through Odata feed, but this is not available in Access.

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,686 Moderator on at

    In BC Saas there is no direct access to the underlying database. Instead you can use the APIs and web services:

    learn.microsoft.com/.../

    These APIs you can then, for example, use in Power BI to import the data. Excel also has the possibility to use APIs and web services. The Power Platform too (Power Automate, Power Apps, Dataverse,...)

    About Access I have no idea, who uses that anymore by the way ;-)

    learn.microsoft.com/.../

    learn.microsoft.com/.../

    learn.microsoft.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans