Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
use Oracle wallet to connect via node?
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?
Best Answer
-
I figured this out... I enabled external authentication and left the connection = to the db_alias without a slash or @.
Answers
-
I figured this out... I enabled external authentication and left the connection = to the db_alias without a slash or @.
-
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.
-
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