Working with Microsoft Dynamics 365 doesn't have to be overly complicated, especially when approaching it from the aspect of a data architect or DBA. It does help having some fundamental knowledge of the options and means to connect into and out of a D365 system whether On Prem or Online. These articles are written within the context of a data engineer, data architect, or DBA who's been asked to interact with a Microsoft D365 environment.
This can be quite a niche and unique enironment, so it's often one that the average DBA may have little to know experience with - but hopefully this will be a launchpad to learn some of these components as you naviage this exciting product.
These articles are all in flux, as they go online the titles to the left will become links.
Create a Plugin
Creating an Azure Function to connect with Dynamics 365
Creating a Console Application to connect with Dynamics 365
Connect to D365 using SSIS - CozyRoc
Connect to D365 using SSIS - Kingswaysoft
Using XrmToolBox - It's your Friend!
Within the confines of Dynamics 365 there often comes a need to create customized processes where queuing is needed. Granted Microsoft and other third-party processes have MANY ways of doing this, but simple queueing can be built right into D365. This series highlights how to build such a component within any D365 system - it's not as hard as you might think.
Architecture and Design
Creating Processes
Batch Processing through ETL
Monitoring