Skip to end of metadata
Go to start of metadata

LDAP (Lightweight Directory Access Protocol) is a protocol that allows you to search and update a directory. It is supported by numerous directory servers such as Microsoft Active Directory and Netscape Directory Server. A directory usually contains information about users and network resources, but can contain any kind of data.These functions allow scripts and transformations to connect to a directory using LDAP.

The use pattern follows these steps:

For searching, you can follow this pattern:

  • LDAPConnect():  Establishes a connection to the server
  • LDAPSearch():  Executes the search on the server and returns the result

Setting LDAP Passwords Programmatically

As of Harmony version 9.9, LDAP passwords can be set using these LDAP functions. The password needs to first be converted to binary before it can be set. This script fragment shows how this could be accomplished:

LDAPConnect("<TAG>Project Name/Targets/LDAPTarget</TAG>");
$plain = "J1tterb1t!@#";
$pwd = StringToHex($plain);
$i=0;
$newPwd = "";
While($i < Length($pwd)/2,
    $newPwd = $newPwd + Mid($pwd, $i * 2, 2) + "00";
    $i = $i+1;
);
$newPwd = HexToBinary($newPwd);

LDAPReplace("unicodePwd", $newPwd);
LDAPExecute("CN=wright,CN=Users,DC=company,DC=example,DC=com");


ArrayToMultipleValues

Declaration

string ArrayToMultipleValues(array arr)

Syntax

ArrayToMultipleValues(<arr>)

Required Parameters

  • arr: An array with values to be used to populate a multiple-valued LDAP attribute

Description

Signals that an array should be used to populate a multiple-valued LDAP attribute when mapping to an LDAP target. The array is converted to XML and interpreted when the LDAP server is written to.

Examples

// Create two LDAP attributes using an array
arr = Array();

// Length(arr) will always return the index of
// the next-after-last element of an array
arr[Length(arr)] = "First instance";
arr[Length(arr)] = "Second instance";

// The array will be converted to the string 
// "<JB_Array><it>First instance</it><it>Second instance</it></JB_Array>"
result = ArrayToMultipleValues(arr);

LDAPAdd

Declaration

bool LDAPAdd(string ldapType, string ldapValue)

Syntax

LDAPAdd(<ldapType>, <ldapValue>)

Required Parameters

  • ldapType:  The LDAP record or attribute type
  • ldapValue:  The value to be added for the type

Description

To use this function, the LDAPConnect() function must first be used to establish a connection with the LDAP directory.

After a connection is established, the LDAPAdd() function is used to add entries and attributes to the connected LDAP directory. The value is added to the node specified in the LDAPExecute() function, which should be called immediately afterwards to have the changes take effect.

Examples

// Adding a user entry to a directory:
LDAPAdd("objectClass", "user");
LDAPAdd("cn", "wright");
LDAPExecute("CN=wright,CN=Users,DC=company,DC=example,DC=com");

// Adding attributes to a user:
LDAPAdd("description", "Thinks a lot.");
LDAPExecute("CN=wright,CN=Users,DC=company,DC=example,DC=com");

LDAPConnect

Declaration

bool LDAPConnect(string ldapEndpointId)
bool LDAPConnect(string hostname, string user, string password[, int mode, long port])

Syntax

LDAPConnect(<ldapEndpointId>)
LDAPConnect(<hostname>, <user>, <password>[, <mode>, <port>])

Required Parameters

  • ldapEndpointId: (First form) An LDAP source or target in the current project
  • hostname: (Second form) Hostname of an LDAP server to connect to; can include a port, such as directory.example.com:10389
  • user: (Second form) User name to connect to the LDAP host
  • password: (Second form) Password to use to connect to the LDAP host

Optional Parameters

  • mode: (Second form) Connection mode; one of:
    • 0: Non-secure connection; default port: 389
    • 1: Secure connection; default port: 389
    • 2: Secure connection using LDAP over SSL; default port: 636
  • port: (Second form) Port to use to connect to the LDAP host (-1 indicates to use the default LDAP ports)

Description

Connects to a directory using LDAP. The LDAP endpoint must be either defined in the current project or specified using the second form of the command. See the instructions on inserting project items.

See also the LDAPExecute() function.

TIP: If you are using the second form of this command, use a Jitterbit project variable to store the password in a secure manner that will not be visible when the script is being viewed.

Examples

// Connects to an LDAP Target
connected = LDAPConnect("<TAG>Project Name/Targets/LDAPTarget</TAG>");

// Connects to an LDAP server using hostname:port, username, password, mode
connected = LDAPConnect("directory.company.example.com:10389", "admin", $adminpassword, 0);

LDAPDeleteEntry

Declaration

bool LDAPDeleteEntry(string distinguishedName)

Syntax

LDAPDeleteEntry(<distinguishedName>)

Required Parameters

  • distinguishedName: An LDAP distinguished name to be removed from the currently-connected server

Description

To use this function, the LDAPConnect() function must first be used to establish a connection with the LDAP directory.

After a connection is established, the LDAPDeleteEntry() function is used to remove an entry specified by a distinguished name.

See also the LDAPConnect()  and  LDAPExecute()  functions.

Examples

LDAPDeleteEntry("CN=wright,CN=Users,DC=company,DC=example,DC=com");

LDAPExecute

Declaration

bool LDAPExecute(string distinguishedName)

Syntax

LDAPExecute(<distinguishedName>)

Required Parameters

  • distinguishedName: An LDAP distinguished name on the currently-connected server

Description

To use this function, the LDAPConnect() function must first be used to establish a connection with the LDAP directory.

