jdbc - Apache NiFi - DBCPConnectionPool cannot load database driver (Salesforce)

Question

I use NiFi to get data from SalesForce using DBCPConnectionPool component. For this purpose I use CData JDBC driver that was successfully installed. Moreover, I copied jar file to the /lib folder of NiFi (together with .lic file (license)). I read that it is not a good practice to add the driver but I tried this way too. And I configured the DBCPConnectionPool the following way. Screenshot

But it doesn't work and the error is the same: 'Can't load database driver'

I think that something is wrong with the path to the driver but I tried different ways and the error remains. Also I tried to specify another folder but it didn't work.

Please help me how to specify the path to the file correctly if I am using Widnows.

question from:https://stackoverflow.com/questions/65921657/apache-nifi-dbcpconnectionpool-cannot-load-database-driver-salesforce

Answer 1

Waitting for answers