MongoDB and Transformation Data Types
When you define the schema in the Informatica MongoDB ODBC driver, you can view the ODBC data types and edit the data types. When you import a MongoDB collection as a source or target object, the transformation data types corresponding to the ODBC data types appear in Informatica Cloud.
The Informatica MongoDB ODBC driver reads MongoDB data and converts the MongoDB data types to ODBC data types. The Secure Agent converts the ODBC data types to transformation data types.
The following table lists the MongoDB data types and the corresponding ODBC and transformation data types:
MongoDB Data Types | ODBC Data Types | Transformation Data Types | Range and Description |
|---|
String | Varchar | String | 1 to 104,857,600 characters |
Boolean | Bit | String | Precision of 1 |
NumberLong | BigInt | Decimal | Precision 1 to 28 digits, scale 0 to 28 |
NumberInt | Int | Integer | Precision 10, scale 0 |
NumberDouble | Double | Double | Precision 15 |
BinData | Binary | Binary | 1 to 104,857,600 bytes |
Date | Timestamp | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to second) |
jstOID | Varchar | String | 1 to 104,857,600 characters |