Chat now with support
Chat with Support

Active Roles 8.1.1 - Synchronization Service Administration Guide

Synchronization Service overview Deploying Synchronization Service Getting started Connections to external data systems
External data systems supported with built-in connectors
Working with Active Directory Working with an AD LDS (ADAM) instance Working with Skype for Business Server Working with Oracle Database Working with Oracle Database user accounts Working with Exchange Server Working with Active Roles Working with One Identity Manager Working with a delimited text file Working with Microsoft SQL Server Working with Micro Focus NetIQ Directory Working with Salesforce Working with ServiceNow Working with Oracle Unified Directory Working with an LDAP directory service Working with an OpenLDAP directory service Working with IBM DB2 Working with IBM AS/400 Working with IBM RACF Working with MySQL database Working with an OLE DB-compliant relational database Working with SharePoint Working with Microsoft 365 Working with Microsoft Azure Active Directory Configuring data synchronization with the SCIM Connector Configuring data synchronization with the Generic SCIM Connector Objects and operations supported by the SCIM Connector Example of using the Generic SCIM Connector for data synchronization
Using connectors installed remotely Creating a connection Renaming a connection Deleting a connection Modifying synchronization scope for a connection Using connection handlers Specifying password synchronization settings for a connection
Synchronizing identity data Mapping objects Automated password synchronization Synchronization history Scenarios of use Developing PowerShell scripts for attribute synchronization rules Using PowerShell script to transform passwords

Scenario: Using 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 creating scenario described earlier in this document. Only accounts for previously created employees will be updated.

Creating 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 sync workflow

  1. In the Synchronization Service Console, open the Sync Workflows tab, and then click the sync workflow you created in the Creating a sync workflow step.
  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: Create 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: Create 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 116: 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.

Running the configured updating step

To run the updating step

  1. On the Sync Workflows tab, click Run now.
  2. In the Select sync workflow steps to run dialog, 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 Synchronization Service Console displays a report that provides information about the objects that participated in the updating step. At this stage, the application does not commit changes to the target Active Directory domain.

TIP: 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.

Committing changes to Active Directory

To commit changes to the target Active Directory domain

  • Click Commit.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating