1. Home
  2. SureMDM
  3. General questions
  4. Role of MongoDB and SQL with SureMDM OnPremise.
  1. Home
  2. SureMDM
  3. Role of MongoDB and SQL with SureMDM OnPremise.

Role of MongoDB and SQL with SureMDM OnPremise.

KB ID: 42G2011444
Views: 581
Updated: June 2021

Mongo DB and SQL are two different, but equally important kind of databases used in IT firms to deal with data. SQL is a database that deals with structured data and uses tables to store data in a structured schema. Whereas MongoDB deals with unstructured data and stores the data in JSON format. 

These databases play a major role in handling the entities in SureMDM to provide better performance to the end-users. 

SureMDM OnPremise versions before v6.37 used SQL only. However v6.37 onwards it was made mandatory for users to use MongoDB with SureMDM OnPremise.

SQL plays a major role in storing the latest information about all the entities in SureMDM. However, since it is not easy to scale the SQL server for a large dataset, SureMDM uses MongoDB to store historical data.

Features such as Device logs, Location history, Reports, Data usage, Call logs and SMS logs, Tags, Job Queues, etc., are stored in MongoDB. Other major features remain with SQL, as it fits the requirement.

To register for a free trial, click here.

If you need further assistance, please submit a ticket here 

Related Articles