Active Roles Sync Service 8.2 - Administration Guide

This section provides some SQL query examples that you can use a baseline for your own queries toward the connected Oracle Database system.

Example: Calling an Oracle stored procedure

This SQL query illustrates how to call a specific Oracle stored procedure:

CALL "<ProcedureName>"('&USERNAME')

In this query:

ProcedureName specifies the name of the Oracle stored procedure you want to call.
USERNAME refers to the name of the attribute that uniquely identifies a user in the target Oracle Database system.

Example: Creating a new user in the Oracle Database

This SQL query illustrates how to create a new user in the connected Oracle Database:

insert into DatabaseTable(ColumnName) values (upper('&USERNAME'))

In this sample query:

DatabaseTable specifies the name of the table into which the entry will be added.
USERNAME refers to the name of the attribute that uniquely identifies a user in the target Oracle Database system.

Working with Exchange Server

This section describes how to create or modify a connection to Microsoft Exchange Server so that Synchronization Service could read and write data in that data system. This section also describes what data you can read and/or write in Exchange Server by using Synchronization Service.

To create a connection to Microsoft Exchange, you need to use Synchronization Service in conjunction with a special connector called Exchange Server Connector. This connector is included in the Synchronization Service package.

The Exchange Server Connector supports the following features:

Table 13: Exchange Server Connector – Supported features
Feature	Supported
Bidirectional synchronization Specifies whether you can both read and write data in the connected data system.	Yes
Delta processing mode Specifies whether the connection can process only the data that has changed in the connected data system since the last synchronization operation. This reduces the overall synchronization duration.	No
Password synchronization Specifies whether you can synchronize user passwords from an Active Directory (AD) domain to the connected data system.	No

Creating a new connection to Exchange Server

To create a new connection

In the Synchronization Service Console, open the Connections tab.
Click Add connection, then use the following options:
- Connection name: Type a descriptive name for the connection.
- Use the specified connector: Select Exchange Server Connector.
Click Next.
On the Specify connection settings page, use the following options:
- Select the Exchange Server version to which you want to connect: Select the Exchange Server version to which you want to connect. If you select the Automatically select latest version option, the connector searches your environment for available Exchange Server 2019, 2016, or 2013, and connects to the latest of these versions found. Use the Automatically select latest version option only together with the Any available Exchange Server in the forest option.
- Connect to: Choose how you want to connect to Exchange Server by selecting one of the following:
  - Any available Exchange Server in the forest: Allows you to connect to any available Exchange Server computer residing in the Active Directory forest you specify. In the Domain in the forest text box, type the fully qualified domain name (FQDN) of any domain that belongs to the forest that includes the Exchange Server you want to connect to. If you select this option, make sure the account you specify under Access Exchange Server using has sufficient permissions to read the Root Directory Service Entry (rootDFS) and configuration naming context of the forest.
  - Specified Exchange Server: Allows you to connect to the Exchange Server computer whose fully qualified domain name (FQDN) you type in the provided text box.
- Advanced: Opens a dialog that allows you to specify advanced options for connecting to Exchange Server and reading and writing Exchange configuration data in Active Directory.
- Options related to reading and writing Exchange configuration data in Active Directory:
  - Use default domain controller: Causes Synchronization Service to read and write Exchange configuration data in Active Directory by using the default domain controller defined on the Exchange Server used for the connection.
  - Use specified domain controller: Causes Synchronization Service to read and write Exchange configuration data in Active Directory by using the domain controller whose FQDN is specified in the text box below this option.
- Options related to connecting to Exchange Server:
  - Connect using HTTPS: Select this check box to connect to Exchange Server by using HTTPS.
  - Validate server certificate: Select this check box to validate server certificate on the target Exchange Server.
  - Authentication method: Select an authentication method to access Exchange Server.
- Access Exchange Server using: Select one of the following access options:
  - Synchronization Service account: Allows you to access Exchange Server in the security context of the account under which the Synchronization Service is running.
  - Windows account: Allows you to access Exchange Server in the security context of the account whose user name and password you type in the provided text box.
- To test the connection with the new parameters, click Test connection.
Click Finish.

Modifying an existing connection to Exchange Server

To modify connection settings

In the Synchronization Service Console, open the Connections tab.
Click Add connection, then use the following options:
- Connection name: Type a descriptive name for the connection.
- Use the specified connector: Select Exchange Server Connector.
Click Next.
On the Specify connection settings page, use the following options:
- Select the Exchange Server version to which you want to connect: Select the Exchange Server version to which you want to connect. If you select the Automatically select latest version option, the connector searches your environment for available Exchange Server 2019, 2016, or 2013, and connects to the latest of these versions found. Use the Automatically select latest version option only together with the Any available Exchange Server in the forest option.
- Connect to: Choose how you want to connect to Exchange Server by selecting one of the following:
  - Any available Exchange Server in the forest: Allows you to connect to any available Exchange Server computer residing in the Active Directory forest you specify. In the Domain in the forest text box, type the fully qualified domain name (FQDN) of any domain that belongs to the forest that includes the Exchange Server you want to connect to. If you select this option, make sure the account you specify under Access Exchange Server using has sufficient permissions to read the Root Directory Service Entry (rootDFS) and configuration naming context of the forest.
  - Specified Exchange Server: Allows you to connect to the Exchange Server computer whose fully qualified domain name (FQDN) you type in the provided text box.
- Advanced: Opens a dialog that allows you to specify advanced options for connecting to Exchange Server and reading and writing Exchange configuration data in Active Directory.
- Options related to reading and writing Exchange configuration data in Active Directory:
  - Use default domain controller: Causes Synchronization Service to read and write Exchange configuration data in Active Directory by using the default domain controller defined on the Exchange Server used for the connection.
  - Use specified domain controller: Causes Synchronization Service to read and write Exchange configuration data in Active Directory by using the domain controller whose FQDN is specified in the text box below this option.
- Options related to connecting to Exchange Server:
  - Connect using HTTPS: Select this check box to connect to Exchange Server by using HTTPS.
  - Validate server certificate: Select this check box to validate server certificate on the target Exchange Server.
  - Authentication method: Select an authentication method to access Exchange Server.
- Access Exchange Server using: Select one of the following access options:
  - Synchronization Service account: Allows you to access Exchange Server in the security context of the account under which the Synchronization Service is running.
  - Windows account: Allows you to access Exchange Server in the security context of the account whose user name and password you type in the provided text box.
- To test the connection with the new parameters, click Test connection.
When you are finished, click Save.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem