Overview of Export Nodes

Export nodes provide a mechanism for exporting data in various formats to interface with your other software tools.

The following export nodes are available:

The Database export node writes data to an ODBC-compliant relational data source. In order to write to an ODBC data source, the data source must exist and you must have write permission for it.
The Flat File export node outputs data to a delimited text file. It is useful for exporting data that can be read by other analysis or spreadsheet software.
The Statistics Export node outputs data in IBM® SPSS® Statistics .sav or .zsav format. The .sav or .zsav files can be read by IBM SPSS Statistics Base and other products. This is also the format used for cache files in IBM SPSS Modeler.
The Data Collection export node outputs data in the format used by Data Collection market research software. A Data Collection Data Library must be installed to use this node.
The IBM Cognos Export node exports data in a format that can be read by Cognos databases.
The IBM Cognos TM1 Export node exports data in a format that can be read by Cognos TM1 databases.
The SAS export node outputs data in SAS format, to be read into SAS or a SAS-compatible software package. Three SAS file formats are available: SAS for Windows/OS2, SAS for UNIX, or SAS Version 7/8.
The Excel export node outputs data in the Microsoft Excel .xlsx file format. Optionally, you can choose to launch Excel automatically and open the exported file when the node is executed.
The XML export node outputs data to a file in XML format. You can optionally create an XML source node to read the exported data back into the stream.
The JSON export node outputs data in JSON format. See JSON Export node for more information.