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.
info
To know how to create datasource using MongoDB for NoSQL Click here
Refer this Link to know more about how to create dataset. (Refer till step No-3 for this example)
Fill the Details as per below:
- Datasource: No SQL
- Source: admin_OPNBI
Note
To know more about terminology of General tab Click here
- In the Query box write code as given below:
db.customers.find({country: “USA”})
Go to Preview mode & see the country column. It will show the data of the USA as user written in Query.
Note
To know more about terminology of Preview tab Click here
Go to the General mode & give a name to the dataset “Customers_USA” & click on Submit button.
Created Successfully message will pop up at the top of the screen.
Go to the hamburger menu > Master Data > Dataset
When the user clicks multiple times on the Last Updated column, created dataset ‘Customers_USA’ will appear at the top as shown below:
User needs to double click on that dataset if they want to edit that created dataset ‘Customers_USA”.
Note
Click here to know more about how to edit dataset.