Synchronizing LDAP Users and Groups

The sdb-admin sync-ldap tool (or simply the "LDAP tool") imports users and groups from Lightweight Directory Access Protocol (LDAP) implementations, such as Active Directory into SingleStore DB. It also helps automatically synchronize the LDAP-implemented directory users and groups with SingleStore DB and thereby manage users in a central location.

The LDAP tool provides a one-way user and group synchronization from any LDAP directory to SingleStore DB. The LDAP server does not need to be modified in any way. It also manages LDAP user-group relationships in SingleStore DB. However, it does not create or manage SingleStore DB roles and privileges, which are internally managed in SingleStore DB.


The LDAP tool uses LDAP protocol version 3. It can be used with LDAP implementations with or without Single Sign-On (SSO) support.