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.


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: