Creating complicated Dynamics 365 reports with Data Export Service add-on

In Microsoft Dynamics 365 you don’t have direct access to the database and there is a good reason behind such limitation. However, what if you really need it. For example, you need to build complicated reports with a specific selection of data OR you need to integrate with warehouse solution supporting only database access. Also when migrating some or all functionality to another system.

Whatever is your reason – in this video we review the installation and configuration of Data Export Service add-on that will allow making a copy of your Dynamics data to an external database.

The installation process consists of 3 steps:

1. Installing Data Export Service add-on from the marketplace

2. Configuring Azure SQL Database and access

3. Enabling synchronization for Data Export Service

Read a text version of this video at UDS Systems blog by Roman Savran.