We are running Dremio 3.3.2 on CentOS in the AWS cloud. Today, I tried to add a new data source for the Salesforce instance. The ARP Salesforce connector is installed, together with Progress Software’s JDBC driver. In the /opt/dremio/jars/3rdparty, I created a symlink to the sforce.jar file, sitting in /opt/Progress/DataDirect/JDBC_60/lib. When configuring the data source, I receive the error “Failure while configuring source …”, and in the server log, Dremio complains as follows:
Caused by: java.lang.IllegalArgumentException: String ‘cdata.jdbc.salesforce.SalesforceDriver’ does not denote a valid java.sql.Driver class name.
at com.dremio.exec.store.jdbc.DataSources.newGenericConnectionPoolDataSource(DataSources.java:60) ~[dremio-ce-jdbc-plugin-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]
at com.dremio.exec.store.jdbc.conf.SalesforceConf.newDataSource(SalesforceConf.java:97) ~[dremio-salesforcearp-plugin-3.2.4-201906051751050278-1bcce62.jar:3.3.2-201908142136370993-d60145d]
at com.dremio.exec.store.jdbc.JdbcStoragePlugin.start(JdbcStoragePlugin.java:387) ~[dremio-ce-jdbc-plugin-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]
at com.dremio.exec.catalog.ManagedStoragePlugin$1.run(ManagedStoragePlugin.java:257) ~[dremio-sabot-kernel-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]
at com.dremio.concurrent.RenamingRunnable.run(RenamingRunnable.java:36) ~[dremio-common-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]
at com.dremio.concurrent.SingletonRunnable.run(SingletonRunnable.java:41) ~[dremio-common-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]
at com.dremio.concurrent.SafeRunnable.run(SafeRunnable.java:40) ~[dremio-common-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]
at com.dremio.concurrent.Runnables$1.run(Runnables.java:45) ~[dremio-common-3.3.2-201908142136370993-d60145d.jar:3.3.2-201908142136370993-d60145d]
Caused by: java.lang.ClassNotFoundException: cdata.jdbc.salesforce.SalesforceDriver
I wonder why is it looking for the cData driver? Is there a configuration setting for the connector that has to be changed?
Thank you in advance.