2018.2

MDB file options
o
File: Include the full path to the file.
o
Password: If the file isn't password protected, you can click Next without filling out this
field.
o
Table name: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
o
Encoding: Use the drop-down to select the encoding with which to read the data in the
table.
XML File options
Select what level of XML elements defines a record.
The Trigger is what triggers the creation of a new record. It can be set to:
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.
Page 297