Creating the HR Database MA

Creating the HR Database MA


You want to get employee records from the HR Database into MIIS so that they can be used as the source for new accounts in AD.


You need to start by creating an MA for the HR Database. Refer to (12) in Figure 23-2.

  1. Open Identity Manager.

  2. Click the Management Agents button on the toolbar.

  3. In the Actions pane on the right, click Create.

  4. In the Create Management Agent Designer, select SQL Server 7.0 or 2000 from the "Management Agent for" drop-down list.

  5. Type HR Database into the Name text box.

  6. Type a description in the Description fieldthis is where you can be creative.

  7. Click Next.

  8. In the Connect to Database pane on the right side:

    1. Type in the SQL server name in to the Server Name text box.

    2. Type the name of the database in the Database text box.

    3. Type the name of the table or view that contains the employee records in the Table/View text box.

    4. Leave the Delta View and Multivalue Table text boxes blank.

    5. Select the radio button for the type of authentication the SQL Server is set up to use.

    6. Fill in the User Name, Password, and Domain text boxes with the credentials of a user that has permissions to read and update the table we will read.

  9. Click Next.

  10. On the Configure Columns page:

    1. Click the Set Anchor button. This will display the Set Anchor dialog box.

    2. In the Set Anchor dialog box, select Badge Number and press the Add button.

    3. Click OK to save the anchor attribute definition.

  11. On the Configure Connector Filter page, click Next.

  12. On the Configure Join and Projection Rules, click Next.

  13. On the Configure Attribute Flow page, click Next.

  14. On the Configure Deprovisioning page, click the "Make them disconnectors" radio button in the lefthand pane.

  15. Click Next.

  16. In the Configure Extensions page, click Finish.


Following these steps will create a SQL Server management agent. Associated with the MA is a namespace known as the connector space. MIIS will store the data from the relevant columns of the HR Database here and use them to provision, synchronize, and de-provision user accounts in Active Directory. Creating the HR Database MA is the first of several steps to get the data into MIIS. You should now see a Management Agent in the Management Agent pane of the Identity Manager with the name and comments displayed.

See Also

Recipe 23.2 for more on creating the HR database MA

 Python   SQL   Java   php   Perl 
 game development   web development   internet   *nix   graphics   hardware 
 telecommunications   C++ 
 Flash   Active Directory   Windows