topic Re: Salesforce Connector not available with Fabric Data Factory? in Pipelines

Salesforce Connector not available with Fabric Data Factory?

Dan-WDW — Wed, 27 Sep 2023 15:12:36 GMT

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?

Re: Salesforce Connector not available with Fabric Data Factory?

Anonymous — Thu, 28 Sep 2023 10:45:54 GMT

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.

Re: Salesforce Connector not available with Fabric Data Factory?

Dan-WDW — Thu, 28 Sep 2023 13:14:33 GMT

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

Re: Salesforce Connector not available with Fabric Data Factory?

Anonymous — Fri, 29 Sep 2023 09:31:31 GMT

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.

Re: Salesforce Connector not available with Fabric Data Factory?

Dan-WDW — Fri, 29 Sep 2023 12:39:04 GMT

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.

Re: Salesforce Connector not available with Fabric Data Factory?

Tom_CA — Mon, 27 Nov 2023 03:30:53 GMT

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

Re: Salesforce Connector not available with Fabric Data Factory?

Tom_CA — Mon, 27 Nov 2023 03:33:40 GMT

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

Tks

Re: Salesforce Connector not available with Fabric Data Factory?

Anonymous — Tue, 30 Jul 2024 08:36:20 GMT

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