Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

    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 ...
    almost 8 years ago in Spotfire / Data Access 0 Future Consideration

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

    Abort queries in data connections

    Sometimes you realized the query you sent off is taking too long and/or was wrong. In that case you want to be able to abort the query to avoid data source overload. This is possible with information link based queries (there is a cancel button) b...
    almost 7 years ago in Spotfire / Data Access 3 Future Consideration

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

    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

    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
    The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group LLC. All rights reserved. This page and your use is governed by these Terms of Use.