How to push Oracle " TO_CHAR " function in TIBCO Data Virtualization ?

How to push Oracle " TO_CHAR " function in TIBCO Data Virtualization ?

book

Article ID: KB0077303

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.6 and higher

Description

To push " TO_CHAR "  function from Oracle to TIBCO Data Virtualization, follow the steps provided in this KB article.

Issue/Introduction

How to push Oracle " TO_CHAR " function in TIBCO Data Virtualization ?

Environment

All operating systems

Resolution

1. Open the oracle_11g_thin_driver_values.xml file located under "[TDV Server Installation Directory] \conf\adapters\system\oracle_11g_thin_driver\" 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/TO_CHAR(@decimal,~decimal)</common:name>
  <common:type>STRING</common:type>
  <common:value>TO_CHAR($1, $2)</common:value>
  <common:configID>TO_CHAR(@decimal,~decimal)</common:configID>
</common:attribute>
<ns1:attribute xmlns:ns1="http://www.compositesw.com/services/system/util/common">
  <ns1:name>/custom/TO_CHAR(~any,~any)</ns1:name>
  <ns1:type>STRING</ns1:type>
  <ns1:value>TO_CHAR($1, $2)</ns1:value>
  <ns1:configID>TO_CHAR(~any,~any)</ns1:configID>
</ns1:attribute></common:attributes>
3. Save the file and restart the TDV Server and Repository services.
Powered by Wolken Software