Overview
Cayosoft Administrator can synchronize user account data from HR and other systems during the provisioning, update, and suspension of user accounts in Active Directory, Office 365, and other services.
To access data in the HR system, Cayosoft Administrator can connect to Microsoft SQL Server and Oracle databases, using a corresponding SQL or Oracle account. These accounts must have the correct permissions to access any database, table, or view that holds the account data.
The Utils extension in Cayosoft Administrator provides support for connecting to external databases, such as SQL Server and Oracle, to facilitate various administrative tasks. This extension allows you to define custom connection configurations for both SQL Server and Oracle databases, ensuring seamless integration with your organization's infrastructure.
Utils extension settings
To configure the connection to Microsoft SQL Server, please see the Connecting to Microsoft SQL Server data source article.
To configure the connection to the Oracle database, please see the Connecting to Oracle Database article.
Command name | Description |
---|---|
Timeout for operations (seconds) | Defines the maximum time, in seconds, that Cayosoft Administrator will wait for a database operation to complete before timing out. This setting is useful for preventing long-running tasks from hanging. |
SQL Server |
|
Credentials |
The username and password used to authenticate against the SQL Server instance. These credentials must have sufficient privileges to perform the required operations within the database. |
Instance |
The name of the SQL Server instance that Cayosoft Administrator will connect to. You can specify the default instance or a named instance depending on your environment. |
Database |
The name of the specific database within the SQL Server instance where the Cayosoft Administrator will perform its operations. |
Oracle database |
|
Credentials |
The username and password are used to authenticate against the Oracle database. These credentials must have the necessary permissions to access the database for Cayosoft Administrator tasks. |
Hostname |
The fully qualified domain name (FQDN) or IP address of the Oracle database server that Cayosoft Administrator will connect to. |
Service Name |
The service name of the Oracle database. This identifies the database instance on the Oracle server and is used for establishing a connection. |
Port |
The port number used to communicate with the Oracle database. The default port for Oracle is 1521, but this may vary based on your setup. |
Override connection string |
Allows you to provide a custom Oracle connection string to connect to the database. Learn more in: When populated, this setting overrides the hostname, port, and service name fields. The connection string should follow a specific format such as: Learn more in: Tips for Using the New Oracle Override Connection String Setting in Cayosoft. |
Oracle Data Access Components path |
Specifies the file system path to the Oracle Data Access Components (ODAC) installed on the Cayosoft Administrator server. ODAC components are required for Cayosoft Administrator to interface with Oracle databases. |
Actions
Command name | Description |
---|---|
Check settings |
This command validates the specified settings and verifies that the account credentials are correct. |
Tips for Using the New Oracle Override Connection String Setting in Cayosoft
When using the Oracle Override Connection String setting, there are a few key nuances to keep in mind to ensure seamless integration. This setting applies to all Oracle-related rules and impacts how connections to Oracle databases are established in Cayosoft. Below are some tips to help you navigate this feature:
-
Global Application of Override Connection String:
- The new Override connection string will be used across all Oracle-related rules in Cayosoft, meaning that once configured, all such rules will rely on this connection string for Oracle database connectivity.
- Overrides for specific parameters (e.g., Hostname, Service Name, Port) are not possible. This means you cannot configure different connection details for individual rules—only credentials and table selection can vary on a per-rule basis.
-
Hostname, Service Name, and Port Still Required:
- Even if you're using the Override connection string, you are still required to fill in the Hostname, Service Name, and Port fields in the Cayosoft UI.
- These fields are marked as mandatory for Oracle-related rules and must not be left empty, even though they won't actually be used if you're using the override string. This is a validation requirement, so ensure you populate them with valid data.
-
Credential Flexibility:
- While the connection string overrides most of the key connection details, you can still modify the credentials (username and password) for different Oracle-related rules. This gives you the flexibility to manage access permissions separately for different database operations, even when using a single connection string.
- Additionally, you can select different tables for each rule, providing more granular control over which database objects are accessed by each rule.
-
Test Your Connection String:
- Always test the new override connection string thoroughly before applying it across multiple rules. Since all Oracle-related rules will use this string, any errors in the string could disrupt multiple processes. It's important to validate that the connection string works as expected in the Cayosoft environment.
-
No Need to Reconfigure Rules After Override:
- Once you apply the new Override connection string, existing Oracle-related rules do not need to be individually reconfigured. As long as the connection string is correctly configured, the rules will automatically use the new connection details.
Comments
0 comments
Please sign in to leave a comment.