What is Alternate Key – CRM 2015 Update 1

Hi ,

They have introduced cool concept named Alternate Key in 2015 Update 1.

Alternate key can be used as a unique identifier for the record.

Why we need Alternate key as we already have primary key?

This will come handy when you are integrating CRM data with external databases which might deal with natural data type than GUID’S. Which will help developers to write integration code easily.

And also when we are working with external we may not have access to update external database tables to add unique identifier for referencing.With alternate keys you can now define an attribute in a CRM entity to correspond to a unique identifier used by the external data store.

This is how a Alternate key can be created from UI.

1

2

Alternate keys can be created only on the below data types.

  • Decimal Number
    Whole Number
    Single line of text

Unfortunately Date/Time, Lookup and OptionSet fields cannot be used as the key fields in this release, which could be something that you might want to use sometimes.

You can alternatively use SDK to create CRM Alternate Keys. You will be looking at CreateEntityKeyRequest message if you ever want to do so.

For more information follow the below articles

http://www.kingswaysoft.com/blog/2015/04/16/New-CRM-SDK-Feature—Alternate-Keys

https://msdn.microsoft.com/en-us/library/dn932139.aspx

Thank you,

Sreeni Pavalla

Published by Sreeni Pavalla

Working as a Assistant Technical Manager in Positive Edge Technologies. Having over 11 years of extensive hands-on experience in MS Dynamics CRM 4.0, 2011, 2013, 2015, 2016, Dynamics 365 with over 5 years of experience in CRM Online. You can visit my blog here https://sreenipavalla.me/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: