Chat now with support
Chat with Support

Quick Connect Sync Engine 5.5 - Administrator Guide

One Identity Quick Connect Overview Deploying One Identity Quick Connect Sync Engine Getting started Connections to external data systems Synchronizing identity data Mapping objects Automated password synchronization Synchronization history Scenarios of use Appendices

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

Scenarios of use > 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.

NOTE: This scenario can be used only if the Employees OU already contains user accounts created with the provisioning scenario described earlier in this document. Only accounts for previously provisioned employees will be updated.

This scenario has the following steps:

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.

NOTE: To view a list of user accounts to be updated in the Employees OU, in the update report, click the number next to Objects to be updated.

Step 3: Commit changes to Active Directory

To commit changes to the target Active Directory domain

  • Click Commit.
Related Documents