Sample SQL query 1
This SQL query illustrates how to call a specific Oracle stored procedure:
In this query:
Sample SQL query 2
This SQL query illustrates how to create a new user in 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 Server, 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 27: Supported features
Allows you to read and write data in the connected data system.
Delta processing mode
Allows you to more quickly synchronize identity data by processing only the data that has changed in the source and target systems since their last synchronization.
Allows you to synchronize user passwords from an Active Directory domain to the connected data system.
In this section:
Creating a new connection to Exchange Server
To create a new connection
- In the Synchronization Service Administration Console, open the Connections tab.
- Click Add connection, and then do the following:
- In the Connection name box, type a descriptive name for the connection.
- From the Use the specified connector list, 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, 2013, or 2010, 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 box 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.
- Test Connection. Click this button to verify the specified connection settings.
- Click Finish.