An Output object ('OUTP') takes a data flow and stores it for use outside Integrator. An output object optionally defines the data columns that are to be saved. If no columns are specified, all possible data columns from the flow are saved. Data can be saved in files, SQL tables, sent to the Builder, or sent to a UNIX pipe (UNIX systems). Use output objects to:
- Create models using the Builder Output Object.
- Create cBases using the cBase Output Object.
- Allow Integrator scripts to execute command scripts based on Integrator input using the Execrows Output Object.
- Save data to a file using the Fileout Output Object that can then be used as input to Builder or other software tool.
- Call and iterate other tasks or task lists, varying parameters based on columns in the input flow using the Iterate Output Object.
- Allow data to be fed into a UNIX pipe using the Pipe Output Object (UNIX Only).
- Allow parameters to be set for later tasks in the script using the Setparm Output Object.
- Split data into separate output files for different sets of data using the Split Output Object.
- Define data to be written to an ODBC accessible database using the SQL Output Object.
- Access data from external data sources using the Tunnel Output Object.