0 / 0
MongoDB connection
Last updated: Nov 27, 2024
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 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

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

Related connection: IBM Cloud Databases for MongoDB connection

Parent topic: Supported connections