Use LDAP sources and targets in a script in Jitterbit Design Studio

LDAP (Lightweight Directory Access Protocol) is a protocol that allows you to search and update a directory. It is supported by several directory servers (e.g., Microsoft Active Directory, Netscape Directory Server). A directory usually contains information about users and network resources, but can contain any kind of data.

Use LDAP with Jitterbit

To use LDAP with Jitterbit, create a transformation and open the Formula Builder:

• Select a node in the target tree.

• Click the Formula button under the tree.

• In the Formula Builder's function tree (lower left pane), scroll down to the LDAP section to find the functions you can use with LDAP:

  • LDAPAdd
  • LDAPConnect
  • LDAPDeleteEntry
  • LDAPExecute
  • LDAPRemove
  • LDAPRename
  • LDAPReplace
  • LDAPSearch

To search a directory

LDAPConnect()
LDAPSearch()

LDAPConnect("directory.finland.company.com","ghvwright","1LikesPe@ches",0)
Set( "mySearchResults",  LDAPSearch("CN=Users,DC=finland,DC=company,DC=com", "(&(objectCategory=person)(objectClass=user))", 1, "name", "whenCreated", "description", "telephoneNumber") )

To modify a directory

LDAPConnect()

One or more of:

LDAPAdd()
LDAPRemove()
LDAPReplace()

Followed by:

LDAPExecute()

LDAPConnect("directory.finland.company.com","ghvwright","1LikesPe@ches",0)
LDAPAdd("description","Thinks a lot."); LDAPReplace("telephoneNumber","(510) 555 1000");
LDAPExecute("CN=wright,CN=Users,DC=finland,DC=company,DC=com");

Use data from source tree in calls

As with all other functions, you can use data from the source tree in the calls. To do so, put the cursor where you want the source data to appear and double click on a node of the source tree in the lower right pane of the Formula Builder. A path that Jitterbit understands will be inserted at the cursor location.