Versions Compared

Old Version 6

changes.mady.by.user Stonebranch

Saved on

compared with

New Version 7

changes.mady.by.user Stonebranch

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server

Note
Note
title
Info

Microsoft SQL Server versions 2014, 2016, 2017, and 2019 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.
 

Warning
titleImportant

You must use a case-insensitive collation.


Step 3

Make a note of the userid and password to be used later when installing the Controller.

...

Note
titleNote

Universal Controller automatically appends the sendStringParametersAsUnicode parameter to the URL, setting it to false.

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
Oracle

Oracle

Note
Note
title
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.

...