MongoDB
MongoDB is a NoSQL database program. It uses JSON-like documents with schemas.
Information noteIndustry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.
Supported MongoDB versions
The followings database versions are supported:
- 4.4
- 5.0
- 6.0
Supported MongoDB data types
The following MongoDB data types are supported by the MongoDB Connector.
- Date
- DBPointer
- Decimal
- JavaScript
- JavaScript (with scope) -- Not supported as string. Converts to SQL_VARCHAR.
- LongVarbinary
- MaxKey
- MinKey
- NumberDouble
- NumberInt
- NumberLong
- ObjectID
- Regular Expression
- String
- Symbol
- Timestamp
- Undefined
- Varbinary