Data Integration Hub Connector Guide > Data Integration Hub Data Type Reference > Data Integration Hub and Transformation Data Types
  

Data Integration Hub and Transformation Data Types

Informatica Cloud uses the JDBC type 4 driver to read data. The Secure Agent converts the Data Integration Hub data type to the transformation data type, and uses the transformation data type to move data across platforms.
When Informatica Cloud writes to a Data Integration Hub target, the Secure Agent converts the transformation data type to the corresponding Data Integration Hub data type. When Informatica Cloud reads from a Data Integration Hub source, the Secure Agent converts the Data Integration Hub data type to the corresponding transformation data type.
The following table compares the Data Integration Hub data types that Informatica Clouds supports to the transformation data types:
Data Integration Hub Data Type
Transformation Data Type
Range
BIGINT
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
BINARY
Binary
1 to 104,857,600 bytes
BIT
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
BLOB
Binary
1 to 104,857,600 bytes
BOOLEAN
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
CHAR
String
1 to 104,857,600 characters
CLOB
Text
1 to 104,857,600 characters
DATE
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
DECIMAL
Decimal
Precision 1 to 28, scale 0 to 28
DOUBLE
Double
Precision 15
FLOAT
Double
Precision 15
INTEGER
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
LONGVARBINARY
Binary
1 to 104,857,600 bytes
LONGVARCHAR
Text
1 to 104,857,600 characters
NUMERIC
Decimal
Precision 1 to 28, scale 0 to 28
REAL
Double
Precision 15
SMALLINT
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
TIME
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
TIMESTAMP
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
TINYINT
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
VARBINARY
Binary
1 to 104,857,600 bytes
VARCHAR
String
1 to 104,857,600 characters