2022.2

ODBC Data Source
l
ODBC Source:Usethedrop-downtoselectanODBCSystemDataSource.Thismustbeadata
sourcethathasbeenconfiguredinthe64-bitODBCDataSourceAdministrator,asPlanetPress
Connectisa64-bitapplicationandthuscannotaccess32-bitdatasources.
l
This ODBC source is MSSQL:CheckthisoptioniftheODBCsourceisMSSQL(SQLServer).
TheoptionsbelowappearunderMSSQL-ODBC advanced configuration:
l
Windows authentication:SelecttousetheWindowsusernameandpasswordthatare
usedbytheConnectService.
l
SQL Server authentication:SelecttousetheUsernameandPasswordsetbelowtocon-
necttotheSQLServer:
l
User name:EntertheSQLServerusername.
l
Password:Enterthepasswordfortheaboveusername.
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numbers,itwill
besortedasatext.
JDBC
SinceJDBCcanconnecttomultipletypesofdatabases,aspecificdatabasedriverandpathto
thisdriver'sJARfilemustbespecified.
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database.
l
Server:Entertheserveraddressforthedatabaseserver.
l
Database name:Entertheexactnameofthedatabasefromwherethedatashouldbeextracted.
l
User name:Enterausername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usernameabove.
l
Advanced mode:ChecktoenabletheConnection Stringfieldtomanuallyenterthedatabase
connectionstring.
l
Connection string:Typeorcopyinyourconnectionstring.
Page 209