Azure Data Factory and Logic Apps for Dynamics 365 Finance and Operations

Hello the Community, this new blog post is for you if you are wondering how we can leverage Azure Integration Components on top of your ERP : Dynamics 365 Finance and Operations. How, when, and why can we use such kind of components to integrate large & low volume of DATA. I will also explain the basic knowledge required to go further especially for Azure Data Factory as an ETL component before integration. What are also the benefits compare to the Data Management Framework or DataFlow of Dynamics 365 ? Also which one to use : Logic Apps or Azure Data Factory ? Yes so much questions here ;) Let’s jump in !

Azure, Dynamics365Aurélien ClereOctober 28, 2020Azure, Dynamics365, Data Factory, Logic Apps Comment

Modern Datawarehouse Dynamics365 Finance and Operations

Hello the Community ! New global post on technical architecture for Reporting / BI and Analytics with Dynamics 365 Finance and Operations. Here I will present a new capacity to push data coming from Tables and Entities into an Azure Data Lake Storage in real time as well as how to use it after with Azure Synapse Analytics and PowerBI. How to build a Modern Datawarehouse architecture for your ERP and expose custom views & model for your business users in PowerBI. How to use DirectQuery mode with SqlOnDemand mode (pay as query mode - serverless) + Azure Analysis Services : Let’s jump in !

Dynamics365, PowerBIAurélien ClereAugust 25, 2020Synapse, Azure, Datawarehouse, BI Comment

Azure Data Lake with Dynamics365 FinOps - CustomerInsights and Power Platform !

Azure Data Lake Storage Gen2 is a set of capabilities dedicated to big data analytics, built on Azure Blob storage

Data Lake Storage Gen2 makes Azure Storage the foundation for building enterprise data lakes on Azure. Designed from the start to service multiple petabytes of information while sustaining hundreds of gigabits of throughput, Data Lake Storage Gen2 allows you to easily manage massive amounts of data.

I will show you the benefits for this type of this model based on the CDM (Common Data Model) among Dynamics 365 FinOps, AI with Customer Insights and Power Platform.