To add a Collection to Database task (this task will export data from XpoLog log into a specified database):
- Open the Tasks console (see Tasks), and click the New Task button.
- In the page that opens, select the Collection to Database option, and then click Continue.
The Collection to DatabaseTask page opens. - In Name, type the name of the new task.
- In Description, type a description of the new task; optional.
- 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 that will be exported to a database. - In Data Filter Query, type a query to filter out events that don't satisfy the above query.
- In Connection Details, select the Database account to use, or click New to define a new Database account (see Creating an Account).
- Enter the table name that data will be exported into. Under 'database advanced settings' you can see the CREATE TABLE and INSERT statements that will be used.
- Open the Schedule tab.
- In Set Frequency, select the frequency of task execution: Never, Daily, Weekly, or Monthly, and then complete the options that appear for your selected frequency.
- Click Save.
The Collection to Database task is saved.
{"serverDuration": 232, "requestCorrelationId": "dd9b5fe4890f493a94b1e655fbb65f22"}