Data Access

Showing 436

Apache Phoenix connector

Spotfire should include a connector for Apache Phoenix

5 months ago in Spotfire / Data Access 0 Future Consideration

Switch existing connection between in-mem and in-db

Once a native connector has been set for in-mem or in-db, you can not switch anymore to the other option. You have to create a new connector. The user interface is confusing because in the Data Tables properties, a field shows that Data is externa...

about 8 years ago in Spotfire / Data Access 0 Future Consideration

22 VOTE

Kill existing Data Source connection to the database.

Sometimes the existing data source connection (say A)to the database hangs and no more new connections are established until the old connections are released. Though this can be increased(max connections) at data source level, a) It will not...

almost 5 years ago in Spotfire / Information Services 1 Future Consideration

11 VOTE

Spotfire client opens 5 connections to database when using Oracle data connectors, and hold them till closing the client

When we use a data connection to retrieve data from an Oracle database, the Spotfire client opens 5 connections to the database with each usage. Those connections remain open even after you close the template using File > Close. The only way to...

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

25 VOTE

Static filters in in-database connectors (remove rows)

It should be possible to filter out rows based on an expression as global filter attributes. E.g. CREATED date > sysdate-365 or ROW_NUM<1000001 (Useful when debugging queries that have long run time to load a data subset

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

37 VOTE

Open XML files

Easily open xml.

over 8 years ago in Spotfire / Data Access 2 Future Consideration

10 VOTE

Multi-factor authentication to connect to Azure database

Trying to connect to Azure SQL DB (using Active Directory - Password), but every time trying to connect to the DB via Spotfire gets the error : ERROR MESSAGE:Cannot connect to '<servername>.database.windows.net'.System.AggregateException: On...

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

8 VOTE

Analyze data connection and custom queries using Application Profiler

We are using Spotfire Application Profiler to analyze and quality control in bulk all Spotfire dashboards within a certain library folder and this is very powerful and useful. One of the most important topics is to be able to analyze the data conn...

almost 2 years ago in Spotfire / Data Access 2 Future Consideration

17 VOTE

Spotfire Analyst - Open Information Designer to edit selected Information Link from Data canvas

With a right-click on the icon for the Information Link within the Data canvas, and/or with a button (see attached modified screenshot), the Information Designer would open for editing the selected Information Link. This would improve a lot the wo...

almost 4 years ago in Spotfire / Information Services 0 Future Consideration

1 VOTE

reduce sql statement length for data connection

Customer is facing error as below that indicates the length of SQL exceeds the limite by the database when loading data from Google BigQuery via connector/data connection. The query is too large. The maximum standard SQL query length is 1024.00K c...

3 months ago in Spotfire / Data Access 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY