Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Access the database of...
Business Central forum
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by Pragya752 173
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:
Data Migrations
Reports and Business Intelligence
Integration with Teams, Excel, Outlook
Administration and permissions
Integration to Power BI, Power Apps, Power Automate and Dataverse
  • astral projection Profile Picture
    astral projection 11 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 11 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 11 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 98 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,043 Moderator 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 8,744 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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans