TIBCO Spotfire File Writer


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:
April 2024: Fixed bug with uploading large SBDF files
December 2023: Updated to work with KNIME 5.1 and later, and Spotfire 12.x and 14.x
September 2022: Updated to work with KNIME 4.6 and later. Added support for binary columns. Many, many bug fixes.
IMPORTANT NOTE: May no longer work without valid certificate over https...
See: https://community.tibco.com/s/article/knime for details
February 2020: Better logging for https communication, various bug fixes, ability to ignore SSL certificate errors
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

Icon
Data to write to file

Output Ports

This node has no output ports

Popular Predecessors

  • Joiner4 %
  • Missing Value4 %
  • Duplicate Row Filter4 %
  • File Reader3 %
  • Excel Reader (XLS)3 %
  • Java Snippet2 %
  • String to Date&Time2 %
  • Data Generator2 %
  • String Manipulation (Variable)2 %
  • Excel Reader (XLS)2 %
  • Convert Workflow Credentials To Variable2 %
  • Java Edit Variable1 %
  • Loop End1 %
  • Row Filter1 %
  • String Manipulation1 %
  • Rule-based Row Filter1 %
  • Math Formula1 %
  • R Snippet1 %
  • DB Reader1 %
  • Joiner1 %
  • RDKit To Molecule1 %
  • Database Reader1 %
  • Table Writer1 %
  • Table Creator1 %
  • Sorter1 %
  • Rule-based Row Splitter1 %
  • Excel Reader (XLS)1 %
  • String to Date/Time (legacy)1 %
  • Column Auto Type Cast1 %
  • Date&Time Difference1 %
  • Variable Expressions1 %
  • RDKit Descriptor Calculation1 %
  • TIBCO Spotfire File Reader< 1 %
  • Concatenate< 1 %
  • Insert Column Header< 1 %
  • Column Resorter< 1 %
  • Constant Value Column< 1 %
  • Column Filter< 1 %
  • Row Splitter< 1 %
  • GroupBy< 1 %
  • Column Rename< 1 %
  • Rule Engine< 1 %
  • R Source (Table)< 1 %
  • TIBCO Spotfire File Writer< 1 %
  • String To Number< 1 %
  • Nominal Value Row Filter< 1 %
  • Column Expressions< 1 %
  • Date&Time to legacy Date&Time< 1 %
  • CSV Reader< 1 %
  • Path to String (Variable)< 1 %
  • Scorer< 1 %
  • Excel Reader< 1 %
  • List Files/Folders< 1 %
  • Hierarchical Clustering< 1 %
  • String To Number< 1 %
  • Missing Value Column Filter< 1 %
  • XLS Reader< 1 %
  • Extract Time Window (legacy)< 1 %
  • Fingerprint to String< 1 %
  • Reference Row Splitter< 1 %
  • Table Validator (Reference)< 1 %
  • Pivoting< 1 %
  • Double To Int< 1 %
  • Unpivoting< 1 %
  • RDKit Find Murcko Scaffolds< 1 %
  • Number To String< 1 %
  • Concatenate (Optional in)< 1 %
  • Column Combiner< 1 %
  • Column Merger< 1 %
  • Counter Generation< 1 %
  • Date/Time Shift< 1 %
  • TIBCO Spotfire Information Link Reader< 1 %
  • Number To String< 1 %
  • Column Appender< 1 %
  • IF Switch< 1 %
  • Credentials Input< 1 %
  • Column Comparator< 1 %
  • Rank< 1 %
  • Create File Name< 1 %
  • CSV Reader< 1 %
  • Database Connection Table Reader< 1 %
  • File Reader< 1 %
  • k-Means< 1 %
  • Scorer< 1 %
  • Column Rename (Regex)< 1 %
  • Double To Int< 1 %
  • Reference Column Filter< 1 %
  • Reference Column Resorter< 1 %
  • Column Splitter< 1 %
  • Math Formula (Multi Column)< 1 %
  • OSM Map to Image< 1 %
  • GET Request< 1 %
  • Time Difference< 1 %
  • String to URI< 1 %
  • Table Row to Variable< 1 %
  • PCA< 1 %
  • PCA Compute< 1 %
  • Tree Ensemble Predictor (Regression)< 1 %
  • Binner (Dictionary)< 1 %
  • Linear Correlation< 1 %
  • Domain Calculator< 1 %
  • Reference Row Filter< 1 %
  • RowID< 1 %
  • Renderer to Image< 1 %
  • Molecule Type Cast< 1 %
  • DB Query Reader< 1 %
  • Empty Table Creator< 1 %
  • k-Medoids< 1 %
  • SAS7BDAT Reader< 1 %
  • String Input< 1 %
  • Line Plot< 1 %
  • Date&Time to String< 1 %
  • Legacy Date&Time to Date&Time< 1 %
  • Date&Time-based Row Filter< 1 %
  • Date&Time Shift< 1 %
  • Mask Date/Time (legacy)< 1 %
  • Time to String (legacy)< 1 %
  • Molecular Properties< 1 %
  • RDKit Canon SMILES< 1 %
  • RDKit Diversity Picker< 1 %
  • MolImporter< 1 %
  • Loop End (2 ports)< 1 %
  • Cross Joiner< 1 %
  • Row Filter (Labs)< 1 %
  • Table Manipulator< 1 %
  • String Replacer< 1 %
  • SDF Reader< 1 %
  • Create File/Folder Variables< 1 %
  • Create Temp Folder< 1 %
  • Moving Average< 1 %

Popular Successors

Views

Default
Default view (empty)...

Workflows

Links

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.