Azure Data Export Service

 Introduction

Previous Post - CRM SDK Feature – Entity Change Tracking

Data Export Service is an Azure Service that adds the ability to replicate Common Data Service data to Azure SQL Database efficiently.

Data Export Service synchronizes entire Common Data Service Data and its Schema on a continuous basis i.e. whenever change occurs to the source data (transactional data).

When we say schema, it means the Entity and it’s Attribute. We need NOT to manually create Entity/Table and Attribute/Columns in the Destination.

Note: The supported Destinations are Azure SQL Database and SQL Server on Microsoft Azure Virtual Machine. We will use Azure SQL Database as Destination target.

We can use Data Export Service with Microsoft Dynamics 365 (online) and Microsoft Dynamics CRM Online 2016 Update.

Let's jump to Part 1 - Validate Data Export Profile

For more information, visit-

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/data-export-service

Install SSIS in Visual Studio 2019

 1. Open Visual Studio 2019,  Click Extensions-> Manage Extensions

2. Search SQL Server Integration Services Projects and click download.

3. Install downloaded File.

4. Follow the wizard to complete installation

We may get any of the following error because Visual Studio is still open and we’re trying to update. Click ‘OK’, close Visual Studio and install again.

Installation wizard takes a while to complete. Once it is installed we see this window and we may require to restart computer.

5. Go to “New” Project, and Integration Services Project is now available in Visual Studio 2019. We can get started with project now.