2018.1

l
On element: This defines a new record when a new element occurs on the selected XML
level.
l
On change: This defines a new record when a specific field under the chosen XML level
has a new value. After selecting this option, you have to select the field that triggers the
creation of a new record.
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.
Page 283