2022.2

About AFP files
PagesinAFPfilesarearrangedinatreestructure,comprisingonedocumentatthetopofthestruc-
ture,pagesatthebottomofthestructureandoneormorelevelsofpage groupsinbetween.(Unlikein
PDF/VTfiles,thenamesoflevelsinAFPfilescannotbechosenfreely.)Inotherwords,anAFPfile
alwaysconsistsofonedocument,thatcancontainpagegroups,ofwhicheachcanbedividedinpage
groups,andsoon;thepagegroupsatthelowestlevelcontainpages.
Metadatacanbeattachedtoeachlevelinthestructure.
Addingdatafromadatabase
1. ClickFile,selectAdd DataandthenclickFrom database data source.Browsetothelocation
ofthefileandselectit.
TheDesignercanopendatabasesfromthefollowingtypesofdatasources:
l
MariaDB
l
MySQL
l
Oracle
l
MicrosoftSQLServer
l
MicrosoftAccessDatabase(.mdb,.accddb)
l
ODBCDataSource
l
JDBC
2. Reviewtheoptionspresented.Theoptionsavailabledependonthetypeofdatabasedata
source;seebelow.
MariaDB \ MySQL
1. Entertheappropriateinformationtoconnecttothedatabase:
l
Server:EntertheserveraddressfortheMariaDBorMySQLdatabase.
l
Port:EntertheporttocommunicatewiththeMariaDBorMySQLserver.Thedefaultportis
330.
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MariaDBorMySQLserverandspe-
cifieddatabase.TheuseronlyrequiresReadaccesstothedatabase.
l
Password:Enterthepasswordthatmatchestheusernameabove.
2. ClickNextandentertheinformationforthesourcetable.
Page 716