Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 484

Take advantage of Oracle RAC's "Universal Connection Pool (UCP) for JDBC" feature to achieve seamless failover of in-use database connections when an Oracle RAC node fails.

Our Spotfire IM (information model) sources from a database running on a multi-node Oracle Real Application Cluster (Oracle RAC). When a single node of this RAC goes down (either because of a hardware problem or for routine maintenance) the Oracle...
almost 9 years ago in Spotfire / Data Access 0 Future Consideration

Provide ability to filter rows being imported from flat files (such as Excel or csv)

Having the ability to filter rows being retrieved from flat files is important, especially when they get to be over 1M rows, workstation memory resources could become an issue. Of the 2.7M rows in my file, I only need 51K rows. I need to be able t...
almost 9 years ago in Spotfire / Data Access 0 Future Consideration

Support for multiple Authentication mode for a single Data Connector in web.config

Connect to a database using connector through different authentication modes. Connect to two SSAS databases and want to connect to one with Kerberos Authentication and to another with WebConfig mode.
almost 9 years ago in Spotfire / Data Access 0 Future Consideration

Change Data Type in Multiple Column Elements panel

1. Open Information Designer 2. Create Elements: Multiple Columns 3. Add an entire data table's worth of columns Result: You can not change the data type in this pane like you can in the single element pane Expected: You should be able to edit the...
almost 9 years ago in Spotfire / Data Access 1 Future Consideration

Users should only need acess to IL:s - not underlying elements

Give users access to Information links without worrying about or having to give them access/display the underlying elements. "Some of the end users are getting the message in the link decription as per:"Some elements previously added to the Inform...
almost 9 years ago in Spotfire / Data Access 0 Future Consideration

Add ability to filter in-db queries during configuration of the source.

We currently initially query the data source for all its content, after setting up a new in-database connection. This can longer than wanted, if the underlying data store contains a large volume of items. So the customer would like to be able to f...
almost 9 years ago in Spotfire / Data Access 1 Future Consideration

Show user id when stored credentials in a data source is used

When a data source is created and saved with stored credentials, the user id is not seen when the data source is being used by end users. End users often use data connections that are based on the source but have no way to tell which user is actua...
about 6 years ago in Spotfire / Data Access 1 Future Consideration

Spotfire Hive connector, set hive execution engine=spark

Hi, We have a Hadoop big data cluster with Map Reduce as the default Hive execution engine. It is key for us to be able in Spotfire Hive Connector to change the Hive execution engine (set hive.execution.engine=spark). Kind Regards
about 6 years ago in Spotfire / Data Access 0 Future Consideration

Add Data Table from Data Connection in Library - Should not default to select all tables in connection

Currently, when you add a data table from a Data Connection In A Library, the window opens up and all tables within the connection are selected by default. There is no "deselect all" option so it's the chore of unchecking them one-by-one. I have q...
about 6 years ago in Spotfire / Data Access 0 Future Consideration

Better JSON parsing support

When you get JSON strings and you need to extract a few fields to table format for Spotfire consumption it would be nice having an efficient and easy to use parser to do this out of the box. Something like: JSONGetField( JSONString, ”afieldname” ...
about 6 years ago in Spotfire / Data Access 0 Future Consideration