Schedule Data Extracts

Serviceaide Intelligent Service Management Operations team does the scheduling and managing Data Extracts task. Customers can request for a Full Extract or for setting up a schedule for Delta Extracts.

Scheduling Full Extracts

In Full Extract all the data from the database for a given slice is extracted without any time restrictions. When Data Extract is requested for the first time, we recommend that a Full Extract is scheduled. After extracting data in a slice; delta extracts are used to clarify the modifications during a set duration.

A Full Extract can be scheduled on your request.

Scheduling Delta Extracts

The Delta Extract process extracts data that was modified between a specified start date and end date.

The Delta Extracts are run using three variables:

• Slice - specifies the Slice ID of the customer for whom the Data Extract is being scheduled.
• Start-Date - specifies the start date of tickets that must be considered to extract from the database.
• End-Date - specifies the end date of tickets that must be considered to extract from database.

We recommend that the Delta Extracts for short durations are carried out without intervals between one End-Date and the Start-Date. However, it is also possible to schedule delta extracts based on any start date and end date.

A customer can request data for one day, two days, four days, five days, and so on.

The following time-related considerations are taken into account when requesting for a Delta Extract:

• The Delta Extract package uses GMT as the time-zone for extracting the data.
• The Data Extract fetches data for a minimum of 24 hours from 00:00:00 GMT to 23:59:59 GMT.

For example: When a Data Extract was requested for data that was modified in the last 24 hours, and the extract is scheduled at 10 Jul 2011 22:00 EST; at this time the current date in GMT is 11 Jul 2011 03:00 GMT. The Start-Date for the Data-Extract is Current Date in GMT - 2, which is 9 Jul 2011 00:00 GMT and the End Date is Current Date in GMT - 1, which is 10 Jul 2011 23:59 GMT.

The Slice Time zone has no bearing on the fetching of data. Data is fetched from the customer database that is based on current date time in GMT.

The Data Extract mdb file has some additional Date columns where the date is converted into Text. This conversion is done so that the data is  in a readable format. These columns do not exist inside the Database; they are only in the mdb file.

For these Date Text fields present in the data extract package, time-zone is converted to the slice time. The Time Zone that is considered for conversions is picked from the Slice Configuration Parameter DEFAULT_TIMEZONE.

Note: When the contact timezone is not specified as the contact record is created or updated, the time-zone of the contact is set as slice default timezone parameter value.