2020.1

Connect. This should help in determining and refining the acceptable
connection options.
l
Hostname: Enter the IP Address or alias of the server where database resides.
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
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).
Page 64