Page Comparison

A Collection to Database task exports data from an XpoLog log into a specified database.

To add a Collection to Database task:

1. Open the Tasks console (see Tasks), and click the New Task button
   OR
   In the XpoLog Manager homepage, under More Actions, click Add Task.
2. In the page that opens, select the Collection to Database option, and then click Continue.
   The Collection to DatabaseTask Database Task page opens.
3. In Name, type the name of the new task.
4. In Description, type a description of the new task; optional.
5. In Collected Log, type the name of a log
   OR
   Click click Select log, and in the Select Log to Collect window that opens, select a log to export to a database.
6. In Data Filter Query, type a query to filter out events that don't do not satisfy the above query.
7. In Environment Variables Connection Details, type the environment variables neede d for the program/script to run; optional.
8. In Working Directory, type the name of the directory from which the program/script should be run; optional.
9. In Output Target File, type the the path to the file where output of the program/script execution is to be written; optional.
10. Select the Add Optional Params checkbox to include in the output file the date, account name, host name, and username.
11. Open the Schedule tab.
12. In Set Frequency, select the frequency of task execution: Never, Daily, Weekly, or Monthly, and then complete the options that appear for your selected frequencyselect the Database account to use, or click New to define a new Database account (see Creating an Account).
13. Enter the table name into which data is to be exported. Under 'database advanced settings', you can see the CREATE TABLE and INSERT statements that will be used.
14. To automate task execution, open the Schedule tab, and configure the scheduler as described in Scheduling a Task.
15. Click Save.
    The Batch Exection The Collection to Database task is saved.