The Job described below simply filters the LDAP directory and displays the result on the console.
Drop the tLDAPInput component along with a tLogRow from the Palette to the design workspace.
Set the tLDAPInput properties.
Set the Property type on Repository if you stored the LDAP connection details in the Metadata Manager in the Repository. Then select the relevant entry on the list.
In Built-In mode, fill in the Host and Port information manually. Host can be the IP address of the LDAP directory server or its DNS name.
No particular Base DN is to be set.
Then select the relevant Protocol on the list. In this example: a simple LDAP protocol is used.
Select the Authentication check box and fill in the login information if required to read the directory. In this use case, no authentication is needed.
In the Filter area, type in the command, the data selection is based on. In this example, the filter is:
Fill in Multi-valued field separator with a comma as some fields may hold more than one value, separated by a comma.
As we do not know if some aliases are used in the LDAP directory, select Always on the list.
Set Ignore as Referral handling.
Set the limit to 100 for this use case.
Set the Schema as required by your LDAP directory. In this example, the schema is made of 6 columns including the
uid columns which get filtered on.
In the tLogRow component, no particular setting is required.
Only one entry of the directory corresponds to the filter criteria given in the tLDAPInput component.
For an example of the use of dynamic schemas in Input components, see Scenario 4: Writing dynamic columns from a MySQL database to an output file.