DATA Step, Macro, Functions and more

LDAP Query

Not applicable
Posts: 0

LDAP Query


We need to build a table in our data warehouse that contains all of our employees, their network logon IDs, their manager, etc. We would like to use the information in our Active Directory application to populate these tables.

Does anyone have any idea how to connect to an LDAP server, execute a query and store the results?

Thanks all!

Super Contributor
Super Contributor
Posts: 3,176

Re: LDAP Query

Posted in reply to deleted_user
I believe this topic is discussed on the SAS support website - a link to the white paper is provide as well as the SAS DOC reference.

Case Study in Synchronizing Identities in the SAS®9 Metadata Server with an Enterprise Security Provider
This case study highlights the advantage of importing user and group information from an enterprise security provider, such as the Microsoft Active Directory. SAS provides macros that can be integrated with scheduling and other tools to synchronize SAS metadata repository identities with the enterprise Lightweight Directory Access Protocol (LDAP) environment.

Referenc within paper:

SAS Institute Inc. 2006. "Appendix 2. Bulk Load Processes for Identity Management". SAS® 9.1.3 Intelligence
Platform: Security Administration Guide, Second Edition. Cary, NC: SAS Institute Inc. Available

Scott Barry
SBBWorks, Inc. - tech papers
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation