web
You’re offline. This is a read only version of the page.
close

Josh Shaw D365 Developer

Josh Shaw

Joined: 6/23/2025

  • Allow Financial Reporter to read from a 'Read-Only' version of AXDB on a secondary SQL sever (On-prem)

    Thu, 27 Apr 2023 12:52:15 GMT – Dynamics 365 Finance – New 

    Updating the fact table in Financial reporter can have a massive performance impact on the D365 application as both the FR database and AXDB must reside on the same SQL server.


    Using a High-Availability group we can replicate AXDB to a secondary SQL server to act as a read-only D365 database, perfect for reporting purposes.


    We recently had a need to refresh the FR database but doing so in office hours resulted in a completely unusable D365 application.


    Please can you look into a way of configuring Financial reporter to retrieve its data from a different SQL server.


    Thanks.