2022.2

numbers,itwillbesortedasatext.
3. ClickFinishtoopenthedatabase.
ODBC DataSource
1. SelecttheODBCsystemdatasource.Note:Only32-bitdatasourcesarecurrentlyshowninthis
dialog,evenifyoursystemis64-bits.
2. ClickNextandentertheinformationforthesourcetable.
l
Connection string:Displaysthefullpathtothedatabase.
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.
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.
Page 719