...
Data extraction is the process of retrieving data from the Serviceaide Intelligent Service Management data source.
...
The customer uses this data for customized reporting purposes.
A set of scripts enable Data Extract that run against the production database of the customer. The script executes queries to extract data from the Database. The extracted data is exported to a Microsoft Access file. The customer uses this data for customized reporting purposes.
The Data Extract process runs on the server that hosts the production databases of the customer. The data dump is uploaded to an SFTP site provided by the customer. Customers can then download this data.
...
Data can be extracted for a specific customer slice (based on Slice ID). If the time period is specified, Data extraction can be of two typesTwo types of data extractions are available:
- Full Extract - All the data in the given slice is extracted; without any time restriction.
- Delta Extract - Data that was modified during a specified period is extracted. Delta Extract is done generated on the basis of the Start Date and End Date that is specified for the Delta Extract. We recommend that data extraction for the first time is a Full Extract.
| Info |
|---|
Full Data Extract is provided as a SQL Backup file. The backup file can be restored in any MS SQL Standard/Web/Dev edition server, 2016 or higher. Delta Data extracts are provided as Access MDB file. There is a file size restriction of 2GB for the Delta data extracts. |
Schema Information
While some records are extracted during full extracts; most other entities are extracted during both Delta Extracts and Full Extracts.
...