I am reviewing ETL tools that allows one to interact with SalesForce and extract data stored in it.
The tool I am trying out at this time is Talend, the hugely popular and capable Open Source Data Integration Tool.
I ran into an error and here is what the error looks like:
Connection failure. You must change the connection settings. LOGIN_MUST_USE_SECURITY_TOKEN: Invalid username, password, security token; or user locked out. Are you at a new location? When accessing Salesforce--either via a desktop client or the API--from outside of your company’s trusted networks, you must add a security token to your password to log in. To receive a new security token, log in to salesforce.com at http://login.salesforce.com and click Setup | My Personal Information | Reset Security Token.
How did we get here?
Let us quickly review how we got here.
- We chose Salesforce from the list of metadata.
- Entered the connection parameters
- Entered username
- Entered password
- Clicked on the Login button
List of Metadata
Connection Parameter – Error Message
Connection Parameter – Error Message – Detailed
Here is our remediation steps:
- Access our Salesforce portal
- Request a token
- Token Sent via email
- Sample Token
- Enter the token as part of our password
Access Salesforce Portal
The current URL is https://login.salesforce.com/index.jsp
Upon successful connection, the screen that appears is the Forcecom Home Page.
And, here are the steps:
- On the Home Page, in top pane, by your name, choose the “My Settings” option
- On the “My Settings” page, choose the “Edit my personal information” option
- On the “Personal Information”, from the left pane, choose “Reset my security token” option
Edit my personal information
SalesForce sends token
The Salesforce system sends the token, wait a few minutes to receive the token
Here is what a sample token looks like:
Dear Daniel Adeniji, When accessing Your Developer Edition from outside of your company’s trusted networks using a desktop application, you must add a security token to your password to log in. If your password is "mypassword" and your security token is "XXXX" you must enter "mypasswordXXXX" in place of your password. Your new case-sensitive security token is below: User Name: email@example.com Security Token: MSNYGF31YJ17162514UI1 New security tokens are automatically sent to you when your Your Developer Edition password is changed. You do not use a security token when logging in via a web browser. If you have any questions, please contact your administrator or us at firstname.lastname@example.org Salesforce Developers developer.salesforce.com
Let us return to Talend and add the received token to the password entry field.
Here is the Original Screen with only the few characters that encompass our password.
Here is the revised screen with the password and security token, entered in the password textbox.
Listening to a couple of tracks from Bethel Music: