Data Access

Showing 443

Syntax "with" using custom queries with SQLServer

To simplify the code using SQL Queries, it would be easy to use this syntax : "with my_table (C1) as (select column1 from table_dept) select C1 from my_table" Database : SQLServer

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

4 VOTE

Store calculated columns in data connections

If you have a lot of calculated columns in your analysis file, it's frustrating that the only way to share these is by duplicating the analysis file. If they could be stored in data connections these could be reused across multiple dashboards. The...

about 6 years ago in Spotfire / Data Access / Data Management 0 Future Consideration

4 VOTE

Search and locate connections based on guid

Connection to table shows connection name and not GUID. Name is not necessarily unique Source Properties on tables built from a connection does have GUID. This makes reverse trace harder. Searching on NAME is slow and may return duplicates or si...

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

4 VOTE

All connectors should be available in the web clients' flyout

I expect all connectors to be available in Business Author. Authoring connections to my data sources is the only reason for me to download the Spotfire Windows client.

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

4 VOTE

DATE datatype must be available in Cloudera Hive native data connector

DATE datatype is not available in Cloudera Hive native data connector though the DATE datatype is supported in HDI. So, when migrating from HDI to Cloudera HIVE, we are facing issues as we need to convert all the DATE datatype from DATE to TIMESTA...

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

1 VOTE

Add back MySQL data source template

We noticed that MySQL data source template is removed from Spotfire Server, that's quite confusing. We have lots of customers that utilize Information Link to retrieve data from MySQL, MySQL is commonly used and it's more than necessary to have a ...

over 1 year ago in Spotfire / Information Services 0 Future Consideration

5 VOTE

Information designer - Possibility to re-order columns in Calculated column, Filter, Join

Hello Order of colomn is important in Calculated colomn, Filter, Join, as we wrote %1, %2, %3 ... in the formula.Sometime we need to change a colomn, a get the new one in the same order... Now we can't. Could it be possible to add 2 buttons (Up / ...

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

4 VOTE

Allow the import of TIMESTAMP WITH LOCAL TIME ZONE datatype from Oracle database

Using Add Data tables option , I am trying to add Oracle 12 DB table but one Timestamp table field having datatype as "TIMESTAMP (3) WITH LOCAL TIME ZONE" is not visiable / showing up in Spotfire UI This is apparently not supported and it would be...

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

4 VOTE

AD Integration to SQL Server/Azure Database Connector

We are looking for AD Integration for SQL Server. Current usage of Spotfire (we've tested upto 7.11) does not support AD Integration for MS SQL.

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

3 VOTE

Hortonworks connector system trust store support

It's a pain to distribute and maintain certificate (.pem) files on Windows clients for the ODBC driver for Hortonworks. The Spotfire connector for Hortonworks should have a checkbox that enables the system trust store instead of the driver's local...

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

Please enter your email address

FILTER BY CATEGORY