Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

difficulty connecting to salesforce sandbox instance

I used the Google Cloud Platform launcher to start Matillion, and I'm trying to connect it to salesforce.

There error message I get when trying to select a data source is:

INVALID_LOGIN: Invalid username, password, security token; or user locked out.

I've provided the username with the sandbox name appended, security token and password.

Is there something I'm missing? Is there some setup required on the Salesforce side to allow Matillion to connect via the API?

4 Community Answers

Matillion Agent  

Harpreet Singh —

Hi Vince,

Can you attach the screenshot of the Salesforce Query component from the job and you can hide the Security Token .


Matillion Agent  

Kalyan Arangam —

This is an old ticket but worth leaving a note on available options.

The salesforce component supports a UseSandBox property which can be set to true. This property can be found under ‘Connection Options’ in the properties for the salesforce component.


Sinae Hong —

I am also having the same issue. I am using the Salesforce Query Component and I have put in my correct username, password, and security token and am given the same invalid login error as Vince. Is there any other configs that need to be done on the Salesforce side?

Any help on this would be appreciated.

Sinae Hong —

Actually, I was able to connect, so please disregard my question.

Post Your Community Answer

To add an answer please login