How to push "DATE_TRUNC" function from TIBCO Data Virtualization to Greenplum Data source?

How to push "DATE_TRUNC" function from TIBCO Data Virtualization to Greenplum Data source?

book

Article ID: KB0073687

calendar_today

Updated On:

Products

TIBCO Data Virtualization

Description

To push "DATE_TRUNC" function from TIBCO Data Virtualization to Greenplum Data source, follow the steps provided in this KB article.

Issue/Introduction

How to push "DATE_TRUNC" function from TIBCO Data Virtualization to Greenplum Data source?

Environment

All operating systems.

Resolution

1. Open the greenplum_4_3_values.xml file located under "[TDV Server Installation Directory] \conf\adapters\system\greenplum_4_3\" folder in a text editor.
2. Append the following code at the end of the file.
<common:attributes xmlns:common="http://www.compositesw.com/services/system/util/common">
<common:attribute xmlns:common="http://www.compositesw.com/services/system/util/common">
  <common:name>/custom/DATE_TRUNC(~string,~date)</common:name>
  <common:type>STRING</common:type>
  <common:value>DATE_TRUNC($1,$2)</common:value>
  <common:configID>DATE_TRUNC(~string,~date)</common:configID>
</common:attribute>
<ns1:attribute xmlns:ns1="http://www.compositesw.com/services/system/util/common">
  <ns1:name>/custom/DATE_TRUNC(~any,~any)</ns1:name>
  <ns1:type>STRING</ns1:type>
  <ns1:value>DATE_TRUNC($1,$2)</ns1:value>
  <ns1:configID>DATE_TRUNC(~any,~any)</ns1:configID>
</ns1:attribute></common:attributes>
3. Save the file and restart the TDV Server and Repository services.