Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 494 of 4796

Static filters in in-database connectors (remove rows)

It should be possible to filter out rows based on an expression as global filter attributes. E.g. CREATED date > sysdate-365 or ROW_NUM<1000001 (Useful when debugging queries that have long run time to load a data subset
about 7 years ago in Spotfire / Data Access 0 Future Consideration

Kill existing Data Source connection to the database.

Sometimes the existing data source connection (say A)to the database hangs and no more new connections are established until the old connections are released. Though this can be increased(max connections) at data source level, a) It will not cl...
over 6 years ago in Spotfire / Information Services 1 Already exists

Native collaboration tool Trello connector https://trello.com/ to retrieve data from boards

Native collaboration tool Trello connector https://trello.com/ to retrieve data from boards Usefull for teams in Perkinelmer to create dashboards from boards , for scrum meetings, Agile, Weekly meetings follow uop
about 5 years ago in Spotfire / Data Access 1 Future Consideration

Support impersonation in Data Connections via WebPlayer

As per case 02092109 we understand that what is no problem with Data Connections + fat client, Information Links + fat client and Information Links + WebPlayer, is not supported for Data Connections + WebPlayer. If the solution to https://ideas.ti...
over 3 years ago in Spotfire / Data Access 0 Future Consideration

Multi-factor authentication to connect to Azure database

Trying to connect to Azure SQL DB (using Active Directory - Password), but every time trying to connect to the DB via Spotfire gets the error : ERROR MESSAGE:Cannot connect to '<servername>.database.windows.net'.System.AggregateException: On...
over 3 years ago in Spotfire / Data Access 1 Future Consideration

Validate data sources from a report.

It would be helpful to validate that all data sources are accessible for a report. If an information link, or network shared file gets removed, the report might only indicate a problem when updating data, but not be very clear when it does. Being ...
7 months ago in Spotfire / Data Access 0 To be Reviewed

Load all tabs of an Excel file at once

When importing an Excel file, provide the possibility to load all tabs into different data tables in one step
over 4 years ago in Spotfire / Data Access 1 Future Consideration

PI Connector to Spotfire

PI Connector to Spotfire is not very useful. It hangs when a larger data set is selected and the connector does not allow for multiple queries at the same time. The PI connector needs to be more like the one that is on the Spotfire Streaming platform
about 1 year ago in Spotfire / Data Access 0 Planning to implement

Google BigQuery API Timeout after 10 seconds

We have run into an issue which will stop us to develop any valuable datasets in Spotfire. So the situation is the following: When I run a query based on a table definition Spotfire kicks out a bigquery#table job which runs fine with no issues Whe...
about 5 years ago in Spotfire / Data Access 2 Future Consideration

Support Commen Table Expression (WITH) in data connection custom query

Commen Table Expresion (CTE) is currently not supported in the custom query. This would allow users to use temporary result set within the execution scope. We usually handle this with a store procedure, but its an issue on databases we are not all...
about 9 years ago in Spotfire / Data Access 7 Future Consideration