Create Dataset Using noSQL

What is NoSQL?

• A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. It is non-tabular databases and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. The main types are document, key-value, wide-column, and graph.

What is MongoDB?

• MongoDB is an open-source document database built on a horizontal scale-out architecture that uses a flexible schema for storing data.

1. Refer this Link to know more about how to create dataset. (Refer till step No-3 for this example)

2. Fill the Details as per below:

• Datasource: No SQL
• Source: admin_aiv

3. In the Query box write code as given below:

    db.customers.find({country: “USA”})

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

   

5. Go to the General mode & give a name to the dataset “Customers_USA” & click on Submit button.

6. Created Successfully message will pop up at the top of the screen.

7. Go to the hamburger menu > Master Data > Dataset

8. When the user clicks multiple times on the Last Updated column, created dataset ‘Customers_USA’ will appear at the top as shown below:

   

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