This is an example where I used SSIS to solve a problem where the data structure in the data source did not meet the requirements of FIM. I then used SSIS to transform the data into a structure easily used by FIM.
The information in this case was defined in a database with two tables, of which one table contained information about the organizational units within the company.
The other table contained information about the roles users had within each organizational unit. The screenshots are just showing an example and are not the actual roles and units that my customer was using.
The goal was to create groups in Active Directory with the users as members. But they didn't just want the organizational units as groups. They also wanted one group for each unique role within a specific organizational unit.
So the goal was to use SSIS to structure this data into the FIM-optimized structure you have seen in the HR database at The Company in this book.
From the small...