2019.1

Note
You can also use the PlanetPress Workflow Database Action task to get data from a
database, and output in multiple different formats such as CSV. See "Database Query"
on page326.
Bear the following in mind:
l The person or plugin performing the query must have full access to the database.
l The data is extracted at the time of the query. A new query must be performed whenever
the data needs to be updated.
l Any changes to the structure of the database may have an impact on automated data
querying tasks.
l You must have the proper ODBC driver installed to use this emulation.
Database emulation supports SQL ANSI 92 or higher, and supports the following data types:
string, integer, floating point, all date formats, and text-only MEMO. It does not support any
binary data types such as Binary Large Object (BLOB), images, sound files, and MEMO data
that includes binary data.
Database emulation requires version 2.5 or higher of Microsoft Data Access Components
(MDAC), including JET 4.0, and you can save database emulation configurations to a file.
Database emulation options
For help on setting up a database emulation see: "Choosing a database sample file" on
page66.
Note for PlanetPress Suite users: For information about setting up a database emulation in a
Design document, please see the relevant page in the PlanetPress Design User Guide.
Metadata
Metadata is a hierarchical structure describing a job. Simply put, Metadata is data about data
or, in other words, information tagged to data. Depending on the type of job, the Metadata
includes information about the job, the data file, items in the Connect database, a PlanetPress
Page 69