In this article
The Data Processing module is built on the SQL Server Integration Services (SSIS) architecture. The module consists of:
- Data Sources.
- Action Script (Data cleaning / recoding / transformation).
- Data Targets (destinations).
The module uses the Triple-S Survey Data Interchange standard (go to About Triple-S for more information).
Figure 1 - The basic data processing flow
Data Processing supports the following sources and targets:
Sources:
- Text File (comma, and tab delimited)
- Triple-S XML (version 1.1, 1.2, 2.0)
- Forsta Survey (one or multiple surveys)
- Excel file
Targets (destinations)
- Text File (comma, and tab delimited)
- Triple-S XML (version 1.1, 1.2, 2.0)
- Forsta Survey (one survey only)
- Excel file
- SPSS
- Quantum
- SAS
- Fixed width file
Action Script (data transformation)
- JScript.NET
The action script allows you to modify the values of the columns provided by the source. This means that the columns read by the source can be altered by the action script, and passed into the destination.
Note: The action script cannot introduce new columns into the database.