MongoDB connection

To access your data in MongoDB, create a connection asset for it.

MongoDB is a distributed database that stores data in JSON-like documents.

Supported editions and versions

MongoDB editions

• MongoDB Community
• IBM Cloud Databases for MongoDB
• MongoDB Atlas

MongoDB versions

• MongoDB 4.0, 4.2
• MongoDB 3.0, 3.2, 3.4, 3.6
• MongoDB 2.2, 2.4, 2.6

Create a connection to MongoDB

To create the connection asset, you need these connection details:

• Database name
• Hostname or IP address
• Port number
• Authentication database: The name of the database in which the user was created.
• Username and password
• SSL certificate (if required by the database server)

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Choose the method for creating a connection based on where you are in the platform

In a project Click Add to project > Connection. See Adding a connection to a project.

In a catalog Click Add to catalog > Connection. See Adding a connection asset to a catalog.

In a deployment space Click Add to space > Connection. See Adding connections to a deployment space.

In the Platform assets catalog Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

• See Add data from a connection in a project.
• See Add data from a connection in a catalog.

Where you can use this connection

You can use MongoDB connections in the following workspaces and tools:

Analytics projects

• Data Refinery (Watson Studio or Watson Knowledge Catalog)
• DataStage (DataStage service)
• Metadata import (Watson Knowledge Catalog)
• Notebooks. You can use the insert-to-code function to get the connection credentials and load the data into a data structure. See Load data from data source connections.
• SPSS Modeler (SPSS Modeler service)

Catalogs

• Platform assets catalog
• Other catalogs (Watson Knowledge Catalog)

Data Virtualization service You can connect to this data source from Data Virtualization.

MongoDB setup

MongoDB installation

Restrictions

• You can only use this connection for source data. You cannot write to data or export data with this connection.
• For DataStage, table names need to be added in uppercase characters.
• MongoDB Query Language (MQL) is not supported.

Learn more

• MongoDB tutorials
• mongodb.com

Parent topic: Supported connections