Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 494 of 4428

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

Oracle databases with high number of schemas and tables, the loading time is very, very long and times out some time.

We have slow performance with some DB tools, which need long time to query Oracle data dictionary and that adding an Oracle hint /*+ RULE */ significantly speeded up e.g. SELECT /*+ RULE */ * from ALL_TAB_COLUMNS. Please provide the fix for this s...
about 3 years ago in Spotfire / Data Access 0 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...
about 2 years ago in Spotfire / Data Access 0 Future Consideration

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
over 6 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 5 years ago in Spotfire / Information Services 1 Already exists

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...
about 3 years ago in Spotfire / Data Access 1 Future Consideration

Support optional prompts in data connections

Information links allow for both optional and mandatory prompts but data connections seem to only support mandatory ones. This means you cannot have a data connection which serves multiple uses cases where one user would like to filter data by a d...
about 3 years ago in Spotfire / Data Access 0 Likely to implement

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...
over 7 years ago in Spotfire / Data Access / Information Services 0 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...
over 4 years ago in Spotfire / Data Access 2 Future Consideration

Allow SQL queries to select columns based on Spotfire input

Certain data lake solutions are optimized for column access (e.g. Google's BigQuery). Trying to access a column in BQ using Spotfire fails because a string literal is the only option for the variable. If a second variable option was available that...
almost 3 years ago in Spotfire / Data Access 0 Future Consideration