BI Publisher supports queries against Lightweight Directory Access protocol (LDAP) data sources.
You can query user information stored in LDAP directories and then use the data model editor to link the user information with data retrieved from other data sources.
For example, to generate a report that lists employee salary information that is stored in the database application and also include employee e-mail addresses that are stored in the LDAP directory in the report, you can create a query against each and then link the two in the data model editor to display the information in a single report. The figure below shows a sample LDAP query.
Search Base is required when the LDAP provider is Microsoft Active Directory. The Search Base defines the starting point of the search in the directory tree. For example, if you want to query the entire directory, specify the root.
To specify the starting point, enter each hierarchical object separated by a comma, starting with the lowest level in the hierarchy, for example, to search the Sales container in the mycompany.com domain, enter:
LDAP search filters are defined in the Internet Engineering Task Force (IETF) Request for Comments document 2254, "The String Representation of LDAP Search Filters," (RFC 2254). This document is available from the IETF Web site at