Integrating MongoDB with Mulesoft

Posted on Categories MuleSoft
  1. Overview
  2. Installation Steps
  3. Demo API
  4. Add the connector into Studio
  5. Create a connection
  6. Conclusion
MongoDB can be integrated with MuleSoft using the MongoDB Connector, which is available in the MuleSoft Anypoint Exchange. This connector allows you to perform various operations on MongoDB, such as inserting, updating, and querying documents, as well as managing indexes and collections. The connector can be used in a Mule flow to interact with a MongoDB database, making it possible to easily retrieve or store data in a MongoDB database from within a Mule application. What is MongoDB: MongoDB is an open-source NoSQL database management program. NoSQL is used as an alternative to traditional relational databases. NoSQL databases are quite useful for working with large sets of distributed data. MongoDB is a tool that can manage document-oriented information, store or retrieve information. MongoDB stores data objects in collections and documents instead of the tables and rows used in traditional relational databases. Collections comprise sets of documents, which are equivalent to tables in a relational database. Documents consist of key-value pairs, which are the basic unit of data in MongoDB. MongoDB VS SQL
                                          MongoDB                   SQL
  Priority    Data Structure       Data Representation   JOIN Support     Query Language   Schema   Developer Productivity   Atomic Transactions (e.g., having several operations within a transaction) Cloud-friendly   Unstructured, or structured data that will potentially grow fast   JSON documents   No   JavaScript   No need to define   Fast   Doesn’t fully support all operations but supports multi-document transactions High data security   Structured     Tables and rows   Yes   Structured Query Language (SQL)   Must define columns and tables   Slow   Supports atomic transactions
 

A Step-by-Step Guide to Install MongoDB on Windows:

Step 1:   Go to the Official https://www.mongodb.com/try/download/community Step 2:  Navigate to Products > Community Edition Step 3:  Select the appropriate installer file from the dropdown menus on the Community Edition page. In the version dropdown, select the latest version, 6.0.1(current) In the Platform dropdown, select Windows In the Package dropdown, select msi Step 4: Click the “Download” button. After the installer file has been downloaded, it’s time to run the installer file. Step: 5: Go to the downloaded directory in your system. Step 6: Double-click on the .msi file. It will open the MongoDB setup windows. Step 7: It will open the MongoDB Community Edition installation wizard. This setup wizard guides Step 8:  Accept the terms and conditions, and then click the “Next” button to continue. Step 9: Next, you can choose either the Complete setup or Custom setup type to proceed. But for a beginner, we’d recommend using the Complete setup option. It installs MongoDB in the default location. Select the Complete setup, and click “Next.” Step 10: Select the “Install MongoD as a Service” option on the next page. Keep all other parameters as default. Click on the “Next” button. Step 11: In the “Ready to install MongoDB” page, click the “Install” button, give administrator access, and wait for the installation to finish. Once installation is complete, you can click on the “Finish” button to finalize your installation. Step 12: After installation need to set up Environment Variable Go to the MongoDB installation directory in the “C Drive.” Navigate to Server > 6.0 > bin folder. Copy the path. C:\Program Files\MongoDB\Server\6.0\bin Step 13: After adding the environment variable in the system , we can check mongodb installed or not in cmd  , you can run the mongod –-version command on the Command window to check if MongoDB is installed correctly. Open mongodb application it will show like this We can connect or create database here. Open Anypoint studio add Mongodb modules from exchange. Give host ,  port and database to connect mongodb configuration.
  • Here I created one application using Mongo database connectors.
  • MongoDB connectors required in this POC
Create collection

Creates a new collection. If the collection already exists, a MongoException will be thrown.

Collection means it create new table in mongodb

         Insert document:

Inserts a document in a collection

         Drop Collection Deletes a collection and all the objects it contains. If the collection does not exist, does nothing. List Collection Lists names of collections available at this database
  • Here post method is used to insert data into the mongo database and gave input data through postman
  • Store that payload into variables i.e., inpuData and collectionName to create collection and insert data into it.
  • After creating collection in mongo database insert document into mongo db
  • Next drop collection is used to remove particular collection
  • List collection is used for fetching the list of collection in mongo database
  • Here we are getting list of collections
  • Successfully inserted data into mongo database