2022.2

l
Encoding:Usethedrop-downtoselecttheencodingwithwhichtoreadthedatainthe
table.
l
Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending
(Z-A)order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnum-
bers,itwillbesortedasatext.
3. ClickFinishtoopenthedatabase
JDBC
1. Entertheappropriateinformationtoconnecttothedatabase:
l
JDBC Driver:Usethedrop-downtoselectwhichJDBCDrivertouseforthedatabasecon-
nection.
l
JAR file path:EnterapathtotheJARfilethatcontainstheappropriatedriverforthedata-
basebelow.
l
Server:Entertheserveraddressforthedatabaseserver.
l
Port:Entertheporttocommunicatewiththeserver.
l
Database name:Entertheexactnameofthedatabasefromwherethedatashouldbe
extracted.
l
User name:Enterausernamethathasaccesstotheserverandspecifieddatabase.The
useronlyrequiresReadaccesstothedatabase.
l
Password:Enterthepasswordthatmatchestheusernameabove.
l
Advanced mode:checktoenabletheConnectionStringtomanuallyenterthedatabase
connectionstring.
l
Connection string:Typeorcopyinyourconnectionstring.
2. ClickNextandentertheinformationforthesourcetable.
l
Connection string:Displaysthefullpathtothedatabase.
Note: Bydefault,theconnectionisattemptedwithencryptionenabled.Toinstruct
thedrivertonotuseencryption,addthe";encrypt=false"parametertothecon-
nectionstring.
l
Table:Usethedrop-downtoselecttheappropriatetableorstoredquerytoretrievethe
appropriatedataset.
l
Encoding:Usethedrop-downtoselecttheencodingwithwhichtoreadthedatainthe
table.
Page 305