Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Multi-tenant data repl...

Multi-tenant data replication on Dynamics CRM Online to Azure SQL

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

we want to develop a Managed Solution for Dynamics CRM Online that synchronizes data from the Account and Opportunities entities to an external Azure SQL database for data analytics purposes. The result of the data analytics should be written back to Dynamics CRM.

The use case is that we want to identifiy Accounts with high churn risk and write back a risk metric to the Account entity in CRM.

This solution needs to be multi-tenant capable, meaning the solution can be added into any CRM Online instance by an admin.

How should we architect this? Is it possible via a Managed Solution? Do we need a Service Account to access the data via APIs to be added in each instance by an admin? How can we avoid such a Service Account.

Thanks for your input.

Markus

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

M I Mostafa 4,257 on at

Like (0)

Report

RE: Multi-tenant data replication on Dynamics CRM Online to Azure SQL

Hi Markus,

Microsoft did this for you in the Microsoft Azure Data Export Service: msdn.microsoft.com/.../mt788315.aspx

Would this service help you achieve your requirement?

Data Export is an add-on service made available as a Microsoft Dynamics 365 (online) solution that adds the ability to replicate Dynamics 365 (online) data to a Microsoft Azure SQL Database store in a customer-owned Microsoft Azure subscription. The supported target destinations are Microsoft Azure SQL Database and Microsoft Azure SQL Server on Microsoft Azure virtual machines.

Hope this helps! Please mark as verified answer if you found this response helpful.