2022.2

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.
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.
Afteraddingdatafromadatabase,theData Modelpaneattherighthandbottomshowsthedatafields
thatoccurinthedata.
TheValuecolumndisplaysdatafromthefirstrecordinthedatafile.UsetheFirst,Previous,Nextand
Lastbuttonstobrowsethroughtherecords.
AddingJSONsampledata
JSONdatacaneitherbeadded to,orreplacetheDataModelinatemplate.
ImportingJSONdataintotheDataModelmakesiteasiertotesttemplatesthataremeanttobemerged
withJSONdatainaWorkflowconfiguration.
Workflow'sOLConnectCreateContenttaskscanuseJSONastheirdatasource;seeCreate
EmailContent,CreatePrintContent,andCreateWebContent.)
ToaddJSONsampledatatotheDataModel:
1. SelectFile > Add Data > JSON sample data,fromthemenu.Alternatively,clicktheJSON
Sample DatatoolbarbuttonontheDataModelpane.
2. Eitherbrowsetothelocationofthefileandselectit,orpasteorwritetheJSONdirectlyinthebox
belowthefilename.
Tip: IfadatafieldcontainsJSONdatayoucouldusethatdataassampledata:right-click
thefield,selectCopytocopytheJSONdatatotheclipboard;thenopentheJSONSample
Datadialogandpastethedatathere.
Page 720