How to connect to salesforce through Delta copy database template?

Hi @S D, Sudevika

Welcome to Microsoft Q&A platform and thanks for posting your query here.

It seems like when you're trying to set the source dataset to use a Salesforce linked service in the Delta Copy Database template, it's defaulting to creating a new linked service for Azure SQL Database instead. This behavior could be due to a few possible reasons.

Here are some suggestions that may help:

Template Limitations

The Delta Copy template you’re using might be designed mainly to work with SQL-based sources, which is why it’s automatically switching to an Azure SQL Database connection. If that’s the case, you may need to adjust the setup to work with Salesforce. I also checked on my end and noticed that while multiple sources are available, Salesforce doesn't appear. So, try creating the Salesforce connection manually to see if it reflects in the template.

Create a Salesforce Linked Service Manually

To connect Salesforce as your source:

• Go to the "Manage" section in Azure Data Factory.
• Manually create a new linked service for Salesforce and ensure all the necessary authentication details (username, password, security token) are correctly configured.

Link the Source Dataset Manually

Once you've created the Salesforce linked service:

• Go back to the pipeline and manually link the source dataset to your Salesforce linked service instead of letting it default to Azure SQL Database.

Modify the Template

If the default template only supports SQL sources, you might need to make some changes:

• Replace activities related to the SQL input dataset with those that work with Salesforce.
• Adjust any configurations to ensure your pipeline works with Salesforce as a data source.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.