Specify Oracle server hostname (or its IP address) to which Cayosoft Administrator will connect.

NOTE: For more information, review the Connecting to Oracle database article.

Specify the Oracle database service name.

Specify Oracle SQL*Net Listener port number; the default is 1521.

Specify Table or View from the selected database. Click the Selector button to display a list of tables from which to choose.

Specify Oracle user account name and password.

You can use the point-and-click filter builder for the specified data source.

NOTE: If the Where clause is also specified, it will be applied and DataSource Filter will be ignored.

More options

Specify columns returned by the data source.

Define a WHERE statement in the SQL query sent to the data source to limit the rows returned by an Oracle Server.

Select properties to display for each object found by the query.

Set the filtering conditions to hide unwanted data based on criteria not supported in the Query criteria setting.

Example: filter by the found object Distinguished Name.

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

The anchor attribute must be unique in the Data Source. Using the defined Anchor attribute, the rule checks to see if the anchor is already present in Active Directory. If the anchor is present, then this user was previously created, and the row in the Data Source is skipped.

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

Specify OU for master accounts creation.

Specify OU for mailbox accounts creation.

Mailbox Account Naming Properties

By default, SamAccountName is automatically generated from the data source, provided it contains correctly named fields. If the field names differ from those required for the selected format, contact Cayosoft to configure an override format. Additionally, the SamAccountName must be unique within the target domain.

Define the domain name component of the new user UserPrincipalName (UPN). The default UPN suffix is defined in the Default domain setting within the AD Users web query. If you are using Microsoft 365, ensure this value is set to a domain registered in Microsoft 365/Entra ID.

By default, UserPrincipalName (UPN) is automatically generated from the data source, provided it contains correctly named fields. If the field names differ from those required for the selected UPN format, contact Cayosoft to configure an override format. The UPN value must be unique.

If the Data Source contains a field named FirstName, ignore this setting. Otherwise, use the Selector button to choose a field from the Data Source. 

If the Data Source contains fields named FirstName and LastName, choose the desired format or ignore this setting. 

If the Data Source contains a field name Description, ignore this setting. Otherwise, manually enter a static text value or use the Selector button to choose a field from the Data Source. 

Mailbox Account Alternate Name Generation

This option determines how the system should react when the name of a user being created already exists.

The behavior of this attribute is the same as in the Contact Info section.

This setting specifies the number of fixed symbols the counter should have.

Specifies if a counter should always be added to the username, or only when name conflicts occur. 

Mailbox Account Organization Properties

If the Data Source contains one of these field names, ignore this setting. Otherwise, manually enter a static text value or use the Selector button to choose a field from the Data Source.

Use the Selector button to choose a field from the Data Source that is a unique identifier for the user’s manager. Typically this will be the Managers EmployeeNumber or EmployeeID.

Select an Active Directory attribute that is used to search for the value of the Manager Identifier specified in the field above.

Mailbox Account Contact Properties

Specify the user country. By default, the value is taken from the Active Directory extension settings.

Specify the format for email address.

NOTE: If alternative SMTP addresses are needed, the AD Users | Set Proxy Addresses rule can be run after this rule.

If the Data Source contains a field with one of these names, ignore this setting. Otherwise manually enter a static text value or use the Selector button to choose a field from the Data Source.

Mailbox Account Other Properties

Data mapping also can be set by the script.

If you want every provisioned user to have extension attribute 1 populated with some string value then use this

:{@{'extensionAttribute1'='YourString'}}

If you want every provisioned user to have extension attribute 2 populated with the corresponding value from the column in your data source file, then use this:

{@{'extensionAttribute2'=$_.EXT2}}

since EXT2 is the name of the column from your data source.

NOTE: If you set mapping for the same properties both in Other properties and Other properties script, attribute values will be updated by the script.

Master Account Naming Properties

By default, the first value is taken from the Trusted Domains table in the Active Directory extension settings.

Specify master account naming properties. By default, they are taken from mailbox account.

This setting defines the password for the new account. This value can be static text, a field from the Data Source chosen using the Selection button, or set to Generate Random Password.

NOTE: Static passwords or passwords from the Data Source must meet the Active Directory Password Complexity Policy of the target container, or the account will be created in a disabled state. Randomly Generated Passwords will be generated to match both the Active Directory Password Complexity Policy and additional complexity requirements defined in the Cayosoft Administrator Password Complexity Policy. 

These settings enable/disable the standard Active Directory user object settings. 

This setting defines the Account Expiration attribute in Active Directory.

In addition to populating this field from the Data Source, a text string can also be manually entered into the field in the format MM/DD/YYYY or YYYY-MM-DD. 

Master Account Other Properties

Data mapping also can be set by the script.

If you want every provisioned user to have extension attribute 1 populated with some string value then use this

:{@{'extensionAttribute1'='YourString'}}

If you want every provisioned user to have extension attribute 2 populated with the corresponding value from the column in your data source file, then use this:

{@{'extensionAttribute2'=$_.EXT2}}

since EXT2 is the name of the column from your data source.

NOTE: If you set mapping for the same properties both in Other properties and Other properties script, attribute values will be updated by the script.

Remote Mailbox Settings

Specify the format for remote routing address.

By default, Exchange contains an email address policy for every mail-enabled object.

For more information, please see this article Email address policies in Exchange Server.

If the Exchange address policy is applied, it generates email addresses automatically. By default, this policy is not enabled, Cayosoft Administrator generates the email address by itself.

Select Yes to create an in-place archive mailbox.

Notify Manager

Specify whether you want to notify the manager when the user is created. You can also select send email for each created user or send one email for all created users.  

Additional email can be sent to Default Notify & Alert Email Address - usually, this is the administrator's email address.

Email address where the copy will be sent.

Users can receive emails from default SMTP from address.

Email subject.

TIP: It is possible to customize email subjects by using different tokens, see Customizing an automation rule or web action output email. 

Message text.

TIP: It is possible to customize email messages by using different tokens, see Customizing an automation rule or web action output email.