D365FO On-Prem to Cloud Migration: Access cloud database for external use

(2) Share

Report

Posted on by AB-28110123-0

Hi Expert,

I am currently migrating from D365FO On-Prem to Cloud for a client. On the existing On-Prem, there is 1 server outside the D365FO server that contains a .NET application for creating RDLC reports, which contain queries directly to AxDb D365FO On-Prem. It can be described as follows:

D365FO On-Prem (with a button that opens the .NET link) -> .NET generates the report -> Displays the report

However, when migrating to D365FO Cloud, the database cannot be directly accessed externally. The client requests that the .NET application remain usable due to the large number of reports stored there. Is there a solution to keep the .NET application functional? When searching online, options like BYOD, Azure Data Lake, and Data Entities/Service API appear.

For additional information, the reports in the .NET application include:

- Order prints, packing slips, invoices, etc (need realtime)

- Analysis reports

I have the same question (0)

All responses (2)

Answers (0)

Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You can't directly access the production database from outside F&O. Period.

Therefore you have three options:

Utilize existing reporting capabilities of F&O instead of the .NET application.

Copy the data you need from the production database to your own database, which you can then connect to (BYOD, data lake...).

Access the database indirectly (Dataverse virtual entities, OData etc.).

For analytics, check the benefits you can get by switching to Power BI.

Was this reply helpful? Yes No
AB-28110123-0 16 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your response @Martin Dráb

I think that if we use entity/OData, it would not be suitable for the analytic report, because the datasource uses complex join queries. However, if we use BYOD or Azure Data Lake, would there be data delivery latency and how long would the delay be if there is a large amount of data?

Was this reply helpful? Yes No