2022.2

Note: AftercreatingtheinitialdatamappingconfigurationyoumayuseacustomSQLqueryvia
theInputDataSettings;see"Settingsforadatabase"onpage224.
Tip: TheSort onoption,combinedwiththeStop data mappingoptionofthe"Actionstep"on
page257,allowstoprocessonlyagroupofitemswithouthavingtoexamineallrecords.(See
also:"Actionstepproperties"onpage333.)
MariaDB, MySQL, SQL Server or Oracle
l
Server:Entertheserveraddressforthedatabase.
l
Port:Entertheporttocommunicatewiththeserver.Thedefaultportis3306.
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Readaccesstothedatabase.
l
Password:Enterthepasswordthatmatchestheusernameabove.
l
Table name:Theselecteddatabaseisasetofrelatedtablescomposedofrowsandcolumnscor-
respondingrespectivelytosourcerecordsandfields.Selectatablefromwhichyouwantto
extractdata.
l
Encoding:Choosethecorrectencodingtoreadthefile.
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.
Microsoft Access
l
Password:Enterapasswordifoneisrequired.
l
Table name:Theselecteddatabaseisasetofrelatedtablescomposedofrowsandcolumnscor-
respondingrespectivelytosourcerecordsandfields.Selectatablefromwhichyouwantto
extractdata.
l
Encoding:Choosethecorrectencodingtoreadthefile.
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.
Page 208