Data Access

Showing 453

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

over 1 year ago in Spotfire / Data Access 0 Future Consideration

5 VOTE

Faster Selection Options For "Data Selection in Connection"

When trying to import data tables into a Spotfire project from a cube connection, it's important to limit the amount of data coming in. Under "Add Data Tables" -> Add -> "Microsoft SQL Server Analysis Services" -> "Data Selection In Conne...

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

2 VOTE

Open File & Replace Data Tables on Data->Other->SQLDirect

In order not to lose work, it would be good if a database connected by SQLDirect (in Menu Data->Sources->Others->) has been deleted (for example, because a server has been migrated), the dxp allows to replace said tablepointing to a new d...

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

1 VOTE

Spotfire BigQuery connector to support BIGNUMERIC

We are seeing pulling data into Spotfire from GCP BigQuery as BIGNUMERIC type columns are not fetched. Updating BigQuery or adding another view does not help due to problematic data values. Can a hotfix on spotfire 12 version be provided.

over 1 year ago in Spotfire / Data Access 0 Future Consideration

1 VOTE

Column selection/prompting for a Data Connection or Information Link

Description Background Data Connections and Information Links have a _prompting_ option such that users may filter the incoming data, *before* it's loaded into a .dxp. The users' selections are translated into _WHERE_ clauses in the underlying SQL...

over 1 year ago in Spotfire / Data Access 0 Future Consideration

5 VOTE

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

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

4 VOTE

Improved progress information when reports are loading

It's difficult to determine how long a report is going to take to load. This can be for a number of reasons, including the fact that Spotfire will likely not know how much data is going to be returned from databases. So it's accepted that a "% Com...

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

3 VOTE

Add capability to access graph DBs / triple stores

e.g. by allowing accessing these via SPARQL

about 5 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 7 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 7 years ago in Spotfire / Data Access 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY