Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I have a CRM 2013 organisation that holds Property data that is maintained by an external application (WinForms with MS SQL). Any changes made to the Property data in this external application need to be synced with the same data held in CRM. This does not have to be real time and can quite happily happen overnight each day. Changes can be in the form of properties deleted, updated or new properties added. The update will always happen from the external application to CRM and never the other way around. In CRM, records created in CRM will have references to Properties (that could possibly be deleted by the external application).
I can setup triggers on the required fields in the database of the external applications so that any property records that are changed, will get added to a separate Sync table which will have all the property fields along with an Action field with values I (Insert), U (Update) and D (Delete).
My question is what is the best way of getting this data (insert, update, deletions) from the Sync table into CRM in an automated fashion. As there are multiple ways of doing this I wanted to know, which way was preferred and why. Any help will be much appreciated. Thanks in advance.
With an SSIS adapter or tool like from Kingsoft this could be done in a supported way:
We are doing the same thing in our company. I would also suggest KingswaySoft.
If you are already familiar with both SQL and CRM then using it will be a breeze.
You would need to download:
Sql Server Data Tools: docs.microsoft.com/.../download-sql-server-data-tools-ssdt
You can also Upsert Data to CRM which is really good if you are looking create data but do not want to produce duplicates in the process.
you can use it in a few ways.
1. If you are a developer or have dev resources
You can create a custom application. For something simple like that, maybe I would rather do this. In terms of maintenance, it's not a lot (but you do need to always have a developer around if / when something changes in the process)
2. If you are not a developer, you have to use a tool like Scribe or SSIS
Assuming you have SQL, you already have SSIS, so you just need an SSIS connector. There are few good ones - KingswaySoft, CozyRock, etc. I blogged about it a couple of months ago:
You'll have to purchase a Dynamics connector license from one of those companies since you'll have to schedule those SSIS packages.
As for Scribe.. it should also work, but licensing may end up being more expensive.
Business Applications communities