Base DN

ou=people,dc=internet2,dc=edu

LDAP filter for browser

givenName=A*

LDAP filter for loader

(givenName=A*)

Attributes

employeeNumber,givenName

Create table

create table ldap_a_names
(employee_number varchar(20) not null,
 first_name varchar(100) not null,
 CONSTRAINT ldap_a_names_pk
   PRIMARY KEY (employee_number));

Table name

ldap_a_names

Columns and attributes

employee_number -> employeeNumber
first_name -> givenName

SQL query

select concat('ref:iam:aNames:', first_name) as group_name, employee_number as subject_id, 'eduLDAP' as subject_source_id from ldap_a_names

Cron

17 28 6 * * ?

Groups like sql part

ref:iam:aNames:%
  • No labels