Skip to main content

Articles in this section

See more
Print

AD Users | Update Workday Data rule

  • Updated

AD Users | Update Workday Data rule

Rule description

This rule queries the specified Active Directory scope and for each user in this scope finds a record with the same anchor in Workday and updates this record with attribute values that are specified in the Attribute mapping setting.

NOTE: The Workday extension settings should be configured. Using this rule requires a 'Cayosoft Administrator Workday Integration' license.

When to use this rule

You can use this rule when performing bulk user account updating from the Active Directory into the Workday HR system.

Rule Settings

Query Section

Setting name Description

Workday endpoint URL

Specify Workday endpoint URL.

By default, the value is taken from the Workday extension settings.

Workday credentials

Specify Workday credentials.

This account must have proper API permissions in the Workday tenant.

User format: user@tenant.

By default, the value is taken from the Workday extension settings.

Limit scope to this domain or OU

This setting defines the search query scope. To improve query performance, limit the scope to a specific OU.

IMPORTANT: To test the rule configuration, limit the rule scope to an OU that contains test accounts or objects and use the Preview feature.

Query criteria

Query criteria are sent with the query and may improve query performance.

TIP: For additional information on the criteria builder, see the How to use Query Builder dialog for Query Criteria and Filter rule settings.
Hours to sync

 

Specify how often synchronization will be run (every number of hours).
Active Directory Anchor attribute

Defines the attribute in the Active Directory to which the Data Source anchor attribute is to be compared. When a new user is created this value also specifies the Active Directory attribute into which the Data Source anchor is written for comparison the next time the rule is executed.

NOTE: If the Active Directory attribute you wish to use as the Active Directory Anchor attribute is not displayed, you can enter the LDAP name of the attribute in the field. The attribute must be flagged as searchable within Active Directory. Learn more in: Search-Flags attribute. To determine if the attribute is flagged as searchable you can use ADSI Edit to view the Schema Objects container and examine the attribute’s searchFlags property.
Data Source Anchor attribute

Select a column in the data source that contains the attribute value for identifying and mapping a computer.

Other Query Settings

Properties to display

Each object property defined in this setting matches the column that will be displayed in the Web Portal for this web query.

To display additional columns, add the required properties to the Properties to display list.

To add extension attribute 1 that is synchronized from AD, you need to use a value like:

Copy
"OnPremisesExtensionAttributes/extensionAttribute1~Extension Attribute 1"
System properties

List of properties required for this rule to be executed correctly.
Filter

To hide unwanted data based on criteria, not supported by Active Directory query, set the filtering conditions here.

Example: filter by the found object Distinguished Name.

TIP: For optimal performance, use the Query criteria above to filter objects whenever possible.
Sort by

Sort result object list.
Initialization script

Usually, rules use query criteria to limit the query search scope. It improves the performance of the executed rule.

Due to the PowerShell limitations, it is not possible to use calculated expressions in query criteria. That is the point where the initialization script can help. You can initialize a global variable in this setting and then use it in query criteria.

IMPORTANT: To use a variable, declared in the initialization script, in the query scope, it must be global: $global:<variable name>.

Example: Update AD users, created in the last ten days.

  1. Add this initialization script

    Copy
    {$global:DatePeriod = (Get-Date).AddDays(-10)}

  2. Use the $DatePeriod variable in the query criteria builder:

Action section

Setting name Description

  • First name

  • Middle name

  • Last name

  • Preferred first name

  • Preferred middle name

  • Preferred last name

  • Work number

  • Work email

 Specify if the attribute should be updated and if it does select the attribute to update the value from.

Output Section

This section defines the output format of this rule.

To get more information about this section, please see the Rule Output section article.

Enforce/Schedule section

This section defines the schedule for how often to run the rule.

To get more information about this section, please see the Rule Enforce/Schedule section article.

Change History

Version Notes
11.2.0 The rule has been introduced in the product.

© Copyright 2013-2026 Cayosoft Inc. All rights reserved.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.