https://communities.sas.com/t5/SAS-Programming/LDAP-Query/m-p/45727#M9461 Hi,<BR /> <BR /> 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. <BR /> <BR /> Does anyone have any idea how to connect to an LDAP server, execute a query and store the results?<BR /> <BR /> Thanks all!<BR /> <BR /> Ben Fri, 12 Sep 2008 19:18:58 GMT deleted_user 2008-09-12T19:18:58Z https://communities.sas.com/t5/SAS-Programming/LDAP-Query/m-p/45727#M9461 Hi,<BR /> <BR /> 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. <BR /> <BR /> Does anyone have any idea how to connect to an LDAP server, execute a query and store the results?<BR /> <BR /> Thanks all!<BR /> <BR /> Ben Fri, 12 Sep 2008 19:18:58 GMT https://communities.sas.com/t5/SAS-Programming/LDAP-Query/m-p/45727#M9461 deleted_user 2008-09-12T19:18:58Z https://communities.sas.com/t5/SAS-Programming/LDAP-Query/m-p/45728#M9462 I believe this topic is discussed on the SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> - a link to the white paper is provide as well as the SAS DOC reference.<BR /> <BR /> <SNIP><BR /> Case Study in Synchronizing Identities in the SAS®9 Metadata Server with an Enterprise Security Provider<BR /> 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.<BR /> <BR /> <A href="http://support.sas.com/rnd/papers/sgf07/sgf2007-syncmetadata.pdf" target="_blank">http://support.sas.com/rnd/papers/sgf07/sgf2007-syncmetadata.pdf</A><BR /> <SNIP><BR /> <BR /> Referenc within paper:<BR /> <BR /> RESOURCES<BR /> SAS Institute Inc. 2006. "Appendix 2. Bulk Load Processes for Identity Management". SAS® 9.1.3 Intelligence<BR /> Platform: Security Administration Guide, Second Edition. Cary, NC: SAS Institute Inc. Available<BR /> support.sas.com/documentation/configuration/bisecag.pdf<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <BR /> <A href="http://support.sas.com/rnd/papers/" target="_blank">http://support.sas.com/rnd/papers/</A> - tech papers</SNIP></SNIP> Sun, 14 Sep 2008 17:13:18 GMT https://communities.sas.com/t5/SAS-Programming/LDAP-Query/m-p/45728#M9462 sbb 2008-09-14T17:13:18Z