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 :
Small and medium business | Business Central, N...
Suggested Answer

Using t-sql in BC development

(1) ShareShare
ReportReport
Posted on by 1,165

Hi All,

I know you can develop queries in AL and use them  for reports etc.  Now since many of us are proficient in t-sql already is there any way to use this? For example I have the on-premise BC and cloud BC so I can create a sql query and then copy it to some extension that will convert to AL code or use sql views but somehow publish it to the cloud version? 

I know the LinkedObjects function but assume it only works on-premise

In the past I've used complex sql queries on on premise systems for reporting and event capturing now I'm just wondering if there is short cut other than using AL from scratch 

Thanks

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,172 Most Valuable Professional on at

    You cannot do that on the SaaS version, the database is not accessible.

    You can use direct SQL access with the on-premise version, but this is not recommended.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 645 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 432 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 248 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans