A consolidated set of links to my How-To articles as well as some tools I’ve written to help interface with LDAP servers.
How to use DBMS_LDAP
- Introduction
- Establishing a Connection
- Searching Hierarchical Data
- Browsing Attributes
- Timeouts
- Modifying Data
Configuring LDAP for TNS Name resolution
- Setting up OpenLDAP on Oracle Linux 8 for TNS name resolution
- Managing TNS lookups in OpenLDAP via PL/SQL – original Post describing SDSOID
Using LDAP TNS name resolution with Oracle clients
Connection Basics – covers multiple methods of connections, including LDAP usage in the Oracle clients and JDBC.
Using LDAP with JSON and SQL
Published for #JoelKallmanDay 2021 the LDAP to JSON function allows querying an LDAP server and retrieving the results as a JSON object. The LDAP_DN object type, creates a sortable object from a given a DN string based on the hierarchy which is backwards for text-based sorting.