After a connection is established, the LDAPExecute() function is used to execute one or more modifications (add, remove, replace) that have previously been specified with the  LDAPAdd() LDAPRemove() , or  LDAPReplace()  functions.

See also the  LDAPConnect() and  LDAPExecute() functions.

Examples

// Adding LDAP entries and executing them
LDAPAdd("description", "Thinks a lot."); 
LDAPReplace("telephoneNumber", "(510) 555 1000"); 
LDAPExecute("CN=wright,CN=Users,DC=company,DC=example,DC=com");

LDAPRemove

Declaration

bool LDAPRemove(string ldapType, string ldapValue)

Syntax

LDAPRemove(<ldapType>, <ldapValue>)

Required Parameters

  • ldapType: The LDAP attribute type
  • ldapValue: The value to be removed for the specified attribute type

Description

To use this function, the LDAPConnect() function must first be used to establish a connection with the LDAP directory.

Once a connection is established, the LDAPRemove() function is used to remove an attribute of a specified type and with a specified value.

If the attribute type of that value is not found, an error is thrown. See also the  LDAPConnect() and  LDAPExecute() functions.

Examples

// Removing an LDAP entry and executing it
LDAPRemove("telephoneNumber", "(510) 555-1000");
LDAPAdd("telephoneNumber", "(510) 555-2000");
LDAPExecute("CN=wright,CN=Users,DC=company,DC=example,DC=com");

LDAPRename

Declaration

bool LDAPRename(string distinguishedName, string newRDN[, string newParent, bool deleteOldRDN])

Syntax

LDAPRename(<distinguishedName>, <newRDN>[, <newParent>, <deleteOldRDN>])

Required Parameters

  • distinguishedName :  The path of the directory entry (distinguished name) to be renamed
  • newRDN:  The new relative distinguished name

Optional Parameters

  • newParent:  The distinguished name of the new parent of this entry; the default is empty
  • deleteOldRDN:  If true, the old relative distinguished name will be deleted; the default is false

Description

To use this function, the LDAPConnect() function must first be used to establish a connection with the LDAP directory.

Once a connection is established, the LDAPRename() function is used to change the distinguished name of an entry in the connected directory.

See also the  LDAPConnect() and  LDAPExecute() functions.

Examples

LDAPRename("telephoneNumber", "telephoneNumberHome");
LDAPExecute("CN=wright,CN=Users,DC=company,DC=example,DC=com");

LDAPReplace

Declaration

bool LDAPReplace(string ldapType, string ldapValue)

Syntax

LDAPReplace(<ldapType>, <ldapValue>)

Required Parameters

  • ldapType:  The LDAP record or attribute type
  • ldapValue:  The new value to be set for the type

Description

To use this function, the LDAPConnect() function must first be used to establish a connection with the LDAP directory.

Once a connection is established, the LDAPReplace() function is used to replace an existing attribute's value with a new value.

See also the  LDAPConnect() and  LDAPExecute() functions.

Examples

// Replacing an LDAP entry and executing it
LDAPReplace("telephoneNumber", "(510) 555-1000");
LDAPExecute("CN=wright,CN=Users,DC=company,DC=example,DC=com");

LDAPSearch

Declaration

string LDAPSearch(string path, string filter, int detail, string attribute1[, ... string attributeN])

Syntax

LDAPSearch(<path>, <filter>, <detail>, <attribute1>[, ... <attributeN>])

Required Parameters

  • path: The distinguished name used as the base of the search
  • filter: A query string search filter, as defined by RFC 4515
  • detail: Details to be returned:
    • 0: Pass to return a simple string that is the first attribute found that matches the filter
    • 1: Pass to return an XML representation of the search results. This can be set to a data element using the Set()  function and then accessed later using Get()  and an XPath query using the SelectSingleNode()  function.
    • 2: Pass to return a 2-dimensional array, where each row represents an LDAP entry and where the row elements are the values of the attributes. Access the elements using the  Get()  function.
  • attribute,... attributeN: An attribute to be included in the search result (in other words, the attribute you are searching for). Additional attributes can be specified; separate them by commas.

Description

To use this function, the LDAPConnect() function must first be used to establish a connection with the LDAP directory.

Once a connection is established, the LDAPSearch() function is used to search within the connected directory.

See also the  LDAPConnect() and  LDAPExecute() functions.

Controlling Jitterbit Variables

These Jitterbit variables affect the search:

VariableValue(s)Description
jitterbit.scripting.ldap.scope0Limit the scope of the query to the base-entry only

1Search all entries in the first level below the base-entry, excluding the base-entry (default)

2Search the base-entry and all entries in the tree below the base
jitterbit.scripting.ldap.include_dn_in_results

true

Include the distinguished name in the search result (default: false)
jitterbit.scripting.ldap.use_paged_searchtrueUse a paged search; useful for retrieving large result sets (default: false)
jitterbit.scripting.ldap.max_search_results n Limit the number of search results to n results; a default is usually set by the LDAP server (default unlimited: -1)
jitterbit.scripting.ldap.return_null_if_no_resultstrue

Make LDAPSearch() return null if the search does not return any results (default: false)

Examples

// Connecting to an LDAP server using a password set 
// in a global variable ("$ldapPassword") and then performing a search
LDAPConnect("directory.company.example.com", "ghvwright", $ldapPassword, 0);
directorySearchResults = LDAPSearch("CN=Users,DC=company,DC=example,DC=com",
  "(&(objectCategory=person)(objectClass=user))", 1, "name", "whenCreated",
  "description", "telephoneNumber");

Search in This Topic
On This Page

Last updated:  Apr 19, 2019