Convert SQL Query results to Active Directory Groups
- by antgiant
Are there any quality products (ideally open source) that allow me to run an arbitrary SQL query that results in 2 columns (username, group name) and they adds that username in AD to a group of that name in AD?  If the username doesn't exist it is ignored.  If the group name doesn't exist ideally it gets created.
Updated for Clarity:
I have a MSSQL based system that is the authoritative source for some of the Active Directory Security groups, and their members.  I want to be able to to have those Active Directory Security Groups populated by a one-way sync originating from MSSQL.  Sadly the MSSQL based system does not have a good API, so I will have to do this with direct SQL calls.  Is there anything that does this well?