Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Categories data sources
Created by Guest
Created on Jan 30, 2024

Include common XML capabilities pushdown into the product for SQL Server and Postgres

Include the following capabilities out-of-the-box with TDV.


Postgres 9.1 adapter - This allows for push-down to TDV catalog tables when converting Integer timestamp to actual timestamp.

TDV_HOME/conf/adapters/system/postgresql_9_1/postgresql_9_1_values.

<common:attribute xmlns:common="http://www.compositesw.com/services/system/util/common">

<common:name>/custom/TO_TIMESTAMP(~number)</common:name>

<common:type>STRING</common:type>

<common:value>TO_TIMESTAMP($1)</common:value>

<common:configID>TO_TIMESTAMP(~number)</common:configID>

</common:attribute>


SQL Server 2019 adapter - the attached file "microsoft_sql_server_2019_values.xml" contains common XML pushdown configurations for the following capabilities:

LTRIM, RTRIM, INSTR, GREATEST, LEAST, REVERSE, CONTAINS, NVARCHAR

  • Attach files