Last updated: Nov 27, 2024
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. See IBM Cloud Databases for MongoDB connection for this data source.
- MongoDB Atlas
- WiredTiger Storage Engine
MongoDB versions
- MongoDB 3.6 and later, 4.x, 5.x, and 6.x
- Microsoft Azure Cosmos DB for MongoDB 3.6 and later, 4.x
Create a connection to MongoDB
To create the connection asset, you need these connection details:
- Database (optional): If you do not enter a database name, you must enter the catalog name, schema name, and the table name in the properties for SQL queries.
- 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 Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Connect to a data source. 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 Import assets > Data access > Connection. See Adding data assets to a deployment space.
- In the Platform assets catalog
- Click New connection. See Adding platform connections.
Next step: Add data assets from the connection
Where you can use this connection
You can use MongoDB connections in the following workspaces and tools:
Projects
- Data quality rules (IBM Knowledge Catalog)
- Data Refinery(watsonx.ai Studio or IBM Knowledge Catalog)
- DataStage (DataStage service). See Connecting to a data source in DataStage.
- Decision Optimization (watsonx.ai Studio and watsonx.ai Runtime)
- Metadata enrichment (IBM Knowledge Catalog)
- Metadata import (IBM Knowledge Catalog)
- SPSS Modeler (watsonx.ai Studio)
Catalogs
-
Platform assets catalog
-
Other catalogs (IBM Knowledge Catalog)
- Data Virtualization service
- You can connect to this data source from Data Virtualization.
MongoDB setup
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
Related connection: IBM Cloud Databases for MongoDB connection
Parent topic: Supported connections