Moving from relational databases to Azure Data Lake

Relational databases such as the Azure SQL database are designed for transactional workloads and optimized for Online transactional processing (OLTP) workloads, while data warehouse or Online Analytical Processing (OLAP) systems are optimized for reporting and analytics. Data in the data warehouse is cleaned, enriched, and transformed so that it can act as a single source of truth that users can trust. A modern data warehouse architecture suggests bringing all your structured and unstructured data into a Data Lake and cleansing, enriching, and transforming data before loading it into your data warehouse.

The following documentation, from the Microsoft documentation site, provides details ...

Get Implementing Microsoft Dynamics 365 for Finance and Operations Apps - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.