search

datadudes / salesforce2hadoop

Import Salesforce data into Hadoop HDFS in Avro format
23 stars 13 forks source link

Using the connector on Salesforce sandbox #7

Closed AmritaKv closed 8 years ago

AmritaKv commented 8 years ago

Hi I am trying to use the salesforce2hadoop connector in the salesforce sandbox as opposed to production. Is there any way to specify that it is a sandbox?

The wsdl I am using has SOAP location as sandbox like

But When in the source code file SalesforceService.scala (apply method line 52) I see the end point being hard coded as https://login.salesforce.com/services/Soap/u/$apiVersion , so it is always going to hit the production env where I don't have access and Hence when I try to use the init command I get error as,

Exception in thread "main" [LoginFault [ApiFault exceptionCode='INVALID_LOGIN' exceptionMessage='Invalid username, password, security token; or user locked out.' ] ]

DonDebonair commented 8 years ago

Hi @AmritaKv! Thanks for trying the connector. I'm sorry it doesn't work for you. The quickest solution for now would be to change the hardcoded url to your sandbox url and build the project again (sbt assembly should do the trick). In the meanwhile, I will see if I can add a parameter for the base url!

DonDebonair commented 8 years ago

Update! @AmritaKv I've released a new version that will let you configure the base url of the Salesforce instance you want to talk to. You can download it here.

Usage: java -jar sf2hadoop.jar -a login.of.sf.sandbox.com (and obviously all the other options you want/need to set)

Let me know if that solves your problem!

AmritaKv commented 8 years ago

oh , you are the best !! thank you for the quick reply...it did solved my problem but got another error same as the other issue that you closed earlier (DatasetNotFoundException - salesforce2hadoop #4)...