Meltano

Has anyone successfully used the Oracle-target with an encrypted wallet?  In theory it should work because you can pass the sqlalchemy connect string, but I get a password required error with it.

I feel like we've had someone asking about the same thing. Let me do a quick search in <https://meltano.linen.dev/>...

Oh, I think it was you asking something related :sweat_smile:

<https://www.linen.dev/s/meltano/t/22794752/my-team-is-working-on-getting-the-oracle-tap-working-with-an#df59fd43-2dff-4a75-b5e1-b957971b3541>

So, how are you passing the SQLAlchemy URL, and are passing other settings besides the URL?

The other settings aren't relevant if you pass the URL.  The if statement  in the target url create function skips the other params if the SQLAlchemy URL is provided

this is the URL we use
`"oracle+cx_<oracle://USER@PROXY_USER>"`
The Meltano container has $TNS_ADMIN set up and the wallet, tns names, and sqlnet.ora are in that location

That looks right according to <https://docs.sqlalchemy.org/en/20/dialects/oracle.html#connections-with-tnsnames-ora-or-oracle-cloud>.

What's the error message you're seeing?

cx_Oracle.DatabaseError: ORA-01005: null password given; logon denied

This may be relevant?

<https://cx-oracle.readthedocs.io/en/latest/user_guide/connection_handling.html#install-the-wallet-and-network-configuration-files>