Deploying Jet Analytics with Microsoft Dynamics 365 Finance and Supply Chain Management requires a Bring Your Own Database (BYOD) approach since direct SQL access is no longer available. The process involves creating and importing Jet Data Entities into D365 F\&SCM, publishing them to an Azure SQL database, and configuring exports using full or incremental pushes with change tracking for updates. Administrators can manage schemas, remove or rebuild entities, and create new ones in Visual Studio. Once exported, data feeds into Jet Analytics for advanced reporting and analysis in Power BI and Excel, ensuring reliable, real-time insights.

Join for free to read