Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 436

allow Insert as Text in expression used by Row Filter transformation

Please allow Insert as Text in expression used by Row Filter transformation Customer would like to limit data by matching column to a string list(Document Property) using $map() function in Row Filter transformation, however currently Document Pro...
over 3 years ago in Spotfire / Data Access 0 Future Consideration

Add driver support for datetimeoffset datatype in Spotfire

Currently columns with datetimeoffset format are no available in information links when using MS SQL driver. Spotfire does not support the datetimeoffset datatype so any columns that have this format are "invisible" when accessing MS SQL databases...
over 3 years ago in Spotfire / Data Access / Data Management 0 Future Consideration

Reading multiple text files from file structure

Log file data from processing equipment is often automatically exported to a text file at a given location of a file tree. When there is a large amount of machines which generate new log files for each process run, automated gathering of this data...
over 6 years ago in Spotfire / Data Access 0 Future Consideration

Add pass-trough column naming patterns in Pivot Conditioning of the Information Designer for creating new Information Links

Pivoting functionality in Information Links helps reduce load time by pushing data preparation to server. Currently Pivot Conditioning functionality in Information Link dialogue of Information Designer does not allow Column name expressions for pa...
over 6 years ago in Spotfire / Information Services 0 Future Consideration

Fully Editable Data Tables

One is able to go through a wide variety of steps to build a data table. These include: choosing data sources, insert rows, columns, transformations, adding source of file column (during insert rows) etc etc... They should all be editable! Sometim...
almost 7 years ago in Spotfire / Data Access 0 Future Consideration

Establish Data Access to Airtable

As services like Airtable become more and more prominent especially for business users, currently there's no easy way to connect this to Spotfire. Everyone has to build his on connector via Python aso. Airtable is a good opportunity to get away fr...
over 3 years ago in Spotfire / Data Access 0 Future Consideration

Ability to output parameter value as-is without single or double quotes

Check the following use cases of that scenario: Very often template developers need ability to add custom-built expressions to queries in FROM, WHERE and ORDER BY parts. Multi-tenancy for templates: one set of template/IL/DS can be used for d...
almost 7 years ago in Spotfire / Data Access 1 Future Consideration

Import data from internet

It would be great if Spotfire could import a data table for the internet.; functionality that is similar to what is possible in Microsoft Excel or Power BI
almost 7 years ago in Spotfire / Data Access 0 Future Consideration

Connector for Apache Kylin

Spotfire should provide better support for Apache Kylin: http://kylin.apache.org/ At the moment, only a native ODBC connection is possible, where "keep data external" is not an option. As Kylin is a SQL based big data caching engine, "import data...
almost 7 years ago in Spotfire / Data Access 0 Future Consideration

Information Designer should be able to create ROLAP models

In IBM Cognos Framework Manager, it is possible to design ROLAP models that behave like a cube to the end user. With the introduction of columnar databases like DB2 BLU or Cloudera Impala, the speed is there to support on request aggregations. Th...
over 7 years ago in Spotfire / Data Access / Information Services 0 Future Consideration