Chat now with support
Chat mit Support

Active Roles 8.1.5 - Synchronization Service Administration Guide

Synchronization Service overview Deploying Synchronization Service Deploying Synchronization Service for use with AWS Managed Microsoft AD 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
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

Sample SQL queries for working with Oracle Database user accounts

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 14: 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

  1. In the Synchronization Service Console, open the Connections tab.
  2. 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.
  3. Click Next.

  4. 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.

  5. Click Finish.

Modifying an existing connection to Exchange Server

To modify connection settings

  1. In the Synchronization Service Console, open the Connections tab.
  2. 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.
  3. Click Next.

  4. 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.

  5. When you are finished, click Save.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen