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 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.

Federal Information Processing Standards (FIPS) compliance

The MongoDB connection cannot be created in a FIPS environment.

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