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:
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:
This section describes how to create or modify a connection to Microsoft Exchange Server so that 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 .
To create a connection to Microsoft Exchange, you need to use in conjunction with a special connector called Exchange Server Connector. This connector is included in the package.
The Exchange Server Connector supports the following features:
Table 14: Exchange Server Connector – Supported features
|
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 |
To create a new connection
- In the , 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 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 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:
-
account: Allows you to access Exchange Server in the security context of the account under which the 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.
To modify connection settings
- In the , 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 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 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:
-
account: Allows you to access Exchange Server in the security context of the account under which the 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.
