Data Access

Showing 497

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...

almost 3 years ago in Spotfire / Data Access 0 Future Consideration

32 VOTE

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

22 VOTE

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

18 VOTE

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

13 VOTE

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

13 VOTE

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

1 VOTE

Smart Data Source Optimizer

In many enterprise Spotfire deployments, reports connect to wide tables or views via JDBC or Infolinks, often bringing in 50–200 columns by default—even when only a fraction of these columns are actually used in visualizations, expressions, or scr...

4 months ago in Spotfire / Data Management / Information Services 0 Future Consideration

16 VOTE

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

22 VOTE

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...

almost 7 years ago in Spotfire / Data Access 6 Future Consideration

17 VOTE

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

Please enter your email address

FILTER BY CATEGORY