For data migration and integration with Microsoft Dynamics CRM, the tool of choice is most likely going to be Scribe Software’s Insight product. For those of you who are familiar with the tool, you know it is very powerful because its CRM Adapter does everything for you in terms of keeping data integrity in the CRM database.
In order to use Scribe Insight’s Console to integrate data between Microsoft Dynamics CRM and other systems, most commonly Microsoft Dynamics GP, there is a significant amount of time needed to set up the integration environment. Known as the Scribe Plugin Publisher, which monitors the CRM database for the entities you define and then creates an XML record for records which are created, modified or deleted. Detailed knowledge of MSMQ (Microsoft Message Queues) and the MSCRM Publisher (a component of Scribe Console) is required for this type of integration. These tasks are not easy for the less experienced individuals related to Scribe Console.
However, in the latest version of Scribe Insight, v6.5, there is a new and simpler option to setup integration between CRM and other systems. It is called the Scribe Workflow Publisher and it uses the internal, graphical interface of the CRM Workflow engine to trigger the integration points. The main advantages that the Workflow Publisher has over the Plugin Publisher are ease of ease of use, the ability to trigger based on an attribute change and the ability to work with CRM Online.
For me, the option to trigger an integration event based on an attribute change in CRM is a huge plus. The normal Plugin Publisher triggers an integration every time a record in CRM is added, modified or deleted, regardless of which field is modified. But with the new Worflow Publisher, everything is based on the CRM Workflow. So if your Dynamics CRM workflow is set to execute after certain attributes in an entity meet any number of criteria, then the integration takes place. For example, you can setup a workflow to fire only when an Account’s phone number has changed or when a Contact’s attribute has changed from a Prospect to a Customer or any combination along those lines to fire a workflow and integrate the change to the other system. As you can imagine the possibilities are numerous.
1 thought on “The Best Option For Integrating and Migrating Data for Microsoft Dynamics CRM”
John
Scribe sucks. Just get some SSIS adapters and you'll be in good shape. 75K for scribe's top of the line product is ludicrous.
Comments are closed.
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Scribe sucks. Just get some SSIS adapters and you'll be in good shape. 75K for scribe's top of the line product is ludicrous.