we deliver a reporting solution from D365 Finance and Operations using “Export to Datalake” functionality, ADF, and a on-prem SQL Server to, customer have asked us to come up with a solution to swap the “Export to Datalake” functionality.

Question

we deliver a reporting solution from D365 Finance and Operations using “Export to Datalake” functionality, ADF, and a on-prem SQL Server to, customer have asked us to come up with a time estimate to swap the “Export to Datalake” functionality. what is the best way to replace this

Answer 1

@Sampreeth - Thanks for the question and using MS Q&A platform.

It seems like you are looking for a way to replace the "Export to Datalake" functionality in your reporting solution for D365 Finance and Operations. Here are a few options you can consider:

1. Use Azure Data Factory: You can use Azure Data Factory to copy data from D365 Finance and Operations to a destination of your choice, such as a SQL Server database or another data lake. This will give you more control over the data and allow you to customize the data pipeline as needed.
2. Use Power BI: You can use Power BI to connect directly to D365 Finance and Operations and create reports and dashboards. This will eliminate the need for a separate data lake and simplify the reporting process.
3. Use Azure Synapse Analytics: You can export data from D365 Finance and Operations to Azure synapse. It can store and process data, and then load it into the on-prem SQL Server and also can handle complex data transformation and analytics.

In terms of time estimates, it will depend on the complexity of your current solution and the requirements for the new solution. I would recommend conducting a thorough analysis of your current solution and the requirements for the new solution to come up with a more accurate estimate.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.