JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision ---------------------------------------------------------------------------------------------- Key: TEIIDDES-2865 URL: https://issues.jboss.org/browse/TEIIDDES-2865 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 10.0, 9.0.5, 9.0.6, 9.0.7 Reporter: Debbie Steigner Assignee: Barry LaFond Labels: release_notes Fix For: 11.1.2 Attachments: debTest2Import.png, debtestImport.png, importedColumns.png JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision and should be 9. I believe this https://issues.jboss.org/browse/TEIIDDES-2746 may have changed the behavior, in version 9.0.3 it imports correctly. You can use jdbc:sqlserver://ENGNTDBS14.mw.lab.eng.bos.redhat.com:1433;databaseName=mss_eds user - mss_eds password - mss_eds table - debtest2, both columns are numeric(9,2)