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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,277 Super User 2024 Season 2
Martin Dráb 228,135 Most Valuable Professional
nmaenpaa 101,148