Alternate Keys which were introduced with CRM 2015 Update 1, gave us the ability to Upsert and Update records, by defining one or more fields as Alternate Key and use that field(s) instead of relying only on Primary Key.
Alternate Keys can also be used for setting or updating the lookup instead of GUID.
CDSCRM Destination Component in KingswaySoft SSIS Integration Toolkit allows us the option of specifying the Alternate Key for updating the lookup field.
Suppose we have Contact entity…
Continue Reading Nishant Rana’s Article on their blog
Blog Syndicated with Nishant Rana’s Permission
More About This Author
• Microsoft Certified Professional in Microsoft Dynamics CRM (CRM 3.0 to CRM 2016), Microsoft SharePoint (2007 and 2013) and Microsoft .NET with 10+ years of experience.
• 10 years of working experience with Microsoft Dynamics CRM starting with CRM 3.0 to CRM 2016 on various project aspects: analysis, designing, developing, leading team etc.
• An avid blogger who likes to learn, help, share and contribute in Community.
• Author of “Nishant Rana’s Weblog” (https://nishantrana.wordpress.com/), technical blog on Microsoft .NET technologies with more than 2.5 million hits and 800 followers. The blog is also recognized as one of the top 35 blogs on Microsoft Dynamics CRM.
• Twitter account https://twitter.com/nishantranaCRM with more than 500 followers, which includes MVP(s) and experts in Microsoft Dynamics CRM.
• Technical Reviewer of following books on Microsoft Dynamics CRM.
- 2018.12.10#Dyn365CEYou don’t have permission to access any of the organizations in the Microsoft Dynamics CRM Online region that you specified error in USD Client Application
- 2018.12.03#Dyn365CEMerged vs. Child Cases – Nishant Rana’s Weblog
- 2018.12.02#Dyn365CECrmRecordId and IsNew Output in CRM/CDS Destination Component – Nishant Rana’s Weblog
- 2018.12.01#Dyn365CE[D365 CE Online] Debug Async Plug-in using “Persist to Entity” profiler option – Nishant Rana’s Weblog