Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 490 of 4416

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

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...
14 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]=...
10 days ago in Spotfire / Data Access 0 To be Reviewed

A function that centrally visualizes and manages what databases dashboards created on Spotfire are connected to.

Currently, we can check what database each dashboard created in Spotfire is connected to by opening the dashboard and displaying the data canvas. However, in the above, we can only check the dashboard that is open. We would like a function that al...
13 days ago in Spotfire / Data Access 0 To be Reviewed
260 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
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
101 VOTE

Snowflake web authentication support

The Spotfire connector for Snowflake should support browser based federated authentication login to Snowflake, for example via Okta. Integration with Azure AD is expected as well.
about 5 years ago in Spotfire / Data Access 9 Planning to implement