Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 442

Spotfire client opens 5 connections to database when using Oracle data connectors, and hold them till closing the client

When we use a data connection to retrieve data from an Oracle database, the Spotfire client opens 5 connections to the database with each usage. Those connections remain open even after you close the template using File > Close. The only way to...
almost 3 years ago in Spotfire / Data Access 1 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 4 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 5 years ago in Spotfire / Data Access 6 Future Consideration

"RequestTimeout" and "ConnectionTimeout" parameters on the Spotfire Connector UI

We found that Spotfire Connector UI don't have any parameter to specific the "RequestTimeout" and "ConnectionTimeout" yet. TS_10.10.3.13 LTS HF-016: Hotfix for TIBCO Spotfire® 10.10.x (Released: May 31, 2021) TSDC-6625 - Added timeouts for the TIB...
about 3 years ago in Spotfire / Data Access 0 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...
over 2 years ago in Spotfire / Data Access 0 Future Consideration

Allow excluding a column from the resulting view for Information Links

When loading data from SQL or other external sources, the right hand panel labeled "Columns in Selected View" allows users to unselect fields that are not needed in the analysis. When loading data from an information link, the user is required to ...
7 months ago in Spotfire / Data Access / Information Services 0 Future Consideration

Delegate CIFS to sharepoint online

Now,The SharePoint online Kerberos delegation is not working cause we cannot setup CIFS for fileshare. It would be great if we can setup CIFS to SharePoint online for refresh data on web player. https://support.tibco.com/s/article/Constrained-Kerb...
about 4 years ago in Spotfire / Data Access 0 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...
about 8 years ago in Spotfire / Data Access 6 Future Consideration

Improved support information link sub-queries

The support for sub-queries in information designer is quite limited such that it is e.g. not possible to move prompts inside the sub-query. You can find details in the community and in the support portal.
over 3 years ago in Spotfire / Information Services 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...
about 5 years ago in Spotfire / Data Access / Information Services 1 Future Consideration