Problem Description:


Sqlserver ingestion using JTDS driver will create Infoworks ZIW audit columns with string datatype instead of timestamp datatype.

Root cause: 


This is an issue with the JTDS driver. JTDS Driver does not support date and datetime2 datatypes and these datatypes will be brought as a string in the hive.


Solution:


Set this "sql_server_jtds" configuration to true at the source level, truncate the table, recrawl schema and re-ingest the table. This should resolve the issue.



Applicable IWX versions:


2.4.x,2.5.x,2.6.x,2.7.x,2.8.x,2.9.x