Application management : Tools : Enterprise Talk : Worker parameters : DBReaderWorker parameters
DBReaderWorker parameters
Parameters
Description
Query.<main/sub>
.<node>.Sql
SQL (select) statement to be executed on the specified database in order to export the right data. If the configured SQL does not contain valid XML, the processing is aborted.
* 
Whenever JAVA special characters are used in the SQL statement these should be escaped by a backslash (\).
UnitOfMeasurement
Unit of measurement used in the source. This value is used for the header element.
M/F
M:Meters
F:Feet
Default value: M
EmptyFields
An XML element is created for an empty column value in the source database when the value is set to True.
Default value: True
True: the XML gets an element without a value (Empty or NULL).
False: the XML will not get an element for the field.
database-name
The JNDI name mentioned in the DS File.
For example,
database-name some-mssql-DS.
JNDI name in the ds.xml file should end with 'DS'.
database-name
The JNDI name of the data source you would like to export from, as mentioned in the …\Server\wildfly-*\standalone\configuration\standalone-full.xml file.
* 
The database -name param value is present as a part of file name present in the folder <install-location>\ Server\<jboss-XX>\server\default\deploy.
* 
The data source should be named <name>DS, for example Worker-DS.