8.8

table. Note that you can import a database connection configuration that you previously
exported from PlanetPress Design (when you created a document) or from PReS
Workflow (when you set up a sample data file for a process).
l You can use dynamic properties (properties that include variables or data available at
run-time). This option lets you create a dynamic database connection string as well as an
SQL statement that changes based on the data processed by PReS Workflow. Note that
this option will not let you test the query performed by this task before it is performed with
actual data.
Input
Any data file. The data file will be discarded by the task.
Processing
Aconnection to the selected database is made, the data is retrieved, and an output in the
selected emulation format is generated.
Output
The result of the query is output in the selected data format. The current emulation is changed
to the selected format. Metadata and jobinfos are not modified in any way.
Properties
Database Connection tab
l Database group
l Location: Enter either the path and name of the database or a database connection
string in this box. You may click to navigate to the database and paste the database
path and name automatically to this box. You may also click create an ODBC
connection string to the data source and paste the string automatically to this box. If
a login name and password are required to connect to the database, a dialog box is
displayed and the information you enter is saved in the configuration of the PReS
Workflow Database action task.
l Table/Query: Select the table or query containing the information you need as your
input data.
Page 296