In my previous blog focusing on the hurdles of real-time, two-way data integration, I highlighted the hurdle of how to discover the data you need translated. In most cases, discovering the net-change data is all you want to translate on a real-time basis. Remember, a two-way integration means net-change data going in two directions or more (depending on the number of systems you’re integrating) at a rate determined by how many end-users there are on each of the systems being integrated. Business systems with a significant amount of end-users can create substantial volumes of net-change data.
In order to manage the volume of data flowing between systems, you must choose a net-change model to discover just the data that needs to translate. There are traditionally four basic models to choose from, one of which will discover the net-change data. They are not all equal though, so choosing will depend somewhat on the system(s) you’re working with and somewhat depend on the data model of the system(s) with which you’re working.
The four methods are as follows, in best practice order:
Lastly, what to do with concurrent updates to a record. End-user #1 in sales, opens John Smith’s contact record to add a new cell number. At the same moment End-user #2 in finance, opens John Smith’s record to update the billing address. With applications like Dynamics CRM, Salesforce and SharePoint, the application logic will manage the concurrent changes and will make sure both are recognized and able to be discovered as net-change, and translated. Other than that, it’s the ‘last out wins’ method.
In my next post in this series, we’ll take a look at working the business process rules and application rules, into the integration process, and, at what frequency should the integration run.
Trackback from C5 Insight Blogs - Business Strategy, SharePoint, Dynamics CRM, Salesforce.com, Collaboration and Relationship Management
One blog reader recently asked us about affordable options for migrating data from CRM 2011 to CRM 2015 when upgrading. This article provides a number of options to consider. ...
Trackback from C5 Insight Blog
We recently published a blog on all of the updates available when upgrading from CRM 2011 to CRM 2015 ...
Thanks for the info Dave.
Good hearing from you Pierre. I hope this finds you well.
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.