...
The following database management systems are supported:
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
Noteinfo | ||
---|---|---|
| ||
MySQL versions 5.7.x and 8.0.x are is supported. |
Step 1 | Download MySQL installation instructions. |
---|---|
Step 2 | Download MySQL (Windows only).
|
Step 3 | Install MySQL as per the instructions. |
Step 4 | Make a note of the user ID and password to be used later when installing the Controller. |
Step 5 | The database will be created automatically when you select MySQL during the Controller installation process. |
...
For more information about this parameter, see the MySQL documentation:
- http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commithttp://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit
...
For detailed information about this variable, refer to:
...
...
Anchor | ||||
---|---|---|---|---|
|
Microsoft SQL Server
Noteinfo | ||
---|---|---|
| ||
Microsoft SQL Server versions 2014,2016, 2017, 2019 and 20192022 are supported. |
Step 1 | Download and install MS SQL Server as per the Microsoft 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. |
...
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 | title | Note
---|
Info |
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. |
...