Various methods to use XML as a datasource in Spotfire

Various methods to use XML as a datasource in Spotfire

Spotfire cannot use XML as a datasource out-of-the-box. It only works with a table-based structure as input such as a CSV-file, Excel-file, a database table, etc. The XML always needs to be converted into a table like structure first. Listed below are some of the options to consider.
 

You may use one of the following approaches:

* Script - Use a Python script (needs to be aware of the schema of the XML) to produce, e.g., a CSV file or insert data into a database table.

* SQL/XML query - If the XML data is already in a database, use a SQL/XML query that produces as output a "regular", XML-free table (or use a view definition).

*Custom Extension -  Extend Spotfire to create a custom data source that parses the XML. The data source would need to be schema-aware or configurable.  TIBCO Spotfire SDK contains an example to create a custom data source which can be used as a reference (SDK\Examples\Extensions\SpotfireDeveloper.CustomDataSourceExample).

*TIBCO Spotfire Advanced Data Services - Use TIBCO Spotfire Advanced Data Services (ADS). Additional licensing will be required to use this product. ADS can produce a table-like structures suitable for consumption in Spotfire.