Apache Nifi Oracle JDBC configuration

1.4k Views Asked by At

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 :

enter image description here

1

There are 1 best solutions below

1
Vikramsinh Shinde On

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.

enter image description here