Pentaho

 View Only

 Why Salesforce input SOQL query is not connecting

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Olubunmi Balogun's profile image
Olubunmi Balogun posted 05-28-2020 21:48

I entered few columns in the SOQL of Salesforce Input so I can put data from Salesforce but came up with this Connection error:

 

Incompatible type 'class com.sforce.soap.partner.QueryResult' specified as xsi:type. It must be a subclass of 'class com.sforce.soap.partner.QueryResult'

 

I have researched online for solutions to the error but I have found none.


#Pentaho
#PentahoDataIntegrationPDI
#Kettle
Brandon Jackson's profile image
Brandon Jackson posted 07-05-2020 17:13

That indicates a bug in the plugin providing that step. I would recommend you download the cdata.com JDBC driver for the same. The $1k that you'll spend, is a better trade for dealing with all the frustrating parsing and curl tricks you may end up with if that step cannot be fixed.

Related Content