Adding a Collection to Database Task

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 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, 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 do not satisfy the above query.
7. In Connection Details, select the Database account to use, or click New to define a new Database account (see Creating an Account).
8. 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.
9. To automate task execution, open the Schedule tab, and configure the scheduler as described in Scheduling a Task.
10. Click Save.
    The Collection to Database task is saved.