> How teiid handles the geometry data types in some of the data bases like Oracle. Are they supported ?
https://issues.jboss.org/browse/TEIID-2384 exists to update and expand our handling of spatial types.
> In case if I want to introduce a new data type in teiid , are APIs available to do so ?
https://issues.jboss.org/browse/TEIID-2502 added translator handling for source Structs to be imported as a Serializable Struct or an Array. If you want to use a different representation, then you would most likely want to handle that at the translator level by overriding the JDBCExcutionFactory.retrieveValue methods. There is a concept of a user defined type, but it would still map to the Teiid object type as the runttime type system is not current extensible to custom types in a meaningful way.