TIBCO Spotfire File Writer

SpotfireFileWriter-Node extension for KNIME Workbench version 1.8.24 by TIBCO

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:
(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)

• Rule Engine (11 %) PredictorStreamable
• Joiner (8 %) Manipulator
• Concatenate (8 %) ManipulatorStreamable
• Column Filter (8 %) ManipulatorStreamable
• Row Filter (6 %) ManipulatorStreamable
• Rule-based Row Filter (5 %) ManipulatorStreamable
• Math Formula (5 %) ManipulatorStreamable
• Column Rename (4 %) ManipulatorStreamable
• Java Snippet (3 %) ManipulatorStreamable
• GroupBy (3 %) Manipulator
• String to Date/Time (legacy) (3 %) ManipulatorStreamable
• CSV Reader (3 %) Source
• Column Resorter (3 %) ManipulatorStreamable
• Pivoting (3 %) Manipulator
• TIBCO Spotfire File Reader (2 %) Source
• Table Writer (2 %) Sink
• Loop End (2 %) LoopEnd
• Concatenate (Optional in) (2 %) ManipulatorStreamable
• Insert Column Header (2 %) Manipulator
• Counter Generation (2 %) Manipulator
• Create File Name (< 1 %) Other
• Database Reader (< 1 %) Source
• File Reader (< 1 %) SourceStreamable
• Table Creator (< 1 %) Source
• Java Edit Variable (< 1 %) Manipulator
• Column Combiner (< 1 %) ManipulatorStreamable
• String To Number (< 1 %) ManipulatorStreamable
• Column Appender (< 1 %) ManipulatorStreamable
• Constant Value Column (< 1 %) ManipulatorStreamable
• Missing Value Column Filter (< 1 %) Manipulator
• Row Splitter (< 1 %) ManipulatorStreamable
• Missing Value (< 1 %) Manipulator
• Sorter (< 1 %) Manipulator
• String Manipulation (< 1 %) ManipulatorStreamable
• Math Formula (Multi Column) (< 1 %) ManipulatorStreamable
• XLS Reader (< 1 %) SourceDeprecated
• Excel Reader (XLS) (< 1 %) SourceStreamableDeprecated
• R Source (Table) (< 1 %) Source
• R Snippet (< 1 %) Manipulator
• Date/Time Shift (legacy) (< 1 %) Manipulator
• String to Date/Time (legacy) (< 1 %) ManipulatorStreamable
• k-Means (< 1 %) Learner
• Scorer (< 1 %) Other
• Binner (Dictionary) (< 1 %) ManipulatorStreamable
• Column Merger (< 1 %) ManipulatorStreamable
• Column Rename (Regex) (< 1 %) ManipulatorStreamable
• Double To Int (< 1 %) ManipulatorStreamableDeprecated
• Reference Column Filter (< 1 %) ManipulatorStreamable
• Reference Column Resorter (< 1 %) ManipulatorStreamable
• Column Splitter (< 1 %) ManipulatorStreamable
• Rule-based Row Splitter (< 1 %) ManipulatorStreamable
• Data Generator (< 1 %) SourceStreamable
• GET Request (< 1 %) ManipulatorStreamable
• String to Date&Time (< 1 %) ManipulatorStreamable
• Time Difference (legacy) (< 1 %) Manipulator
• Time to String (legacy) (< 1 %) ManipulatorStreamable
• Show all 56 recommendations

Best Friends (Outgoing)

• Merge Variables (68 %) Other
• Timer Info (20 %) Sink
• Send Email (8 %) Other
• TIBCO Spotfire File Reader (4 %) Source

Installation

To use this node in KNIME, install SpotfireFileWriter-Node extension for KNIME Workbench from the following update site: