We have a need for Salesforce Connectivity. We use R Studio professional drivers, which work just fine for our MSSQL and Oracle needs. However, we are having no luck with our Salesforce connection, keep getting:
Error: nanodbc/nanodbc.cpp:1021: 00000: [RStudio][Salesforce] (148) INVALID_LOGIN: Invalid username, password, security token; or user locked out.
The documentation is ... minimal, which I suppose is OK. But now I wonder, are there other necessary configuration steps I'm missing? I've asked the Salesforce Admin, they say 'all's good bro'. The only other possible thing I'm wondering is if the 'account' name I'm using is subtly different from what they gave me, which looks like:
Well, any tips appreciated, sure would like to use this but not finding much info
Docs I'm looking at are: Salesforce