How to do upsert from ADF to Salesforce using relationship lookup

Question

How to do data upsert from Azure Data Factory to Salesforce while using relationship lookup? It is possible in other tools like Talend but how to achieve it in Azure Data Factory?

Pic from Talend:

The scenario: we upsert contacts and meanwhile need to have contact to be assigned to the account.

Answer 1

Hi Zigmunds Bībers,

Thank you for posting query in Microsoft Q&A Platform.

Using dataflows, in ADF we can perform upserts. But in this case you wanted to work with salesforce connector. In ADF dataflows, at this moment Salesforce connector is not supported. So directly using connector in dataflows it's not possible.

You can consider writing your own code to do same using databricks notebook or synapse notebooks and run that notebook as one of step in ADF pipeline using databricks notebook or synapse notebook activities.

But it's good feedback to have salesforce connector for dataflows as well. I forwarded this feedback to internal team. I encourage you to have a feedback item for same submitted using below link. Product teams closely check feedbacks and consider for future implementations.

https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

Hope this helps. Please let me know if any further queries. Thank you.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.

Answer 2

Thank you, ShaikMaheer, for the reply.
I was referring to this already existing connector. https://learn.microsoft.com/en-us/azure/data-factory/connector-salesforce?tabs=data-factory#salesforce-as-a-sink-type

And meanwhile I have found by a luck the answer/solution here:
https://stackoverflow.com/questions/53623673/azure-datafactory-upload-to-salesforce-and-reference-field-on-another-object

I think it would be beneficial for others to update the connector documentation for this solution (workaround?) as I was searching for it for several days, thanks!