Data Access

Showing 484

Import Named Ranges from MS Excel

Importing a Named Range can facilitate easier and repeatable linkage between Excel and Spotfire when the page format in Excel is a report style or contains other information other than a data table of rows and columns.

over 3 years ago in Spotfire / Data Access 0 Future Consideration

2 VOTE

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

2 VOTE

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

2 VOTE

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

1 VOTE

Showing up the status of dashboard rendering

As of Spotfire 10.10.4 version, we have identified that the dashboard library path is showing up. Instead, in my opinion it would be nice to show the where exactly my request is. Meaning, when any user click on the dashboard link. Request sent to ...

over 3 years ago in Spotfire / Data Access 1 Future Consideration

1 VOTE

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

2 VOTE

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

1 VOTE

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...

almost 4 years ago in Spotfire / Data Access / Data Management 0 Future Consideration

2 VOTE

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

2 VOTE

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...

almost 8 years ago in Spotfire / Data Access 1 Future Consideration

Please enter your email address

FILTER BY CATEGORY