Experts,
We have a project requirement where we need to synchronize data from D365 CRM to external SQL DB on create/update/delete of records and vice versa.
As a proposed solution we were planning to utilize Azure Logic apps / MS Flow since they both provide SQL connectors to capture a row create/modify trigger in SQL. But there are certain limitations with SQL connectors like below.
New row trigger -> MUST have an IDENTITY column in SQL DB
Modified row trigger -> MUST have ROWVERSION (a.k.a. TIMESTAMP) column in source DB
Ref Link: https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/ \
Since the source SQL DB is third party maintained system so client is reluctant to adding/modifying columns in their existing DB system.
Please suggest any recommended approach for data integration between D365 CRM and SQL server or if anybody has done this kind of implementation before.
Thanks in Advance!
Regards,
Rohit Negi
