I looking for other's feedback on a solution I am working on to sync the membership of an AD group to a combination of SQL tables. The SQL tables are structured as follows:
|Slightly Important People||6|
Initially i was attempting an AD group -> SQL 'group' sync by using a custom SQL select statement to structure the data so it looks like:
I began testing powershell scripts so I can map the AD group 'member' attribute with the constructed SQL 'member' attribute. I realized between the two that performance of the solution is less than ideal on both the SQL side and on the QC side.
Has anyone solved for something similar? I'm open to any all all input. The goal is to drive group memberships in a particular SQL based app via ARS. Solving this would be a huge step forward for us. Many thanks in advance!