Managing Database Access Intent

As a super user or administrator, you can change the database access intent on reports, pages of the type API, and queries to improve performance of the service.

Overview

Business Central can be set up to use read-only replicas of the primary (read-write) database. Using the database replica reduces the load on the primary database. In some cases, it will also improve the performance when viewing data in the client. Replicas are beneficial for objects, like reports, queries, and API pages, that are used for viewing data only, not modifying data.

When objects run, the database access intent determines whether to use a read-only replica, if one is available, or the primary database. Reports, API pages, and queries are developed with a predefined database access intent (see DatabaseAccessIntent property).

The Database Access Intent List page lets you override the predefined database access intent for objects when they're run.

In database terms, this feature is commonly known as read scale-out. For more information about read-scale out and data access intent in Business Central, see Utilizing Read Scale-Out for Better Performance in the Business Central Developer and Administration help.

To change the database access intent

1. Choose the icon, enter Database Access Intent List, and then choose the related link.

   The page lists all reports, pages, and queries. The Access Intent column includes one of the following values:

   Setting	Description
   Default	Indicates that the object uses the predefined database access intent.
   Allow Write	Sets the object to use the primary database, allowing the user to modify data.
   Read Only	Sets the object to use the database replica, which means that the user can only view data, not change data.

2. Choose the Edit List action.

3. On the Edit - Database Access Intent List page, change the Access Intent field for the objects.

   Note

   If an object that is editable, like the Customer Card, is set to Read Only, the primary database will still be used, regardless of the access intent, allowing users to make changes as normal.

See Related Training at Microsoft Learn

See Also

Business Functionality
General Business Functionality
Working with Business Central
Getting Ready for Doing Business

Start a free trial!

Note

Can you tell us about your documentation language preferences? Take a short survey.

The survey will take about seven minutes. No personal data is collected (privacy statement).