Atrium Integration Engine 7.1 Supported Data Types

The list of supported data types in the documentation for AIE 7.1 is incomplete. The following is an updated list of supported data types for use in mappings.

                                                                                                                                                                          
SQLOracle 10GDB2XML
Int                

               smallint                

               

               tinyint                

               

               bigint                

               

               decimal                

               

               numeric                

               

               money                

               

               smallmoney                

               

               float                

               

               real                

               

               datetime                

               

               smalldatetime                

               

               char                

               

               varchar                

               

               text                

               

               nchar                

               

               nvarchar                

               

               timestamp                

               

               sqlvariant                

               
               

               int                

               

               smallint                

               

               numeric                

               

               number                

               

               decimal                

               

               float                

               

               real                

               

               date                

               

               timestamp                

               

               char                

               

               varchar2                

               

               nchar                

               

               nvarchar                

               

               long                

               
Integer                

               SmallInt                

               

               BigInt                

               

               Character                

               

               Varchar                

               

               NChar                

               

               NVarchar                

               

               Date                

               

               Time                

               

               TimeStamp                

               
string                

               boolean                

               

               decimal                

               

               float                

               

               double                

               

               dateTime                

               

               time                

               

               date