Products | Versions |
---|---|
TIBCO Data Virtualization | 7.0.4.00.01 |
Native Sharepoint data adapter is always introspecting calculated column as BOOLEAN data type. Is it possible to change the default setting to some other datatype.
Within the Sharepoint datasource in TDV, there is a property called “Calculated Datatype”. This drop down lets you chose how the Calculated columns are introspected within DV. This drop down has valid values of:
“Boolean”
“DATE”
“DATETIME”
“DOUBLE”
“INTEGER”
“STRING”
The only caveat with this setting is - it will introspect all the Calculated columns as the datatype setup here. If you notice "BOOLEAN" all the time, that's because it is the default setting.
There is a governor which will overwrite this setting. If you set the "Other” field in the datasource to -> Calculated Data Type=“”, it will introspect the columns as per it’s original datatype in the Sharepoint site.