Skip to Main Content
Spotfire Ideas Portal

Data Access

Showing 472

use parameter as identifier in Information link SQL

From time to time, we receive requests from our customers that they want to load data from database where table name is dynamic, e.g. on demand load data from different tablenames all of them have the same column structure. Unfortunately currently...
5 days ago in Spotfire / Data Access 0 To be Reviewed
624 VOTE

Microsoft 365 Sharepoint Online Files access

Our company has migrated to Office 365 SharePoint. Neither the Spotfire OData connector or Infomatix SharePoint Connector can connect to Office 365 SharePoint. They only work with on-premise implementations. We created workarounds to import ShareP...
about 7 years ago in Spotfire / Data Access 52 Future Consideration
257 VOTE

Open analysis file without data

When doing support, we need to open DXP file with sometime HUGE amount of data. It would be useful to be able to open a DXP file in Spotfire Analyst, with a special option "Without Data". So we could just have a look to * how many data source ...
over 7 years ago in Spotfire / Data Access 12 Future Consideration
264 VOTE

Add columns by matching on calculated columns

When adding columns from External data, it is currently not possible to match on columns that have been calculated in DXP.This could be useful for several purposes:* if casting of datatype is needed to perform the matching* if string trimming is n...
over 8 years ago in Spotfire / Data Access 5 Future Consideration
130 VOTE

Support temporary tables in data connections

When retrieving on-demand data Spotfire's information designer supports creating temporary tables to avoid huge WHERE clauses (link) which can not only be a performance issue but infact hinder a query from being executed completelly. Temporary tab...
about 4 years ago in Spotfire / Data Access 5 Future Consideration

Improve metadata loading performance in the Google BigQuery connector

When a user has access to many projects with many tables in Google BigQuery it may take a long time to list all the tables when configuring a connection in Spotfire. This is somewhat mitigated by turning of the setting Connectors > Google BigQu...
about 1 month ago in Spotfire / Data Access 0 Future Consideration

Connectivity with Graph Databases

Be able to connect to graph DBs like Ne04j without using data functions and to interactively query it to create network charts.
about 2 months 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...
over 1 year ago in Spotfire / Data Access 0 Future Consideration

Allow any type of authentication for the SharePoint connector; now, Spotfire only supports OAuth2.

Customers are trying to configure their Azure AD for SAML authentication, but the Spotfire SharePoint connector does not support this.
about 2 years ago in Spotfire / Data Access 0 Future Consideration
100 VOTE

Support for Clickhouse of column-oriented database

we are currently storing analysis data in the ClickhouseDB, want to create an environment for analysis using BI tool. As we know, Clickhouse has a JDBC Driver ( ), but Spotfire doesn't support Clickhou...
over 4 years ago in Spotfire / Data Access 0 Future Consideration