Copy data to Salesforce from Azure Datafactory, using AutoResolve IR or Self hosted IR ?

Question

Copy data to Salesforce from Azure Datafactory, using AutoResolve IR or Self hosted IR ?

MS Techie 2,751

While copying the data from Azure Data factory , using Azure AutoResolve IR , to Salesforce , it gives the below message.

To copy data into Salesforce, explicitly create an Azure IR with a location near your Salesforce, and associate in the linked service

Should we use a Self-Hosted Integration Runtime instead of Azure AutoResolve IR , while copying data to Salesforce or do we have alternatives ?

Please help.

2 answers

Your answer

Answer 1

Saurabh Sharma 23,846 Microsoft Employee Moderator

Hi @MS Techie ,

Thanks for using Microsoft Q&A !!
If you copy data to Salesforce, you can't run the copy using the default Azure Integration Runtime. In other words, if the source's linked service does not have the specified integration runtime, it will be closer to the Salesforce instance and you need to explicitly create an Azure Integration Runtime.

Please follow the documentation - Create Azure IR - How to create and configure the Azure Integration Runtime .
Also, if you don't know in which region your Salesfore instance is you can refer to Where is my Salesforce instance located?

Once your IR is created you need to refer to the newly created IR from your Salesforce Linked Service.

Please let me know if this helps.

Thanks
Saurabh

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

MS Techie 2,751 Reputation points

2021-04-12T13:23:33.323+00:00

Hi @Saurabh Sharma

Can we use Self Hosted IR , instead of Azure SSIS IR , to copy data to Salesforce from Azure Data factory.

I think Self Hosted IR will be cheaper than Azure SSIS IR

Please advise.
MS Techie 2,751 Reputation points

2021-04-14T08:57:54.1+00:00

Hi again

Can we use Self Hosted IR , instead of Azure SSIS IR , to copy data to Salesforce from Azure Data factory.

I think Self Hosted IR will be cheaper than Azure SSIS IR

Please advise.
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-04-14T13:51:48.777+00:00

@MS Techie sorry for the delay. I am checking internally on this one and get back to you on the same but can you please confirm Why do you want to use SHIR instead of Azure IR and are you planning to host this SHIR on a VM ?
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-04-14T14:51:58.127+00:00

@MS Techie I have got the confirmation that you can use SHIR for the same.

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.
MS Techie 2,751 Reputation points

2021-04-15T12:54:12.66+00:00

Hi @Saurabh Sharma

So should the SHIR be hosted in the same region as the Salesforce ? (in order for the Azure ADF to send data to Salesforce )

Answer 2

Saurabh Sharma 23,846 Microsoft Employee Moderator

Hi @MS Techie ,

Not necessarily as it’s only a suggestion for better performance.

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh

Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-04-16T18:18:08.603+00:00

Hi @MS Techie ,

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-04-26T14:48:06.82+00:00

Hi @MS Techie ,

I have not heard back from you. Did my answer solve your issue? If so, please mark as accepted answer. If not, please let me know how I may better assist.

Thanks
Saurabh

Share via

Copy data to Salesforce from Azure Datafactory, using AutoResolve IR or Self hosted IR ?

2 answers

Your answer