News and Announcements icon

Dynamics 365 CommunityForums Business Central forum BC SaaS web services r...

Business Central forum

Answered

BC SaaS web services read only replica or production

(1) Share

Report

Report

Posted on by Samantha73

2,254

Hi All

When creating new web services by exposing pages and queries for reporting, does the Azure SQL use a read-only replica of the database or the production

Categories:

Integration to Power BI, Power Apps, Power Automate and Dataverse

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

YUN ZHU 69,639 Super User 2024 Season 2 on at

Like (0)

Report

BC SaaS web services read only replica or production

Hi, hope the following helps.

Dynamics 365 Business Central: Managing Database Access Intent (Managing write access to APIs from the client)

https://yzhums.com/19105/

Hope this helps.

Thanks.

ZHU
gdrenteria 9,472 Most Valuable Professional on at

Like (0)

Report

BC SaaS web services read only replica or production

Hello good afternoon
I hope these links can help you, you can use the DataAccessIntent property for this task.

Manage database access intent in Business Central - Business Central | Microsoft Learn

DataAccessIntent Property - Business Central | Microsoft Learn

2023 Wave 2 – v23: Report read-only data access – Gerardo Rentería Blog (gerardorenteria.blog)

Attention to this note:

best regards
Verified answer

Judy Microsoft Employee on at

Like (1)

Report

BC SaaS web services read only replica or production

Hi Sir,

When creating new web services by exposing pages and queries for reporting, Azure SQL Database can use either a read-only replica of the database or the production database itself, depending on the configuration and requirements of your application.

What is the Azure SQL Database service? - Azure SQL Database | Microsoft Learn

Read queries on replicas - Azure SQL Database & SQL Managed Instance | Microsoft Learn

Best Regards,

Judy

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 228,493 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans