Export objects are used in WhereScape RED to produce ascii files from a single database table or view for a downstream feed. Some or all of the columns in a table or view can be exported.
There are three ways of performing exports in RED:
- File export - an export where most of the processing is managed and controlled by the scheduler
- Script-based export - an export where a Windows script file is executed to perform the export. Script-based exports on Windows supports both DOS Batch and PowerShell scripts.
- Integration Services Export - an export processed using a Windows connection where the processing is handled via an Integration Services Package that is generated and executed dynamically at run time. SSIS exports to UNIX/Linux connections and processed via the UNIX/Linux scheduler are currently not supported.