Apache Nifi Oracle JDBC configuration

Question

I tried to connect to an Oracle server using Apache Nifi's jdbc oracle driver, but I need the precise fields to setup the processor. Help me to sort out this issue :

Answer 1

Put ojdbc6.jar or ojdbc8.jar inside lib directory of NiFi and add DBCPConnectionPool Controller Service properties as below.

If you don't have access to lib then use a custom location to keep JDBC jar, just make sure that NiFi has permissions to access this location.