Small and medium business | Business Central, N...

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

(1) Share

Report

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (0)

Report

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.

Losing Direct Access to SQL Server from Business Central SaaS (archerpoint.com)

Dynamics 365 Business Central Wave 2: on-premise and direct SQL integrations – Stefano Demiliani

BR

GR

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (1)

Report

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.

Integrating with Microsoft Dataverse - Business Central | Microsoft Learn

Integrating with Microsoft Power Platform - Business Central | Microsoft Learn

Extract data from Business Central - Business Central | Microsoft Learn

Was this reply helpful? Yes No
Community member 22 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Peter Jones - BIDA 151 on at

Like (0)

Report

Hi Steven Renders ,

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.

Extract data from Business Central - Business Central | Microsoft Learn

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

Was this reply helpful? Yes No
Suggested answer

astral projection on at

Like (0)

Report

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

Was this reply helpful? Yes No
astral projection on at

Like (0)

Report

I am coming...

Was this reply helpful? Yes No
astral projection on at

Like (0)

Report

Nice., you welcome. this is what I need

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates