Data Access

Showing 493

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

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

38 VOTE

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

almost 9 years ago in Spotfire / Data Access 0 Future Consideration

13 VOTE

Support impersonation in Data Connections via WebPlayer

As per case 02092109 we understand that what is no problem with Data Connections + fat client, Information Links + fat client and Information Links + WebPlayer, is not supported for Data Connections + WebPlayer. If the solution to https://ideas.ti...

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

21 VOTE

Change default encoding to Unicode (UTF8) when replacing data table in Spotfire using Ironpython script

refer to the support ticket - 01862613 We have code in place which replaces data table based on dynamic parameter passing for multi clustered sql data. This works perfectly fine in english. But since because the encoding cannot be done before load...

almost 5 years ago in Spotfire / Data Access 3 Future Consideration

23 VOTE

JDBC drivers - Summary with all download links

Checking for new versions of the drivers for N vendors is time consuming. The page https://community.tibco.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-35 contains some information, but you have to click through dozen of links...

over 5 years ago in Spotfire / Information Services 0 Future Consideration

18 VOTE

Allow configuring user rights for information designer and data connections with identical right sets

Independet from whether data is accessed using information links or data connections a company would like to be able to control the user rights in an identical way. In our case we would like to be able to define three analyst levels where setting...

over 4 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

8 VOTE

Wildcard or partial string matches for Data on Demand

I'm trying to work with Data on Demand with "string" type fields. We have a large database of error logs, and are trying to search through the log text to find mentions of a specific substring that can appear in slightly different places within th...

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

36 VOTE

Allow relinking of an existing information link to a different data source / database / table

I would like the ability to relink an existing information link to a new data source table when the table is exactly the same as the original. Currently, one would need to create a new information link or add the columns from the new table in the ...

almost 9 years ago in Spotfire / Information Services 9 Future Consideration

12 VOTE

Oracle databases with high number of schemas and tables, the loading time is very, very long and times out some time.

We have slow performance with some DB tools, which need long time to query Oracle data dictionary and that adding an Oracle hint /*+ RULE */ significantly speeded up e.g. SELECT /*+ RULE */ * from ALL_TAB_COLUMNS. Please provide the fix for this s...

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

37 VOTE

Open XML files

Easily open xml.

about 9 years ago in Spotfire / Data Access 2 Future Consideration

Please enter your email address

FILTER BY CATEGORY