Connector for Text Data Types

The following tables show the correspondences of Connector for Text data types to HCL Enterprise Integrator (HEI) data types for various types of activity.

(p) -- Indicates that if Allow Precision Loss is not enabled, then an error will be generated on the type match. Allowing precision loss is the default.
(o) -- Indicates that overflow checking will be performed when data is being transferred. If an overflow occurs and Truncate Data When Necessary is enabled, then the data is truncated; if not an error is generated.
Text, Number, or Time indicates single value unless otherwise specified.
The Connector for Text option Maximum Length for Text Data alters the default bound of 64996 for HEI Text.

Execute

The Execute data types are listed as follows.


Text	Connector API
Number (suffix .n for implied decimal)	single value
Number (with defined SEPARATOR string)	allow multivalues
DateTime	single value
Datetime (with defined SEPARATOR string)	allow multivalues
Text	single value
Text (with defined SEPARATOR string)	allow multivalues
Rich Text
Numeric
Currency

Fetch

The Fetch data types are listed as follows.


Connector API		Text
Int		Number (p, o)
Float		Number
Currency		Currency
Numeric		Numeric
Datetime		Datetime
Text (o)		Text, Rich Text, Formula
Binary (o)	BLOB	Text, Number allow multiple values, Time allow multiple values, Rich Text
	composite	Text (single value), Rich Text
	number list	Number, Text (single value)
	datetime list	Time, Text (single value)
	text list	Text

Insert

The Insert data types are listed as follows.


Connector API		Text
Int		Number
Float		Number
Currency		Currency
Numeric		Numeric
Datetime		Datetime
Text		Text, Rich Text
Binary	BLOB	Text (o), Number (allow multiple values) (o), Time (allow multiple values) (o), Rich Text
	composite	Text (single value) (o), Rich Text
	number list	Number (o), Text (single value) (o)
	datetime list	Time (o), Text (single value) (o)
	text list	Text (o)

Create

The Create data types are listed as follows.


Connector API		Text
Int		Number (single value)
Float		Number (single value)
Currency		Currency
Numeric		Numeric
Datetime		Time (single value)
Text	bounded	Text (single value)
	unbounded	Rich Text
Binary	BLOB	Text (single value)
	composite	Rich Text
	number list	Number (allow multiple values)
	datetime list	Time (allow multiple values)
	text list	Text (allow multiple values)