Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

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

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

Spotfire native connector for Bigquery need to restrict table list to the selected billing project

Spotfire native connector (using OAuth credentials) need a new selection prompt for "Project" in addition to the existing "Billing Project" selection prompt, so that the connector returns only the list of tables the user is granted access to in Bi...
over 3 years ago in Spotfire / Data Access 2 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
almost 8 years ago in Spotfire / Data Access 0 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

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

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.
almost 4 years ago in Spotfire / Data Access 0 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...
almost 6 years ago in Spotfire / Data Access / Information Services 1 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...
almost 9 years ago in Spotfire / Data Access / Information Services 0 Future Consideration