Importing a Human Resources Database into Microsoft Identity Manager - MIM #7 скачать в хорошем качестве

Importing a Human Resources Database into Microsoft Identity Manager - MIM #7

I don't claim to be a SQL expert but we get our fingertips wet with some SQL queries, stored procedures, and SQL Agent Jobs to create an AI database from our Human Resources database. Using this method, I find is a good way to aggregate all the fields from many tables, databases or even servers into one location so Microsoft Identity Manager can have a "one-stop Management Agent". This is not the only method you could use, and this wouldn't work if you need to update or export to your Human Resources database. I speak about this in the video but I adapted this idea from a gentleman named Søren Granfeldt. He is the creator of the PowerShell Management Agent. You can check out his blog here: https://goo.gl/frRDhw. I specifically got this idea from his SQL Sample Scripts for use with his PowerShell MA. 00:00 - Intro 00:22 - Reviewing our mock HR database 02:39 - Creating a SQL query to gather columns for our Management Agent 16:13 - Sharing my adaptation and thoughts of an AI DB 17:51 - Creating our AI DB 20:30 - Creating and scheduling our update people stored procedure 26:06 - Creating our AI Management Agent 28:03 - Modifying our existing AD synchronization rule 29:10 - Creating our AI synchronization rule 31:04 - Modifying the Employee Type validation in the MIM Portal 32:30 - Synchronizing all of our changes 37:36 - Outro