2022.1

l Database Instance Name: Enter an existing Microsoft SQLServer's instance
name.
This option only applies to existing Microsoft SQLServer instances, and not for
MariaDB or MySQL.
l Port: Enter Port number. The defaults are those which the vendors use by default.
l Schema: The individual database schema, within the vendor database.
Note
If a previously non-existent schema were chosen here, then a new schema of
that name will be created within the database when the back-end database
swap is applied. The tables within that schema, though, will not be created
until Connect is restarted.
l Username: Enter the database login username.
Tip
It is considered best practice for this user to have root privileges.
l Password: Enter the password associated with selected username.
l Advanced Connection Settings selections:
l Maximum concurrent threads: This option sets the maximum database threads.
The maximum setting is determined by the specific capabilities of the machine
Connect is installed upon (CPU speed and the amount of cores being the major
determinants).
Tip
Leaving this value set to the default maximum should be the best option in
most circumstances.
We recommended this entry be left at the default value.
Page 62