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..


Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Share your thoughts

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.