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 :
Asked
Active
Viewed 851 times
0
Barbaros Özhan
- 59,113
- 10
- 31
- 55
Melvin Santhosh
- 1
- 1
-
driver class name: oracle.jdbc.OracleDriver. Then the location should point to your ojdbc8.jar file. – Jean de Lavarene Jul 06 '22 at 12:32
1 Answers
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.
Vikramsinh Shinde
- 2,742
- 2
- 23
- 29
-
1No need to obscure the ip, host name, DB user etc., you can rather use generic naming styles everybody can encounter everywhere... – Barbaros Özhan Jul 07 '22 at 10:57