Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Support for opening Microsoft Purview-protected Excel files in Spotfire

Currently, when an Excel file is saved with the "Strictly Confidential" sensitivity label, the user who saved the file can open the file normally in Excel, but cannot open the same file in Spotfire. It would be appreciated if Spotfire could suppor...
13 days ago in Spotfire / Data Access 0 To be Reviewed
637 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...
over 9 years ago in Spotfire / Data Access 54 Planning to implement

Enhance the Azure Analysis Services connector to dynamically generate and push down DAX statistical queries (like MEDIAN and PERCENTILE.INC), enabling natively supported Box Plots and Histograms while keeping data in External (Live) Mode.

The Use Case: As organizations increasingly adopt Microsoft Fabric and centralized Semantic Models (via Azure AS / XMLA endpoints) to handle massive enterprise datasets, Spotfire data scientists need to leverage Spotfire's statistical visualizatio...
about 1 month ago in Spotfire / Data Access 0 Future Consideration

Improve UX when ODBC connection fails due to SQL errors

When setting up an ODBC connection, if the SQL(custom query) is incorrect, the process restarts from the beginning (from the connection settings), which is an issue. It would be helpful if it returned to the SQL input screen. Furthermore, being ab...
3 months ago in Spotfire / Data Access 0 To be Reviewed
272 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...
almost 10 years ago in Spotfire / Data Access 13 Future Consideration
264 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...
over 10 years ago in Spotfire / Data Access 5 Future Consideration

Support Parameterization of SELECT Clause in Custom Queries

Enable parameterization of the SELECT statement (column list) within custom SQL queries in Spotfire. Currently, query parameters can be used in filters and conditions, but not to dynamically control which columns are returned. This limits flexibil...
6 months ago in Spotfire / Data Access 1 Future Consideration
133 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...
over 6 years ago in Spotfire / Data Access 6 Future Consideration

allow to discard automatically detected name row when importing data from excel

We learnt from support that I quote, Spotfire automatically identifies the first row containing only string values and uses it as the name row. Currently, this behavior cannot be modified when importing an Excel file. For example if we have a exce...
about 1 month ago in Spotfire / Data Access 0 To be Reviewed
182 VOTE

Better support of web services

When you need to consume data from a web service in Spotfire there are different options like implementing a custom data source, develop an Iron Python script, use an R script on your Stats server or use something like Composite or Jboss Teiid tha...
about 10 years ago in Spotfire / Data Access 5 Future Consideration