Don’t forget to get the salesforce.com Security Token!
Posted by Richard Weck on Mon, Jun 06, 2011
Today I had my first opportunity to work with the new Scribe template that migrates data from Salesforce.com to Microsoft CRM online. During the importation of the template into the Scribe console, I was required to populate a login panel with the username and password of an administrative SFDC user.
When I put in the username and password to Salesforce.com, I would get the following error:
Error opening data source SFDCAdapter.Database (https://login.salesforce.com/services/Soap/u/18.0).
...and if I clicked next, I would see…
Login Failed. Response is not well-formed XML.
After scouring the help file in the Scribe Salesforce.com adapter, I saw a comment that I needed to append the Salesforce.com security token to the end of my password. Not being terribly proficient in Salesforce.com, I found a link that I could use to reset the security token for my account. Apparently the security token is needed when an application is going to use the Salesforce.com SDK from outside the company network (like Scribe). This was the case for me since I was working on behalf of my client.
I clicked on the link to send me a new token and moments later I had the token in my email. Once I appended the token to the end of my password in the login dialog, I was finally able to get connected and begin to work on the migration.
I hope this helps someone else as this was not very apparent to me when I started. Lessons learned!
Until next time,
Happy Coding!