I have one specific query on Teiid designer tool, when I was doing the process of Import of various tables from Schema, then I found the respective data types of individual field name was reflected as "Object" instead of actual data type in the Orginal table. So each time I have to change the data type after the process of Import was done. So can't we expect the orginal data types to be refected, after import also... See the figure below.
which database? which JDBC driver are you using. Basically Designer uses the Database metadata reported by the JDBC driver, in this case the driver you are using might not be correctly reporting. Also what were the some of the native types on DB?