Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Spotfire Data Virtualization

Create a File - JSON adapter, similar to the File - XML adapter

We get numerous data files that are constructed with JSON. We need to import these files, transform them then either output them as database views, or export them as csv files.
over 8 years ago in Spotfire Data Virtualization / data sources 4 Already exists

SingleStore and TDV: Make queries on tables that are on different databases but on the same SingleStore cluster run in push down

SingleStore does not have the concept of schemas, rather different databases are created instead of a single database with different schemas. This has an impact on the push down of queries that span different databases. This also limits the pushdo...
over 3 years ago in Spotfire Data Virtualization / performance 1 Unlikely to implement

TDV adapter for Teradata 20

Submitting this idea on behalf of DV account (Bank of America) for a dedicated adapter for Teradata 20 that support the version features.
about 1 year ago in Spotfire Data Virtualization / data sources 0 Future Consideration

Multiple Result windows for SQL Scratchpad

SQL Scratchpad is used a lot for data validations. Having the option of creating multiple "Result" panels would help to compare the dat abetween multiple queries.
over 8 years ago in Spotfire Data Virtualization / development 0 Future Consideration

We would like a document summarizing the incompatibility.

If a TDV version upgrade deprecates a feature, it will be noted in the documentation, but since there is no list of deprecated features, each feature must be checked individually. This is very inconvenient and we would like to have a document that...
over 3 years ago in Spotfire Data Virtualization 0 Future Consideration

Consistent Updates for adapters of major DBMS versions

Commit to adding support for new versions of the popular RDBMS within 6 months or the next service pack from their release. The major vendors should be supported, these are Oracle, Microsoft, and IBM.
over 8 years ago in Spotfire Data Virtualization / data sources 0 Future Consideration

Gather native stats from database platforms that support it

Currently, TDV calculates stats manually from analyzing the data. Where possible we should gather stats from database platforms that support it.
over 8 years ago in Spotfire Data Virtualization 0 Future Consideration

Add full support for Azure SQL Data Warehouse (DW) as a data source

Provide support for Azure SQL DW as a data source. Caching and data ship are out of scope initially. Please indicate in the comments if that is desired.
over 8 years ago in Spotfire Data Virtualization / data sources 0 Future Consideration

Support for multiple tenants within the server

Allow the server to support multiple separate tenants within one cluster. A tenant would include security users/groups, security policies, cache policies, data sources, shared resources and published interfaces comletely isolated from other tenant...
over 8 years ago in Spotfire Data Virtualization 1 Future Consideration

Local File Storage adapter cannot estimate date type

I have tested the following 5 patterns, but none of them could generate a DATE type. 1. value "20230201" + DateFormat "yyyy-MM-dd" → INTEGER 2. Value "20230201" + DateFormat "yyyyMMMdd" → INTEGER 3. Value "20230201" + DateFormat "yyyyMMMdd" → INTE...
over 3 years ago in Spotfire Data Virtualization / data sources 0 Future Consideration