Importing data from Mongo DB
Last updated
Last updated
You can import the datasets from MongoDB to the RapidCanvas platform. For this, you must establish a connection with to the Mongo DB cluster by providing the connection string. After establishing the connection successfully, you can select the required data from the collection.
To import data from Mongo DB:
Hover over the menu icon and select Connectors. The Connectors page is displayed showing the total number of connectors.
The Data connectors screen is displayed.
Click the plus icon on the top. You can also use the +New data connector button on the workspace to create a new connection.
Click the MongoDB tile.
Click Create Connection. The Data connectors configuration page is displayed.
Specify this information to configure MongoDB Data connector and fetch files from in this database:
Name: The name of the data connector.
Connectstring: The connection string has authorization details for the platform to access the data stored in the MongoDB storage account.
Click Test to check if you are able to establish the connection to the Data connector successfully.
Click Save to save the database details.
Specify this information on the Data tab:
Database: The name of the database where the data is stored.
Collection: The collection in the database you want to access.
Jsonquery: The JSON query you have to pass to fetch the information.
Click RUN QUERY to run this query and fetch the data from the database.
Once the connection is established, you can see the data imported from the MongoDB to the platform in the table format.
Click Save to save the Data connector. This Data connector gets added to the already existing Data connectors on this tenant.
You can manage files, datasets, and published outputs for this data connector across different tabs:
Data Tab: View the files retrieved from this data connector.
Datasets Tab: See the projects where datasets fetched from this data connector have been used.
Schedulers Tab: View the outputs published to this connector. When creating a job, users can configure an external connector as the destination to publish the generated outputs upon job execution.
