Salesforce Connector in Fabric - How to connect using a custom user/password

[rajper02]

Hello,

I am very new to Fabric and I am trying to ingest some Salesforce data into OneLake. When I setup the Connection for the Salesforce objects I don't see an option where I can supply an Username and Password. The SignIn button is automatically trying to sign me in with my Username and it fails because my credentials don't exist in our Salesforce database. We have been given a service username (and password) by our Salesforce admin.

What's the right way to set this Salesforce connection so that we can use a generic/common username/password.

Thank you,
Rajesh

[v-csrikanth]

Hi @rajper02 
I wanted to follow up on the above question posted. Did you got chance to ttry the suggeted solution?
If the issue has been resolved, can you mark the post as resolved.

please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.

Best Regards,
Community Support Team _ C Srikanth

[v-csrikanth]

Hi @rajper02 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @rajper02 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered.
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.

Best Regards,
Community Support Team _ C Srikanth

[v-csrikanth]

Hi @rajper02 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth · Accepted solution]

Hi @rajper02 
Thanks for reaching out to Microsoft Fabric Community Forum.
As highlighted by @nilendraFabric, the documentation in the image confirms that the Salesforce Objects connector in Microsoft Fabric supports only Organizational Account authentication for both Copy and Dataflow Gen2.
This aligns with the statement that OAuth 2.0 is the only available authentication method, and manually entering a custom username and password is not supported.

Note Reference link: https://learn.microsoft.com/en-us/fabric/data-factory/connector-salesforce-objects 

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.

Best Regards,
Community Support Team _ C Srikanth.

[nilendraFabric]

Hello @rajper02 

Connecting Salesforce to Microsoft Fabric using a username/password with a service account is not directly supported by the native Salesforce connector, which primarily relies on OAuth 2.0 for secure authentication