Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 481

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

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 diff...
over 7 years ago in Spotfire / Data Access 1 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

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

Add "Microsoft Studio" type of feature to browse a database's tables or views and see content and build query; this way data discovery is easier

In a startup company or when you are new toa company's data sources, "finding" valuable data is important and a lot of work. Today I use MS Studio to browse tables and views and build my queries; and then copy them to Spotfire, I'd like to do at l...
over 7 years ago in Spotfire / Data Access 1 Already exists

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. The...
over 7 years ago in Spotfire / Data Access / Information Services 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...
almost 4 years ago in Spotfire / Data Access 0 Future Consideration

Display a more user-friendly message when error is encountered during stored procedure execution

We used stored procedures to pass data to Spotfire. This should alleviate heavy data access from our server and to isolate the tables from our users. However, when error is encountered using this approach Spotfire returns a series of cryptic error...
over 7 years ago in Spotfire / Data Access 1 Future Consideration

Information Designer window backend and elements column no and sorting

In information designer we want that developer can see more number of column while creating column or joins ,currently its limited to 3 items only.Also there should be an option of keeping it in back end as floated windows so that user can switch ...
over 7 years ago in Spotfire / Data Access / Information Services 0 Future Consideration