Support Questions

Find answers, ask questions, and share your expertise

Apache Nifi to Oracle ATP

avatar
New Contributor
Hi

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:

x2LyW

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?)

1 REPLY 1

avatar
New Contributor

I am facing similar issue. Has anyone found a way resolve this.

 

Looking forward for help!!