1.8

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.
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 242