Sample Header Ad - 728x90

How to connect to Oracle through LDAP with Ruby on Rails 5.4.2?

0 votes
0 answers
103 views
My application is running on Rails 5.4.2/Ruby 2.7 and relies on an Oracle 19c. I used to query an Oracle database through a classical OCI connection configuration: **config/database.yml** development: adapter: oci host: xe username: dqm password: dqm_password But the organisation's IT architecture has changed, so that connections should now go through LDAP for security reasons. The URL looks like this : jdbc:oracle:thin:@ldap://intranet.oid-01.dama.ch:3063/EDWHPD,cn=OracleContext,dc=emea,dc=dama,dc=ch I don't know how to handle this with Rails, and it raises several questions for me: * How to describe this connection in the **database.yml** file? * Should I use the Net-LDAP gem, and what would it bring to help establishing the connection to Oracle database? * Do you know a tutorial explaining how to setup this type of database access? Thank you for your help!
Asked by user1185081 (133 rep)
Nov 9, 2022, 10:30 AM