DZone Database Zone
Querying AD in SQL Server via LDAP Provider
I recently needed to import some additional user data via a nightly run into a SQL Server database. The base user data came from a SAP database via a CSV bulk import. But not all of the data. For example, the telephone numbers are maintained mostly by the users itself in the AD. After the SAP import, we need to update the telephone numbers with the data from the AD.
The bulk import was done with a stored procedure and executed nightly with an SQL Server job. So it makes sense to do the AD import with a stored procedure, too. I wasn't really sure whether this would work via the SQL server.
No comments:
Post a Comment