Share via

Error while connecting to Salesforce using ADF

Babulal Ram 1 Reputation point
2021-06-06T14:33:25.81+00:00

I'm trying to access salesforce through Azure Data Factory by creating linked service and I'm seeing error as: ERROR [HYOOO] [Microsoft][Salesforce] (148) INVALID_LOGIN: Invalid username, password, security token; or user locked out.

Steps followed:

  1. Added Copy data to the pipeline
  2. Selected Salesforce as new data set for copy data - source
  3. Integration Runtime, tested with both Azure's AutoResolveIntegrationRuntime and Self hosted Integration Runtime but no luck
  4. Environment URL as https://something.salesforce.com
  5. username as something@something .com, password and security token.
  6. API version is kept as Default

NOTE: I am able to login to salesforce successfully through browser using custom login/company login and authentication is passed via Microsoft login page.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Stefano Peroli 6 Reputation points
    2021-06-06T15:25:38.297+00:00

    Hi,
    Are you sure that your user has the right privilege to use the Salesforce REST API?
    Have you tried to connect to workbench (https://workbench.developerforce.com/login.php) to test your privilege?

    Hope it helps.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.