Azure Data Lake with D 365 FO PRESENTED

Azure Data Lake with D 365 F&O PRESENTED BY: JONATHAN ANDERSON - JANDERSON@BKD. COM

Jonathan Anderson • Senior Managing Functional Consultant at BKD • Microsoft Recognized Fast Track Solution Architect • 9 Years Dynamics experience • AX 2009 & 2012 • Dynamics 365 for Operations • Engineering Background in the Aerospace Industry • Specialization in Manufacturing • Experience with AX in Chemical, Transportation, Aerospace and Assembly Industries

Objectives • Review current Data Lake Options • Review future of Data Lake with D 365 F&O • Demo of Data Lake refresh from D 365 F&O Demo DB

Current Data Lake Options

Use Data Lake Instead of Ax. DW • Setup to use an Azure Data Lake instead of Ax. DW for refresh of Entity Store • Ability to have multiple data sources in a single location • Allows for trickle data approach to DL using standard entity store tables • Not allowed with standard Ax. DW entity store updates • Setup in System parameters

System Parameter setup

Future Data Lake Options

All F&O data in your own Data Lake • Tables and Entities in Data Lake Ax. DB F&O Data Feeds Other Systems Data Lake Historical Data

F&O Data in your data lake Key Tenants • Near real-time Key Benefits • Raw tables + T-SQL • MSFT copies tables from F&O – you can transform in lake • Entity definitions over tables (replace BYODB) • Easy migration • • Retire BYODB and Entity Store Schemas generated by Power. BI Data. Flows to enable Analytics and AI • Change feeds

Data Analysis using ADLS Power BI Azure Synapse Direct query with T-SQL SQL-on-demand using Azure Synapse (T-SQL, Spark) Entities Ax. DB F&O Data Feeds Tables Data Lake

Data Structure with CDM folders Model. json • Metadata file contains information about entity records/attributes and links to data files Data Files • Data files have well-defined structure and format and are references in model. json file • Files must be in. csv format without header information • Columns defined in model. json

Where are we now? • Currently tables in private preview with public preview to start March 2021 • Private preview includes full table export only with Azure Data Factory, no change data yet • Automated export using add-in still in development • No timetable for general release

More information https: //docs. microsoft. com/en-us/dynamics 365 -release-plan/2020 wave 2/financeoperations/finance-operations-crossapp-capabilities/finance-operations-data-azuredata-lake-all-azure-regions-all-customers https: //github. com/microsoft/Dynamics-365 -Fast. Track-Implementation. Assets/blob/master/Analytics/Azure. Data. Factory. ARMTemplates/SQLTo. ADLSFull. Ex port/README. md https: //www. yammer. com/dynamicsaxfeedbackprograms/#/threads/in. Group? type=i n_group&feed. Id=32768909312

Demo

bkd. com | @bkdllp The information contained in these slides is presented by professionals for your information only and is not to be considered as legal advice. Applying specific information to your situation requires careful consideration of facts & circumstances. Consult your BKD advisor or legal counsel before acting on any matters covered.