Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 5

Enable Execution of Database Statements in (Custom) Queries

If one fires a custom query, Spotfire builds a SELECT * FROM () around the query. This means that only queries with a SELECT statement are supported. However, I often have the case that I want to use other SQL statements. For example, the statemen...
20 days ago in Spotfire / Data Access 0 To be Reviewed

Allow a Spotfire DXP file to be opened from a Web location

Our current implementation for the Spotfire analyst client is still converting the webdav URL to an UNC path and then feed Spotfire. The UNC-based solution requires the windows WebDav client service to work properly. An implementation was done in ...
13 days ago in Spotfire / Data Access 0 To be Reviewed

support to load data from csv/txt/excel etc files via FTP protocol

One of our customers would like to have the ability to load data from csv/txt/excel etc files via FTP protocol.
15 days ago in Spotfire / Data Access 0 To be Reviewed

speed up csv load

Attached screenshot indicates that csv file load is much slower than stdf or sbdf. It makes sense that sbdf is fast because it's binary, however we didn't expect stdf is almost as fast as sbdf. Since both csv and stdf are text files and the size o...
29 days ago in Spotfire / Data Access 0 To be Reviewed

add capability to use a piece of sql expression in custom expressions

Hello, We understand that available functions are limited in custom expressions when data is loaded as external. Our customer would like to have the ability to specify a piece of sql expression like below in custom expressions. CASE WHEN [column]=...
25 days ago in Spotfire / Data Access 0 To be Reviewed