Pentaho

 View Only

 Connecting to SalesForce API 43 from Pentaho 6.0.1.0-386 community edition

  • Pentaho
  • Pentaho
Nilesh Purohit's profile image
Nilesh Purohit posted 08-14-2018 20:27

Dear Team,

I am trying to connect to SalesForce using 'Salesforce Input'.

I gave the url (https://xxxxxxxxxxxxxxxxxxx.com/services/Soap/u/21.0)

then User-id and Pwd. Once i click test connection,  I also tried 43.0 in the above url but no luck.

I am getting the below error...

Can not connect to Salesforce with username [abcd@xyz.com]!

Please check username and password

Exceltion:

java.lang.Exception:

Error connecting to Salesforce!

; nested exception is:

java.net.ConnectException: Connection timed out: connect

at org.pentaho.di.ui.trans.steps.salesforceinput.SalesforceInputDialog.test(SalesforceInputDialog.java:1359)

at org.pentaho.di.ui.trans.steps.salesforceinput.SalesforceInputDialog.access$2000(SalesforceInputDialog.java:97)

at org.pentaho.di.ui.trans.steps.salesforceinput.SalesforceInputDialog$22.handleEvent(SalesforceInputDialog.java:1197)

at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)

at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)

at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)

at org.pentaho.di.ui.trans.steps.salesforceinput.SalesforceInputDialog.open(SalesforceInputDialog.java:1261)

at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:125)

at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8728)

at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3032)

at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:755)

at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)

at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)

at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)

at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)

at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1339)

at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939)

at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9214)

at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:653)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)


#Pentaho
John Eicher's profile image
John Eicher

Hi Nilesh,

I'd recommend you upgrade your version of Pentaho. Version 6.0.1 of Pentaho was built to use the version 21 of the Salesforce API, and won't work with anything newer than 24. Version 6.0.1 of Pentaho also suggests that you should connect through www.salesforce.com for the API which has since been deprecated: Help | Training | Salesforce

I'd recommend trying either version 7.1 or 8.1 of Pentaho and seeing if you have better luck with that.

-Chris

Nilesh Purohit's profile image
Nilesh Purohit

Thank You Chris,

Yes I tried with PDI 8.1 and it was able to connect to Salesforce API 43.

  • PDI 7.0 until 8.0 use API version 37.0.
  • PDI 8.1 and later versions use API version 41.0.