Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 474 of 4253

Add Connectivity to Canary Data Historian

As an oil & gas client, we collect millions of data points from field/plant automation points through Cygnet and store data in the Canary data historian - a NoSQL timeseries database. Canary suggests using the ODBC driver to connect to Spotfir...
1 day ago in Spotfire / Data Access 0 To be Reviewed
626 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
265 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

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

configure OAuth2IdentityProviders for Analyst in no-server mode

With the newly added MS SQL Server connector since 14.2, by using "Identity provider(oauth2)" authentication method, we were able to connect to MS SQL Server via OAuth2 authentication. However, the identity provider must be configured in advance i...
17 days ago in Spotfire / Data Access 0 To be Reviewed
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 ( https://github.com/ClickHouse/clickhouse-jdbc ), but Spotfire doesn't support Clickhou...
over 4 years ago in Spotfire / Data Access 0 Future Consideration

Snowflake web authentication support

The Spotfire connector for Snowflake should support browser based federated authentication login to Snowflake, for example via Okta. Integration with Azure AD is expected as well.
over 4 years ago in Spotfire / Data Access 9 Planning to implement