Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Support local trust across multiple machines when working on application server farms

According to https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-44214 there are two options for trusting. Option #1 where the user can only trust their own queries is a useful method if you want to a) avoid that users are getting t...
over 5 years ago in Spotfire / Data Access 3 Future Consideration

Switch existing connection between in-mem and in-db

Once a native connector has been set for in-mem or in-db, you can not switch anymore to the other option. You have to create a new connector. The user interface is confusing because in the Data Tables properties, a field shows that Data is externa...
about 10 years ago in Spotfire / Data Access 0 Future Consideration

Open XML files

Easily open xml.
over 10 years ago in Spotfire / Data Access 2 Future Consideration

Change default encoding to Unicode (UTF8) when replacing data table in Spotfire using Ironpython script

refer to the support ticket - 01862613 We have code in place which replaces data table based on dynamic parameter passing for multi clustered sql data. This works perfectly fine in english. But since because the encoding cannot be done before load...
over 6 years ago in Spotfire / Data Access 3 Future Consideration

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...
over 4 years ago in Spotfire / Data Access 1 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 7 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...
almost 10 years ago in Spotfire / Data Access 7 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.
over 3 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...
over 5 years ago in Spotfire / Data Access / Information Services 1 Future Consideration