External Data Object to ER/Studio DA Mappings

Go Up to External Data Object Export to ER/Studio DA

Exporting to ER/Studio DA is based on a pre-defined mapping to create the appropriate ER constructs from the External Data Objects. The first table below shows the Entity Attribute Datatype mappings. The second table shows the Table Column Datatypes.

Entity Attribute Datatypes	ER/Studio DA Object
Binary (W)	BINARY(W)
Boolean	BIT
Char(W)	CHAR(W)
Date	DATE
Decimal	DECIMAL(W, S)
Float	FLOAT
Integer	INTEGER
Long Binary	IMAGE / LONG BINARY
Money (W, S)	MONEY(W, S)
Timestamp	TIMESTAMP / DATE
Varchar (W)	VARCHAR (W)
XML	XML (ER 7.1 and above) or VARCHAR (W) (ER 7.0)

Table Column Datatypes	ER/Studio DA Object
Binary(W)	BIT VARYING (W)
Boolean	BIT
Char(W)	CHAR(W)
Date	DATE
Decimal	DECIMAL (W, S)
Float	FLOAT
Integer	INTEGER
Long Binary	VARCHAR (100)
Money(W, S)	DECIMAL(W, S)
Timestamp	TIMESTAMP
Varchar (W)	VARCHAR (W)
XML	VARCHAR (4000)