...
| Excerpt | |
|---|---|
You can create connections to MongoDB and MongoDB Atlas connections through
|
Supported Versions: n/a
- Database versions: 2.6 - 5.0
Supported Environments:
| Operation |
| Amazon | Microsoft Azure | |
|---|---|---|---|---|
| Read | Supported | Supported | Supported | |
| Write | Not supported | Not supported | Not supported |
Prerequisites
- MongoDB supports basic (username/password) authentication.
...
To create a MongoDB Atlas connection, please specify the following properties:
| Property | Description | ||
|---|---|---|---|
| Host | Name of the host. | ||
| Port | Set this value to the port number through which to access MongoDB. By default, this value is 27017. | ||
| Database | The database that you want to read | ||
| Replica Set | (Optional) Comma-separated list of secondary servers in the replica set, specified by address and port. A replica set is a group of mongoDB processes that maintain the same data set. Replica sets provide redundancy and high availability and are the basis for all production deployments. For more information, see https://docs.mongodb.com/manual/replication/. | ||
| Secondary Reads | Enable this checkbox if you want to read from secondary (slave) servers. | ||
| Connect String Options | (Optional) The option sets the connection timeout in milliseconds:
The default value is | ||
| Test Connection | After you have defined the connection credentials type, credentials, and connection string, you can verify that the
| ||
| Default Column Data Type Inference | Set to | ||
| Connection Name | Display name of the connection | ||
| Connection Description | (Optional) Description of the connection, which appears in the application. |
For more information on these settings, see http://cdn.cdata.com/help/DGG/jdbc/default.htm.
...
When data is imported from MongoDB, the supported data types from the source are converted to corresponding data types supported by the
| D s webapp | ||
|---|---|---|
|
| Source Data Type | Supported |
| ||||
|---|---|---|---|---|---|---|
| ObjectId | Y | String | ||||
| RegEx | Y | String | ||||
| String | Y | String | ||||
| Binary | Y | String | ||||
| Integer | Y | Integer | ||||
| Timestamp | Y | Datetime | ||||
| Double | Y | Float | ||||
| Array | Y | String | ||||
| Bool | Y | bool | ||||
| Null | Y | String | ||||
| Date | Y | Datetime |
Write/Publish
Not supported.
...
