2022.2

ManualsBrandsObjectif Lune ManualsApplicationsPrintShop Mail Connect

901

902

903

904

905

906

907

908

909

910

Table Of Contents

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.

l

Custom database parameterstable:Theseareextraparameterswhichareappendedto

thedatabaseconnectionURL.Thedefaultvaluesarethosewhichhavebeendetermined

tobeusefulinconnectingtospecificvendordatabases.

Forexample,inordertouseIntegratedAuthenticationwithWindows,specifytheproperty

integratedAuthenticationwiththevaluetrue,whichaddsinteg-

ratedAuthentication=truetotheURL.

l

Property:Thesearefreefieldtextfields.

Note: ThesefieldsandtheirassociatedvaluesgetappendedtotheJDBCcon-

nectionandthereforemustfollowallrulesregardingacceptable

URLaddressesforsuch.

l

Value:ThevalueappliedtotheassociatedProperty.

Page 909