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... / Access the database of...
Small and medium business | Business Central, N...
Suggested Answer

Access the database of Business Central, read only permissions maybe in ssms

(1) ShareShare
ReportReport
Posted on by Pragya752 234
We have a client who has 100+ power apps which are currently running on sql as a database. Up until now ,they were using a some legacy ERP system but now they are shifting to Dynamics 365 Business central. They have lots of power automates and stored procedures in sql, which if we try to integrate via api pages in Business central will impact the performance of existing system. Is there any way we can access Business central database ,for read only permissions maybe, so that we can leverage the data without disrupting current architecture
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 26,834 Most Valuable Professional on at
    Hi
    You cannot directly access the database if you are talking about BC Saas, if we are talking about the ON-Premise version you could although it is not considered good practice.
    BR
    GR
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,698 Moderator on at
    In BC Saas there is no direct database access, and in BC On Prem it should be avoided.
    Using the existing APIs or developing new APIs would be the best practise, or simply integrate your BC with Dataverse and run the apps using the Dataverse integration.
  • CU27040855-3 Profile Picture
    CU27040855-3 22 on at

    Yes, Microsoft Dynamics 365 Business Central provides several options for accessing its database without impacting performance or disrupting the existing architecture. One approach is to utilize the Data Management Framework (DMF) in Business Central, which allows for data extraction and integration with external systems. You can configure DMF to export data from Business Central tables to a specified location, such as Azure Blob Storage or a file share, where your Power Apps can then access the data without directly querying the Business Central database.

    Additionally, Business Central offers web services and APIs that provide read-only access to its data. By leveraging these APIs, you can retrieve the necessary information from Business Central in a controlled and efficient manner, ensuring minimal impact on performance. You can configure permissions and access controls to restrict access to specific data entities, ensuring security and compliance with your organization's policies.

    Ultimately, by utilizing these built-in features of Microsoft Dynamics 365 Business Central, you can seamlessly integrate your Power Apps with the Business Central database while minimizing disruption to your existing architecture and maintaining optimal performance.

     

    https://www.cloudify.biz/marketplace/products/microsoftBC-integrations

  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
    I haven't used these forums much so not sure if the mention will find you properly.
     
    We are building a data warehouse product on BC. For on prem we will take data out of SQL Server directly.
    For cloud we have been told there is a "tool in the git repository that does this" but having looked around we didn't find it yet.
    As your post says, it requires APIs to be written to get data out of cloud. 
     
    So I too am interested to know of any progress / product / tools in this area that will replicate data out of BC Cloud to some target, most likely SQL server of some sort.
     
    Thanks
    Best Regards 
    Peter Jones 
  • Suggested answer
    astral projection Profile Picture
    astral projection on at
    Hello Microsoft
     
    Can you tell me , how to get access on Business centre Microsoft organisation?
    Is there any special requests or you can send me on email?
     
    Marko Alic, Makerpro. Team Microsoft 
  • astral projection Profile Picture
    astral projection on at
    I am coming...
     
  • astral projection Profile Picture
    astral projection on at
    Nice., you welcome. this is what I need
     
     

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,140 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,362 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,216

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans