sql support

Showing 14 of 4760

TZCONVERTOR SQL import failure

In cases where the data source provides a valid date but an "unacceptable" timestamp, SQL imports fail with an error message stating "Illegal instant due to time zone offset transition." While this issue is not uncommon across various systems, we'...

over 1 year ago in TIBCO Data Virtualization / sql support 0 Future Consideration

11 VOTE

Recursive CTE Support

I need to be able to query TDV views recursively. CTEs are great for this, but currently I just get the error "invalid table" when referring to the CTE name within the CTE.

over 4 years ago in TIBCO Data Virtualization / sql support 0 To be Reviewed

4 VOTE

When I process a JOIN key item in the SQL panel and regenerate the model, the join line is not displayed correctly.

When I create a query in the SQL panel with the following join keys processed and then regenerate the model, the join line is displayed in a position unrelated to the columns.Could you please fix it so that the line connects at the column specifie...

over 2 years ago in TIBCO Data Virtualization / sql support 0 Planning to implement

4 VOTE

I would like the ability to search columns to join tables on the model tab.

When joining tables in the Model tab, the columns to be joined must be found in the UI and joined. This reduces productivity when there are many columns. This reduces productivity because of the time and effort required to search for the target co...

over 2 years ago in TIBCO Data Virtualization / sql support 1 Future Consideration

6 VOTE

Propagate changes in one layer to the following layers

If you use different layers and change the fieldname in one of the early layers, the subsequent layers need to be changed accordingly, by hand. Using the lineage information it should be possible to propagate such a change throughout the layers.

about 4 years ago in TIBCO Data Virtualization / sql support 0 To be Reviewed

2 VOTE

add support to insert boolean data into TDV even though backend database does not support boolean data type

We are developing a Spotfire custom module which connects to TDV 8.7 and run DDL(create table & insert) against it. TDV then performs DDL against backend database so the actual data from Spotfire is stored in the backend database and published...

over 1 year ago in TIBCO Data Virtualization / sql support 0 To be Reviewed

7 VOTE

Add support for ARRAY data type, as in postgres or greenplum

Our users are accessing postgres and greenplum databases which have tables making use of the ARRAY data type (modifier), typically on character varying and double precision basic data types. Out users ask if there is any method or function to inde...

over 6 years ago in TIBCO Data Virtualization / sql support 0 Future Consideration

8 VOTE

Function compatibility help

Information of supported functions is essential in order to write good performing queries. Function support for Data Sources could he part of Studio help. Developers could quickly check the compatibility of functions used in their queries.

over 7 years ago in TIBCO Data Virtualization / sql support 5 Future Consideration

5 VOTE

Support LAG and LEAD functions for DB2

LAG and LEAD functions are supported by DB2, so a push down should not be very hard.

about 6 years ago in TIBCO Data Virtualization / sql support 2 Future Consideration

5 VOTE

Support Oracle 18c

No description provided

over 6 years ago in TIBCO Data Virtualization / sql support 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY