A popular document-oriented NoSQL database called MongoDB is utilized for storing data using a flexible JSON-like document model. Before being connected to MongoDB, it is required to verify that the appropriate network access to reach the database is ensured by configuring the firewall or network settings based on the specific setup.
The relevant connection details such as the database name, host address, and port number should be provided to establish a connection with MongoDB. In addition, the authentication credentials or SSL settings required for secure connections can also be specified. After establishing the connection, the powerful query and aggregation features of MongoDB can be used to work with data.
The following table outlines the parameters that need to be filled by the user to establish a connection with MongoDB. It provides a clear breakdown of the specific parameters required and their corresponding data types, which must be accurately entered to establish a successful connection with MongoDB.
MongoDB |
||
Host |
Server host |
String |
Port |
Server post |
Int |
UserName (Optional) |
Username to connect to server |
String |
Password (Optional) |
Password to connect to server |
String |
DatabaseName |
Database Name |
String |
AuthMechanism |
Authentication Mechanism to use for connection |
String |
Inputs |
Connection Inputs |
List |
Outputs |
Connection Outputs |
List |
Once the connection with the MongoDB source has been established successfully, the "input" page is utilized to define the data or dataset. This step involves specifying the necessary details related to the data or dataset, such as its location, type, and structure. Ensuring that all the relevant information is accurately entered on the "input" page to properly define the data or dataset is crucial for the successful transfer of data to a MongoDB collection.
A detailed explanation of the features can be found in section 2.1 of this user manual. This feature enables documents and fields within your database to be easily navigated and selected, and then used in your queries by dragging and dropping them into the input query section.
To view the results of the written query, refer to section 2.2, which covers the 'Execute Query' feature. This feature allows the user to execute the query and view the output in the result window.
Input |
||
Query |
Query to run |
String |
CollectionName |
Name of collection |
String |
Sort |
Whether to sort result |
Bool |
SortQuery (Optional) |
Sort Query to run |
String |
Limit |
Whether to limit the number of returned results |
Bool |
LimitNumber (Optional) |
Number of query results to return |
Int |
To transfer the data package created by the user to a MongoDB collection, it is necessary to define an output. It is important to ensure that all the required information is accurately entered when creating or modifying a collection in MongoDB to ensure proper data transfer and manipulation.
Output |
||
CollectionName |
Name of collection |
String |