use Oracle wallet to connect via node?

bpjones

I'd like to use an Oracle wallet in lieu of hardcoding the user ID and password in my javascript or config files.  I have tried dropping the user and password parameters from the connect and simply using a connection string in this format ="/@db_alias" but am not able to log in.  I get an error about invalid username and password.  Has anyone else been successful in using a wallet to authenticate with the node module?

bpjones

I figured this out... I enabled external authentication and left the connection = to the db_alias without a slash or @.

bpjones

I figured this out... I enabled external authentication and left the connection = to the db_alias without a slash or @.

Christopher Jones-Oracle

The doc is https://github.com/oracle/node-oracledb/blob/master/doc/api.md#extauth

On re-reading I can see where improvements can be made.

b2b32770-e532-4b1f-b3c7-38dbc3ae0ad1

Thanks, It has solved my issue to connect Oracle using SSIS 2008/2012 through Wallet authentication.

I used below steps:

Use ADO.NET Connection " Provider = .Net Providers\OracleClient Data Provider

Server Name = "Wallet Alias" (With out "/@")

In ALL Section

Integrated Security = True

Test Connection Succeeded

Regards,

Sunil