Using Alternate Key to Upsert\Update using Dynamics 365 for Sales Connector of Infomatica Cloud

To update or upsert a record inside CRM using Alternate Key in Dynamics 365 for Sales Connector we need to define Alternate Key Property of Microsoft Dynamics CRM advanced target properties.

Suppose we have the following alternate key defined in CRM

Here we need to use the Name attribute of the key as shown below

Hope it helps..

Using Alternate key in the Dynamics 365 for Sales Connector in Informatica Cloud

In our recent project we were using Dynamics 365 for Sales Connector of Informatica Cloud to push data into CRM from SQL DB.

To update the lookup instead of using GUID we decided to us the Alternate Key.

From the below KB article, it looks like the older version of the informatica connector wasn’t supporting the Alternate Key

https://kb.informatica.com/faq/7/Pages/15/377766.aspx

However, the newer and the recent version of the connector based which is based on Web API supports the alternate key.

To set the alternate key we basically need to use the below syntax,

EntitySetName(keyfield=’keyfieldvalue’)

i.e.

sab_fash_transactionheaders(sab_name=’value’)


Hope it helps..