Data Access

Showing 493 of 4417

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...

17 days ago in Spotfire / Data Access 0 To be Reviewed

631 VOTE

Microsoft 365 Sharepoint Online Files access

Our company has migrated to Office 365 SharePoint. Neither the Spotfire OData connector or Infomatix SharePoint Connector can connect to Office 365 SharePoint. They only work with on-premise implementations. We created workarounds to import ShareP...

almost 8 years ago in Spotfire / Data Access 54 Future Consideration

1 VOTE

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 ...

10 days ago in Spotfire / Data Access 0 To be Reviewed

1 VOTE

Remove the requirement for a Metadata URL when configuring the OAuth2 client

When configuring an OAuth2 client in the Spotfire server config GUI, the dialogue will not close unless a Metadata URL is entered. It is incorrect to require this since the OAuth 2.0 Authorization Framework (RFC 6749) does not require a metadata U...

12 days ago in Spotfire / Information Services 0 Future Consideration

1 VOTE

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.

12 days ago in Spotfire / Data Access 0 To be Reviewed

262 VOTE

Open analysis file without data

When doing support, we need to open DXP file with sometime HUGE amount of data. It would be useful to be able to open a DXP file in Spotfire Analyst, with a special option "Without Data". So we could just have a look to * how many data source the...

over 8 years ago in Spotfire / Data Access 13 Future Consideration

2 VOTE

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...

26 days ago in Spotfire / Data Access 0 To be Reviewed

265 VOTE

Add columns by matching on calculated columns

When adding columns from External data, it is currently not possible to match on columns that have been calculated in DXP.This could be useful for several purposes:* if casting of datatype is needed to perform the matching* if string trimming is n...

about 9 years ago in Spotfire / Data Access 5 Future Consideration

132 VOTE

Support temporary tables in data connections

When retrieving on-demand data Spotfire's information designer supports creating temporary tables to avoid huge WHERE clauses (link) which can not only be a performance issue but infact hinder a query from being executed completelly. Temporary tab...

almost 5 years ago in Spotfire / Data Access 5 Future Consideration

140 VOTE

Load Parquet, ORC and Avro data files from Amazon S3 and HDFS

Spotfire should be able to connect to and read Parquet, ORC and Avro files from Amazon S3 and HDFS.

about 7 years ago in Spotfire / Data Access 8 Future Consideration

Please enter your email address

FILTER BY CATEGORY