Re: Accessing AD/ADAM from SQL
- From: "Joe Kaplan \(MVP - ADSI\)" <joseph.e.kaplan@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 21 Aug 2006 12:09:07 -0500
Microsoft makes a product for doing this type of directory integration
called MIIS. It is definitely worth a look.
If you want to code stuff yourself, the basic APIs for AD are LDAP API and
ADSI, which is a higher level abstraction layer over LDAP designed for COM
and scripting languages. There are also .NET options for ADSI
(System.DirectoryServices) and raw LDAP
(System.DirectoryServices.Protocols).
If you want write access to AD, you'll need to use ADSI, LDAP or an
equivalent, not the linked query stuff that allows you to pull AD data into
SQL. That provider is read-only. You could still host all that code in SQL
if you wanted, or place it in an external batch process or script. There
are lots of options, depending on your skills and interests.
Joe K.
--
Joe Kaplan-MS MVP Directory Services Programming
Co-author of "The .NET Developer's Guide to Directory Services Programming"
http://www.directoryprogramming.net
--
"Harvey" <harvey_b@xxxxxxxxxxx> wrote in message
news:pfOdncY-VOuPIHTZnZ2dnUVZ_oWdnZ2d@xxxxxxxxxxxxxx
Hi All:
First, let me state my qualifications - or lack thereof. I am not a
programmer and although I handle sql scripting to a certain level, I'm far
from being a sql developer.
That being said, I'm looking for some guidance on how to do a few things
to manipulate the info stored in AD (modifications) and to query AD to
pull information for building sql scripts.
Here are some basic descriptions of what I need to do.
In some cases the AD information is missing essential information (i.e.,
employeeID) that is stored in a database. I want to pull that info from
thw database and generate a script that will update the employeeID field
(property?) for the individual.
To update the sql database, I need to query AD to pull a piece of info
(i.e, userPrincipalName) to generate the sql update script.
Any info/guidance/links/docs, etc. you can provide that will help me get
there would be appreciated.
Thanks!
Harvey
.
- References:
- Accessing AD/ADAM from SQL
- From: Harvey
- Accessing AD/ADAM from SQL
- Prev by Date: Re: Rename Global Group
- Next by Date: Re: Rename Global Group
- Previous by thread: Accessing AD/ADAM from SQL
- Next by thread: Re: Empty Root Domain required?
- Index(es):
Relevant Pages
|
