I am trying to connect to an Oracle database on Oracle Cloud, which requires the use of an SSL wallet + TNS names. I've set up Nifi in docker, and however I'm not able to connect to the database. I've tested connectivity to the database using the SSL wallet and Oracle instant client and I am able to connect from the docker guest, but not from Nifi.
I've followed the instructured at https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-jdbc-thin-wallet.html
And the settings for the DB connection pool in Nifi looks like this:
However I get the error that it isn't able to resolve the TNS name.
Could someone advise on how to connect from Nifi to Oracle ATP (or any Oracle database using an SSL wallet?)
... View more