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
Popular Predecessors
Joiner4 %- Missing Value4 %
- Duplicate Row Filter4 %
- File Reader3 %
- Joiner3 %
Excel Reader (XLS)2 %- Java Snippet2 %
- String to Date&Time2 %
- Date&Time Difference2 %
- Data Generator2 %
- String Manipulation (Variable)2 %
Excel Reader (XLS)2 %- Java Edit Variable1 %
Loop End1 %- Column Filter1 %
Row Filter (deprecated)1 %Column Rename1 %- String Manipulation1 %
- Rule-based Row Filter1 %
- Math Formula1 %
- R Snippet1 %
- DB Reader1 %
- 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 %
- Variable Expressions (legacy)1 %
- RDKit Descriptor Calculation1 %
- TIBCO Spotfire File Reader< 1 %
- Concatenate< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Resorter< 1 %
- Constant Value Column< 1 %
Row Splitter (deprecated)< 1 %- GroupBy< 1 %
- Rule Engine< 1 %
- R Source (Table)< 1 %
- TIBCO Spotfire File Writer< 1 %
- String to Number< 1 %
- Nominal Value Row Filter< 1 %
- Column Expressions (legacy)< 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 %
- Pivot< 1 %
- Double to Integer< 1 %
- Unpivot< 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 (legacy)< 1 %
- TIBCO Spotfire Information Link Reader< 1 %
Number To String< 1 %Column Appender< 1 %- IF Switch< 1 %
- Credentials Input (legacy)< 1 %
- Column Comparator< 1 %
- Rank< 1 %
- Create File Name (legacy)< 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 (legacy)< 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 (legacy)< 1 %
- Line Plot (JavaScript)< 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 %
Views
- Default
- Default view (empty)...
Workflows
4. Projects_SpotfireKNIME Hub- 4. Projects_SpotfireKNIME Hub
- 4. Projects_SpotfireKNIME Hub
- Export_to_SpotfireKNIME Hub
- Export_to_SpotfireKNIME Hub
- Show all 8 workflows
Links
- No links available
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.