Forum Discussion
Salesforce Connector in Fabric - How to connect using a custom user/password
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
Hi Anonymous
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.
6 Replies
- nilendraFabric
Super User
Hello Anonymous
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
- v-csrikanth
Community Support
Hi Anonymous
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. - v-csrikanth
Hi Anonymous
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 Anonymous
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 Anonymous
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 Anonymous
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
