Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 Usernam...
data engineering
lakehouse
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    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.

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

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