The input type determines the type of data that the Integration Service passes to
Engine. The input type determines whether the input is data or a source file path.
Configure one of the following input types:
Buffer. The Unstructured Data transformation receives source data in the InputBuffer port. The Integration Service passes source rows from the InputBuffer port to
File. The Unstructured Data transformation receives the source file path in the InputBuffer port. The Integration Service passes the source file path to
Engine opens the source file. Use the File input type to parse binary files such as Microsoft Excel or Microsoft Word files.
If you do not define output groups and ports, the Unstructured Data transformation returns data based on the output type.
Configure one of the following output types:
Buffer. The Unstructured Data transformation returns XML through the Outputbuffer port. You must connect an XML Parser transformation to the Outputbuffer port.
Engine writes the output file instead of passing data to the Integration Service.
Engine names the output file based on the file name from the OutputFilename port. Choose the File output type to transform XML to binary data such as a PDF file or a Microsoft Excel file.
The Integration Service returns the output file name in the OutputBuffer port for each source row. If the output file name is blank, the Integration Service returns a row error. When an error occurs, the Integration Service writes a null value to the OutputBuffer and returns a row error.
Splitting. The Unstructured Data transformation splits XML data from
Engine into multiple segments. Choose the Splitting output type when the Unstructured Data transformation returns XML files that are too large for the OutputBuffer port. When you configure Splitting output, pass the XML data to the XML Parser transformation. Configure the XML Parser transformation to process the multiple XML rows as one XML file.