Quick Connect Sync Engine 5.5 - Administrator Guide

Scenario 2: Use a .csv file to update user accounts in an Active Directory domain

Scenario 2: Use a .csv file to update user
accounts in an Active Directory domain

This scenario demonstrates how to update user accounts in an Active Directory domain when the information on employees is changed in the Human Resource (HR) database held in a Comma Separated Values (.csv) file.

This scenario has the following steps:

• Step 1: Create an updating step
• Step 2: Run the created updating step
• Step 3: Commit changes to Active Directory

Step 1: Create an updating step

This section explains how to create a step that updates user accounts from the HR database to the target Active Directory domain.

To add an updating step to your existing workflow

1. In the Quick Connect Administration Console, open the Workflows tab, and then click the workflow you have created in Step 1: Create a workflow.
2. Click Add synchronization step.
3. On the Select an action page, select Update, and then click Next.
4. On the Specify source and criteria page, do the following:
   1. Click Specify, click Select existing connected system, and then select the Comma Separated Values (.csv) file you connected in Scenario 1: Provision users from a .csv file to an Active Directory domain. Click Finish.
   2. Make sure that the object type specified in the Source object type box is csv-Object.
5. Click Next.
6. On the Specify target page, do the following:
   1. Click Specify, and then select the Active Directory domain you connected in Scenario 1: Provision users from a .csv file to an Active Directory domain.
   2. Make sure that the object type specified in the Target object type box is User (user).
7. Click Next.
8. Expand Rules to Modify Object Attributes, and then create forward sync rules to synchronize the following pairs of attributes:

   Table 19: Rules to modify object attributes

   CSV file attribute	Synchronization direction	Active Directory attribute
   City	=>	City
   Department	=>	Department
   First Name	=>	First Name
   Last Name	=>	Last Name
   Telephone Number	=>	Telephone Number

   For information on how to create rules, see Modifying attribute values by using rules.

9. Click Finish.

Step 2: Run the created updating step

To run the updating step

1. On the Workflows tab, click Run now.
2. In the Select workflow steps to run dialog box, select the check box next to the step you created, and then click OK to run the step.

   After the synchronization step run completes, the Quick Connect Administration Console displays a report that provides information about the objects that participated in the provisioning step. At this stage, the application does not commit changes to the target Active Directory domain.

Step 3: Commit changes to Active Directory

To commit changes to the target Active Directory domain

• Click Commit.