Datasource Using MongoDB

This document is all about how to create Datasource using MongoDB & make a dataset out of it in AIV.

Use Case: Datasource using Mongo DB & make dataset using that datasource

1. Log in to the AIV application using your credentials.
2. Click on the hamburger menu  Master Data  Datasource, screen will look as per the image below:

3. Click on Create Datasource button from the footer menu as shown in the above image.
4. Database Connection window will open & it will look as per below:

5. Enter the details as per below:

• Select NoSQL  MongoDB
• Display Name: admin_aiv
• In Connection Url write as below:
• <servername>: 127.0.0.1
• <port>:27017
• <databaseName>: admin

6. Clicks on the Test Connection button & one pop-up will appear in which Connection Successfully is written.
7. When the user clicks on the Save button another pop-up will appear asking you for permission to create a dataset as shown below:

8. Click on Accept button & Create Dataset window will appear as shown in the image below:

9. In the Query box write code as given below: db.customers.find({country: “USA”})

10. Go to Preview mode & see the country column. It will show the data of the USA as user written in Query.

11. Go to the General mode & give a name to the dataset “Customers_USA” & click on Submit button.
12. Created Successfully message will pop up at the top of the screen.
13. Go to the hamburger menu  Master Data  Dataset
14. When the user clicks multiple times on the Last Updated column, created dataset ‘Customers_USA’ will appear at the top as shown below:

15. User needs to double click on that dataset if they want to edit that created dataset ‘Customers_USA”.