Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 497 of 4803

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

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...
11 months ago in Spotfire / Information Services 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

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...
over 9 years ago in Spotfire / Data Access 7 Future Consideration

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
over 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...
almost 4 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...
almost 4 years ago in Spotfire / Data Access 1 Future Consideration

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
almost 5 years ago in Spotfire / Data Access 1 Future Consideration

Open session commands (pre post statements) for data connections

We have many data sources that implement row level security using features such as Oracle’s VPD. This relies on the ability for Spotfire to provide the end user identity whenever running SQL on the database - which is easily achieved using the Ope...
over 6 years ago in Spotfire / Data Access 6 Future Consideration

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