AnsweredAssumed Answered

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

Question asked by Nilesh Purohit on Aug 14, 2018
Latest reply on Aug 16, 2018 by Nilesh Purohit

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)

Outcomes