Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 210
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
  • astral projection Profile Picture
    astral projection on at
    Access the database of Business Central, read only permissions maybe in ssms
    Nice., you welcome. this is what I need
     
     
  • astral projection Profile Picture
    astral projection on at
    Access the database of Business Central, read only permissions maybe in ssms
    I am coming...
     
  • Suggested answer
    astral projection Profile Picture
    astral projection on at
    Access the database of Business Central, read only permissions maybe in ssms
    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 
  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 106 on at
    Access the database of Business Central, read only permissions maybe in ssms
    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 
  • Community member Profile Picture
    Community member 22 on at
    Access the database of Business Central, read only permissions maybe in ssms

    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

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,048 Super User 2024 Season 1 on at
    Access the database of Business Central, read only permissions maybe in ssms
    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.
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 12,920 Most Valuable Professional on at
    Access the database of Business Central, read only permissions maybe in ssms
    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

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans