Identify your version
-
(LATEST)
version 3
Setup
| Replication
-
version 2
Setup
| Replication
-
version 1
Setup
| Replication
-
SUNSET
version 11-01-2016
Setup
| Replication
MongoDB updates
MongoDB version history
All versions for Stitch's MongoDB integration, including release and deprecation dates.
| Version | Status | Release | Deprecation | End of life (Sunset) |
| version 3 (latest) | Released | July 27, 2023 | ||
| version 2 | Deprecated | February 14, 2020 | July 27, 2023 | |
| version 1 | Deprecated | November 4, 2019 | February 14, 2020 | |
| version 11-01-2016 | Sunset | January 11, 2016 | November 21, 2019 | February 2, 2020 |
MongoDB changelog
The five most recent updates made to the MongoDB integration. Refer to the MongoDB Integration Changelog for this integration's full history.
| Date | Type | Entry title |
| May 14, 2024 | Improvement | MongoDB (v3) update: String projection |
| Feb 14, 2024 | Improvement | MongoDB (v3) update: MongoDB server not supporting sessions |
| Jan 11, 2024 | Bug fix | MongoDB (v3) bug fix: Session timeout |
| Oct 5, 2023 | Bug fix | MongoDB (v3) bug fix: SSL issue |
| Jul 27, 2023 | New feature | MongoDB integration: New version (v3) now available! |
| View all entries in the MongoDB Integration Changelog | ||
MongoDB version features
In this section:
MongoDB version comparison
|
MongoDB version 3 (latest) |
MongoDB version 2 |
MongoDB version 1 |
|||
| STITCH | |||||
| Release status |
Released on July 27, 2023 |
Deprecated on July 27, 2023 |
Deprecated on February 14, 2020 |
||
| Supported by | |||||
| Stitch plan |
Standard |
Standard |
Standard |
||
| Supported versions |
3.6 through 7.0 |
2.6 through 5.0 |
2.6 through 4.0 |
||
| API availability |
Available |
Not available |
Not available |
||
| Singer GitHub repository | |||||
| CONNECTION METHODS | |||||
| SSH connections |
Supported |
Supported |
Supported |
||
| SSL connections |
Supported |
Supported |
Supported |
||
| REPLICATION SETTINGS | |||||
| Anchor Scheduling |
Supported |
Supported |
Supported |
||
| Advanced Scheduling |
Supported |
Supported |
Supported |
||
| Table-level reset |
Supported |
Supported |
Supported |
||
| Configurable Replication Methods |
Supported |
Supported |
Supported |
||
| REPLICATION METHODS | |||||
| Log-based Replication |
Supported |
Supported |
Supported |
||
| Key-based Replication |
Supported |
Supported |
Supported |
||
| Full Table Replication |
Supported |
Supported |
Supported |
||
| DATA SELECTION | |||||
| Table selection |
Supported |
Supported |
Supported |
||
| Column selection |
Supported |
Supported |
Supported |
||
| View replication |
Unsupported |
Unsupported |
Unsupported |
||
| Select all |
Supported, with prerequisites |
Supported, with prerequisites |
Supported |
||
| TRANSPARENCY | |||||
| Extraction Logs |
Supported |
Supported |
Supported |
||
| Loading Reports |
Supported |
Supported |
Supported |
||
Data types
In the table below are the data types MongoDB integrations support and the Stitch data type it will map to, depending on the version of the integration being used:
- indicates that the data type is supported. Following the icon is the Stitch data type it will map to.
- indicates that the data type is supported, but there is additional information you should know. Hover over the icon to view a tooltip with the information.
- indicates that the data type isn't applicable to the integration. This is usually because the integration doesn't use that particular data type.
- indicates that the data type isn't supported. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.
Refer to the Data typing guide for more info about how Stitch identifies and types data when it's loaded into your destination.
Note: This table doesn't display info for versions that have been sunset.
|
MongoDB version 3 (latest) |
MongoDB version 2 |
MongoDB version 1 |
|
| ARRAY | ARRAY | ARRAY | ARRAY |
| BIGINT | |||
| BIT | |||
| BSON_DATETIME | STRING , formatted as DATE-TIME | STRING , formatted as DATE-TIME | STRING |
| CHAR | |||
| DATE | STRING , formatted as DATE-TIME | STRING , formatted as DATE-TIME | STRING |
| DBREF | OBJECT | OBJECT | OBJECT |
| DECIMAL | |||
| DECIMAL128 | DECIMAL | DECIMAL | DOUBLE |
| DOUBLE | NUMBER | NUMBER | DECIMAL/DOUBLE |
| FLOAT | NUMBER | NUMBER | DECIMAL/DOUBLE |
| INT64 | INTEGER | INTEGER | INTEGER |
| INTEGER | INTEGER | INTEGER | INTEGER |
| JAVASCRIPT | STRING | STRING | STRING |
| JAVASCRIPTWITHSCOPE | OBJECT | OBJECT | OBJECT |
| LONGNVARCHAR | |||
| LONGVARCHAR | |||
| NCHAR | |||
| NUMERIC | |||
| NVARCHAR | |||
| OBJECT | OBJECT | OBJECT | OBJECT |
| OBJECTID | STRING | STRING | STRING |
| REAL | |||
| REGEX | OBJECT | OBJECT | OBJECT |
| SMALLINT | |||
| TIME | |||
| TIMESTAMP | STRING , formatted as DATE-TIME | STRING , formatted as DATE-TIME | STRING |
| TINYINT | |||
| UUID | STRING | STRING | STRING |
| VARCHAR | STRING | STRING | STRING |
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.