Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 486

Support of SQL Complex Data Types (ARRAY, MAP, STRUCT)

In our databases (Oracle, Impala, ...) we use complex data types (ARRAYS, MAPS, STRUCTURES). Those data types are not supported today by Spotfire in-db connectors.
about 8 years ago in Spotfire / Data Access 0 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...
over 8 years ago in Spotfire / Data Access 0 Future Consideration

Decouple Database Selection from Data Source

When creating a Data Source, most Connectors currently include the selection of a Database and the Schema Browser shows just the Tables in the chosen Database. It would be preferable to just set the server cection details and then list all availab...
about 2 years ago in Spotfire / Data Access 0 Future Consideration

Open XML files

Easily open xml.
about 9 years ago in Spotfire / Data Access 2 Future Consideration

Improvements to the ability to select columns within transformations

I'd love to see the following features included in the interface for selecting columns within transformations. In the Exclude Transformation: 1) Identify the columns to not exclude (i.e include). If I have 100 columns, and 20 I want to include, it...
over 7 years ago in Spotfire / Data Access 1 Future Consideration

Allow relinking of an existing information link to a different data source / database / table

I would like the ability to relink an existing information link to a new data source table when the table is exactly the same as the original. Currently, one would need to create a new information link or add the columns from the new table in the ...
almost 9 years ago in Spotfire / Information Services 9 Future Consideration

Spotfire should support INOUT Parameters for RedShift Stored Procedure

Engineering team has determined this as an enhancement (which is kind of what we expected) as this is a relatively new feature in Redshift. There is an internal enhancement created for this to determine what it takes to support Redshift procedures...
almost 4 years ago in Spotfire / Data Access 1 Future Consideration

Customize Data Connectors

The ability to add JDBC connections exists but the DB DATA connectors is limited to a finite list. The need exists to be able to add additional data connectors to anything that you can configure and ODBC connection for. Adding data table does not ...
over 6 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...
over 8 years ago in Spotfire / Data Access 6 Future Consideration

Option to route Data Connector traffic from Analyst over Spotfire Server to work with secure data stores

Problem The Data Connector creates a direct connection from the Analyst or the Webplayer node to the data store, in contrast to information links as all is routed over the Spotfire Server. The Webplayer is in most cases located within an IT domain...
almost 5 years ago in Spotfire / Data Access 1 Future Consideration