Salesforce Connection Issue with pentaho Kettle

 If you are trying to connect salesforce with pentaho in order to fetch/insert/update data and you might can face the error 

Error:

Failed : API security token required

 

Problem :

You might be entering wrong token along with your password, or your you havn't generated token

Solution :

Generate Token at saleforce side, or change the security token if you forgot the previous token

Issue with Starting Launch Spoon.bat Kettle

 Have you installed multiple java version on your machine

have you set Java_Home in environment variable other version, but you need another version

Have you fed up of changing environment variable

Support you have below software

• Java JDK 1.6  (Set as Environment Variable)
  
• Java JDK 1.8
• Pentaho Kettle 9

Since pentaho kettle is compatible with JDK 1.7 and above, here i was unable to launch spoon.bat file cause of another JAVA_HOME variable set in my machine.

So In Order to solve this create another bat file, which need to launch instead of spoon.bat file.

Set local
set PENTAHO_JAVA_HOME=C:\Program Files (x86)\Java\jdk1.8.0_281\
Set KETTLE_HOME=E:\Petaho\data-integration\
spoon.bat %*

I have placed ETL extract folder @ E:\Petaho\data-integration\ and i created new file spoon1.bat in same folder as above and add above 4 lines in file.

Now double click on spoon1.bat file instead of spoon.bat.