TIBCO Spotfire File Writer

NOW UPDATED to work with Spotfire 7.5 and above!
NOW UPDATED to support Spotfire Binary Data files and to upload SBDF to the Spotfire Library!

This node creates a TIBCO Spotfire SBDF or STDF data file from the input table. SBDF is Spotfire Binary Data Format and is the preferred Spotfire native file format. STDF (Spotfire Text) is also included for support for legacy applications.

The node also complies with the latest KNIME file writer standards and so you can use knime://knime.workflow/file.sbdf (to write to a location relative to the root of the workflow folder) or knime://knime.mountpoint/file.sbdf (to write to a location relative to the root of the workspace folder).

To write to the Spotfire library, the URL must be in the format http(s)://spotfireserver:port/spotfire/libraryPath/file.sbdf - note that STDF cannot be saved in the Spotfire library.

IMPORTANT! You must use the Spotfire application server (TIBCO Spotfire Server), not the web server (Consumer/Business Author). Also, you MUST make sure the url contains /spotfire/ immediately after the server name.
Known Issues: When new file writer node is placed on the workspace canvas, the workflow credentials functionality does not work initially. If you connect an input to the node, the workflow credentials will then be available.
Recent enhancements:
October 2019: Many fixes and updates
(February 2018): Bug fixes for upload to Spotfire library functionality
(February 2017): Major overhaul of architecture; updated to work with Spotfire 7.5 and later; many bug fixes
(December 2015): when uploading to the Spotfire library, send the data in 2Mb chunks; implemented the Long data type; fixed issues with losing precision of double values

Options

Selected File

The name of the file to write to. Must end in .SBDF (preferred) or .STDF

Overwrite file

If the destination file exists, it will be overwritten or execution of the node will be halted, dependent on this setting

Username and Password

The username and password for the user with upload privileges on the Spotfire library. The user must have permission to write to the folder specified in the URL

Input Ports

Data to write to file

Views

Default

Default view (empty)...

Best Friends (Incoming)

• Joiner (10 %) 
• Column Rename (8 %) Streamable
• TIBCO Spotfire File Reader (6 %) 
• Concatenate (6 %) Streamable
• Rule Engine (6 %) Streamable
• Column Filter (5 %) Streamable
• Rule-based Row Filter (4 %) Streamable
• Row Filter (3 %) Streamable
• GroupBy (3 %) 
• String Manipulation (2 %) Streamable
• Math Formula (2 %) Streamable
• String to Date/Time (legacy) (2 %) Streamable
• Java Snippet (2 %) Streamable
• Loop End (2 %) 
• String To Number (2 %) StreamableDeprecated
• Insert Column Header (2 %) 
• Column Resorter (2 %) Streamable
• Constant Value Column (2 %) Streamable
• Table Validator (Reference) (2 %) 
• Row Splitter (2 %) Streamable
• Pivoting (2 %) 
• R Source (Table) (2 %) 
• Create File Name (< 1 %) 
• CSV Reader (< 1 %) 
• Database Connection Table Reader (legacy) (< 1 %) 
• Database Reader (legacy) (< 1 %) 
• File Reader (< 1 %) Streamable
• Table Writer (< 1 %) 
• Table Creator (< 1 %) 
• Java Edit Variable (< 1 %) 
• Hierarchical Clustering (< 1 %) 
• k-Means (< 1 %) 
• Scorer (< 1 %) 
• Concatenate (Optional in) (< 1 %) Streamable
• Column Combiner (< 1 %) Streamable
• Column Merger (< 1 %) Streamable
• Column Rename (Regex) (< 1 %) Streamable
• Double To Int (< 1 %) StreamableDeprecated
• Reference Column Filter (< 1 %) Streamable
• Missing Value Column Filter (< 1 %) 
• Missing Value (< 1 %) 
• Reference Column Resorter (< 1 %) Streamable
• Sorter (< 1 %) 
• Column Splitter (< 1 %) Streamable
• Rule-based Row Splitter (< 1 %) Streamable
• Data Generator (< 1 %) Streamable
• Counter Generation (< 1 %) 
• Math Formula (Multi Column) (< 1 %) Streamable
• OSM Map to Image (< 1 %) 
• XLS Reader (< 1 %) Deprecated
• Excel Reader (XLS) (< 1 %) StreamableDeprecated
• R Snippet (< 1 %) 
• GET Request (< 1 %) Streamable
• Date/Time Shift (legacy) (< 1 %) 
• Time Difference (legacy) (< 1 %) 
• String to Date/Time (legacy) (< 1 %) Streamable
• Show all 56 recommendations

Best Friends (Outgoing)

• Merge Variables (29 %) 
• Timer Info (29 %) 
• Wait... (18 %) 
• TIBCO Spotfire File Reader (12 %) 
• Loop End (6 %) 
• Send Email (6 %) 
• Show all 6 recommendations

Installation

To use this node in KNIME, install Spotfire File Nodes from the following update site:

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.