2018.2

Tip
Double-clicking on the data file does the same thing as right-clicking on it an then
selecting Set as sample data file. Clicking Cancel instead of OK after viewing will
prevent this action from being taken.
Choosing a database sample file
To choose a database sample file:
1. Open the Data Selector (see "The Data Selector" on page666).
2.
From the Emulation drop-down list, select Database.
3.
Next to the Sample data file field, click the Configure Database button.
4. Associate a database.
l
Microsoft Access Database or dBase file: In Database, enter the path of the
Microsoft Access database or dBase file, or click the Browse button to the right of
the box to navigate to, the database file. Recall that a Microsoft Access database file
bears the extension .mdb, and a dBase file bears the extension .dbf. If the file is a
dBase file, you must specify the folder that contains the .dbf file. The folder in this
case is considered to be the database, while each individual .dbf file is a table in the
database. Once you enter the path, the Table/query name box updates to reflect the
tables and queries available in the selected database.
l
ODBC Data Source: In ODBC Data Source, click to connect to an ODBC Data
Source. Use the Select Data Source dialog box that appears to select an existing
Data Source or set up a new one. When you exit the Select Data Source dialog box,
the Database box updates to display the connection string it uses to connect to the
database, and the Table/query name box updates to reflect the tables and queries
available in the selected database.
Note
Since the Workflow tool is a 32-bit application, it can only use 32-bit ODBC
data sources. Make sure you use the proper Windows application (ODBC
Data Sources (32-bit)) to create and manage data sources that can be used in
Workflow.
Page 66