2021.2

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 MySQL
l Microsoft Access Database (.mdb, .accddb)
l SQL Server
l ODBC DataSource
l JDBC
l Oracle.
2. Review the options presented. The options available depend on the type of database
data source; see below.
MySQL
1. Enter the appropriate information to connect to the database:
l Server: Enter the server address for the MySQL database.
l Port: Enter the port to communicate with the MySQL 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 MySQL server and specified
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.
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.
Page 799