How to introspect the OSIsoft PI GUID column type as a varchar in TIBCO Data Virtualization?

How to introspect the OSIsoft PI GUID column type as a varchar in TIBCO Data Virtualization?

book

Article ID: KB0074548

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.0 and later

Description

When using a TIBCO Data Virtualization (TDV) custom adapter to introspect the currently unsupported OSIsoft PI, a GUID column will be introspected as the "OTHER" type due to TDV's inability to recognize this column type from OSIsoft. This ambiguous column typing (OTHER) can prevent its participation in a TDV view or procedure later.

Issue/Introduction

This concerns a custom unsupported datasource.

Resolution

While this datasource remains unsupported at the time of writing, there is a way to make TDV interpret the GUID type as a varchar.

In your \conf\adapters\custom\<your custom adapter name>\<your custom adapter name>_values.xml file,
add this to the uncommented active block of xml:

<!--Adding an assigned varchar datatype for the GUID type -->
   <ns415:attribute>
      <common:name>/custom/jdbcds_datatype_guid</common:name>
      <common:type>STRING</common:type>
      <common:value>varchar</common:value>
      <common:configID>jdbcds.datatype.guid</common:configID>
   </ns415:attribute>


The use of a namespace 'ns415' is merely an arbitrary example here, you can name yours as appropriate to your file's contents. After saving the edit, restart the TDV service and re-introspect the PI data source or test by introspecting a new datasource with this adapter. Verify the column with a Native Type of GUID is now interpreted as a varchar Type in TDV.