...
| Note | ||
|---|---|---|
| ||
In a High Availability environment, each cluster node connects to the same database. |
| Anchor | ||||
|---|---|---|---|---|
|
Database Permissions
In order to install or perform upgrades of Universal Universal Controller, the database user configured for the Controller will require DDL (Data Definition Language) permission in the database during the install or upgrade.
Once the install or upgrade has been completed successfully, the configured database user requires only DML (Data Manipulation Language) permissions for running the Controller.
...
| Note |
|---|
Databases that are compatible with and use the same JDBC drivers as the supported databases are also supported, for example AWS RDS (MySQL), MariaDB (MySQL), or Azure SQL Database (SQL Server). We recommend that customers periodically review the database documentation for Incompatibilities and Feature Differences as these may change over time. |
| Anchor | ||||
|---|---|---|---|---|
|
MySQL
| Note | ||
|---|---|---|
| ||
MySQL versions 5.7.x and 8.0.x are supported. |
...
Prior to considering the enabledTLSProtocols connection property , you should verify the database connection using the latest Universal Controller maintenance release, as it may be using a more recent MySQL Connector/J, with functionality changed or added.
https://docsstonebranchdocs.stonebranchatlassian.comnet/confluencewiki/display/SMLRI/Universal+Controller+Maintenance+Lists
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html
| Anchor | ||||
|---|---|---|---|---|
|
Microsoft SQL Server
| Note | ||
|---|---|---|
| ||
Microsoft SQL Server versions 2014, 2016, 2017, and 2019 are supported. |
...
| Note | ||
|---|---|---|
| ||
Universal Controller automatically appends the When set to false, the Unicode translation property specifies that prepared parameters for character data are sent as ASCII or Multi-byte Character Set (MBCS) instead of Unicode. jdbc:sqlserver://localhost:1433;databaseName=uc;sendStringParametersAsUnicode=false |
| Anchor | ||||
|---|---|---|---|---|
|
Oracle
| Note | ||
|---|---|---|
| ||
Oracle versions 19c and 21c are supported. |
...
Step 1 | Download and install Oracle as per the Oracle documentation. |
|---|---|
Step 2 | Create the Controller database. You can use any legal name, but we recommend the name uc. |
Step 3 | Make a note of the userid and password to be used later when installing the Controller. |
If PDB (Pluggable Database) is being used for the Oracle Controller database, the JDBC URL should be used in EZCONNECT format and point to the PDB service, not the database SID.
For example:
jdbc:oracle:thin:@//dbhost:1521/pdbuc.userdomain
Oracle Options
The following enhancements can be made to your Oracle database.
...