Look at LDAP at data to get.  Lets get uid and a translation


Make a SQL table


Configure the Grouper LDAP to SQL daemon

Note, we already have an LDAP external system to this LDAP




Run job


Config

otherJob.ldapToSqlDemo2.class = edu.internet2.middleware.grouper.app.ldapToSql.LdapToSqlSyncDaemon
otherJob.ldapToSqlDemo2.ldapSqlAttribute.0.ldapName = uid
otherJob.ldapToSqlDemo2.ldapSqlAttribute.0.sqlColumn = uid
otherJob.ldapToSqlDemo2.ldapSqlAttribute.0.uniqueKey = true
otherJob.ldapToSqlDemo2.ldapSqlAttribute.1.sqlColumn = email_address
otherJob.ldapToSqlDemo2.ldapSqlAttribute.1.translation = ${ldapAttribute__uid + '@example.com'}
otherJob.ldapToSqlDemo2.ldapSqlBaseDn = ou=People,dc=example,dc=edu
otherJob.ldapToSqlDemo2.ldapSqlDbConnection = grouper
otherJob.ldapToSqlDemo2.ldapSqlFilter = (&(uid=*)(objectClass=person))
otherJob.ldapToSqlDemo2.ldapSqlLdapConnection = personLdap
otherJob.ldapToSqlDemo2.ldapSqlNumberOfAttributes = 2
otherJob.ldapToSqlDemo2.ldapSqlSearchScope = SUBTREE_SCOPE
otherJob.ldapToSqlDemo2.ldapSqlTableName = test_ldap
otherJob.ldapToSqlDemo2.quartzCron = 0 03 5 * * ?

See data in database

  • No labels