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