'Database Query' Action

enaio® 10.10 »

The automatic action 'Database query' allows you to send SQL queries to the enaio® database. The results can be saved to a file.

If the SQL statement contains exactly two integer columns, these may be identified as the object ID and object type and saved to the portfolio of a particular user. The combination of several queries and different users permits you to periodically query and distribute task packages.

By saving the results of the query to a file, it is possible to create regular reports on the data pool which are then stored in the file system for further processing. The results of such a database query are saved in the semicolon delimited file format (CSV).

To use this action, add the axacreq.dll library (see ''Additions' Tab').

Enter a configuration name when setting up this automatic action.

The database query is configured in the following dialog: