Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

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

Be able to connect SFTP from Spotfire

The goal is to be able to connect Spotfire to a SFTP datasource. This need is ask many to from our business. It's quite more easy than a specific API connector for example.
almost 4 years ago in Spotfire / Data Access 0 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 7 years ago in Spotfire / Data Access 6 Future Consideration

Allow configuring user rights for information designer and data connections with identical right sets

Independet from whether data is accessed using information links or data connections a company would like to be able to control the user rights in an identical way. In our case we would like to be able to define three analyst levels where „setting...
almost 6 years ago in Spotfire / Data Access / Information Services 1 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
almost 6 years ago in Spotfire / Data Access 1 Future Consideration

Make the Information Designer remember where I last was!

100 times a day. Open Information Designer, navigate complex folder hierarchy, change something...close Information Designer. 2 minutes later, open Information Designer...all the folders are collapsed again, start from scratch navigating the folde...
almost 9 years ago in Spotfire / Data Access / Information Services 0 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
over 5 years ago in Spotfire / Data Access 1 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...
almost 6 years ago in Spotfire / Data Access 2 Future Consideration

Wildcard or partial string matches for Data on Demand

I'm trying to work with Data on Demand with "string" type fields. We have a large database of error logs, and are trying to search through the log text to find mentions of a specific substring that can appear in slightly different places within th...
over 3 years ago in Spotfire / Data Access 0 Future Consideration

Support scalar stored procedures

Currently a stored procedure needs to return a table with at least one column in order for Spotfire to create the stored procedure element in Information designer. In Databases like Snowflake, we can have stored procs that only return a scalar val...
almost 7 years ago in Spotfire / Data Access / Information Services 1 Future Consideration