Salesforce Connector not available with Fabric Data Factory?

[Dan-WDW]

I'm alittle puzzled by Microsoft having different sets of pre-established connectors in Azure Data Factory and Fabric Data Factory. Azure has a Salesforce connector, while Fabric does not. What gives?

[jianleishen]

https://learn.microsoft.com/en-us/fabric/data-factory/connector-salesforce-copy-activity

[Dan-WDW]

Thanks for the reply @Anonymous. I'm refering to the Data Pipelines. Azure Pipelines has a native Salesforce connector where data can be easily copied to and from Salesforce and these copy activities can be authored very quickly. While the *Data Flows (Gen 2)* does enable one to copy data FROM Salesforce, it does not allow one to as easily copy data to Salesforce, unless I'm missing something

[Tom_CA]

Hello @Dan-WDW  I am facing the same problem here. did you solve it? Any suggestions?

Tks

[Anonymous · Accepted solution]

Hi @Dan-WDW ,

Thank you for your response.

Currently there are no Salesforce connectors available in MS Fabric Data Factory.
But we can expect them in upcoming release of MS Fabric, as it is already on roadmap.

Hope this information is helpful. Please let me know if you have any other questions.

[Tom_CA]

Hello everyone!

I was trying to create a Dataflow to get data from Salesforce, and I can see these connectors there (as we have in Power Query). However, when I tried to use it, the DataFactory/Dataflow sent me the message below.

The crazy point is that Salesforce can see the connection on their side, and I can connect there using Power Query (desktop).

Could you suggest something to create a dataflow using Microsoft Fabric to get data from Salesforce?

Error message

Salesforce connections log

[Dan-WDW]

Thank you for the response, @Anonymous.  Is there a public road map?

I did in fact locate the documentation which verifies this for anyone wondering about a specific connector: Data pipeline connectors in Microsoft Fabric.

[Anonymous]

Hi @Dan-WDW - Thanks for using Fabric Community.

As I understand you are looking for Salesforce Connector in MS Fabric.
I was able find 2 types of Salesforce connector in DataFlow Gen2. Can you please confirm if it helps?

In meantime I am checking with internal whether they are planning to add more types of Salesforce Connector in upcoming days.