difficulty connecting to salesforce sandbox instance
Vince Gonzalez — Aug 24, 2017 05:42PM UTC
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?
Harpreet Singh —
Aug 24, 2017 06:43PM UTC
Can you attach the screenshot of the Salesforce Query component from the job and you can hide the Security Token .
Kalyan Arangam —
Dec 05, 2017 11:34AM UTC
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 —
May 08, 2018 05:47PM UTC
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 —
May 08, 2018 06:03PM UTC
Actually, I was able to connect, so please disregard my question.
Post Your Community Answer
To add an answer please