Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 453

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

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

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

Spotfire Analyst - Open Information Designer to edit selected Information Link from Data canvas

With a right-click on the icon for the Information Link within the Data canvas, and/or with a button (see attached modified screenshot), the Information Designer would open for editing the selected Information Link. This would improve a lot the wo...
over 5 years ago in Spotfire / Information Services 0 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...
over 3 years ago in Spotfire / Data Access 0 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...
about 8 years ago in Spotfire / Data Access / Information Services 0 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...
over 3 years ago in Spotfire / Data Access 0 Future Consideration

Improve cube functionality in Spotfire

There is a lot of potential for improvements with using cubes in Spotfire. Here are some functions that I would like to see: Ability to use on-demand with cubes Cube dimensions to allow data types other than String (like Dates) Ability to "Limit d...
over 5 years ago in Spotfire / Data Access 1 Future Consideration