# Save device data to MongoDB Atlas using the Data Integrations
MongoDB Atlas (opens new window) is a multi-cloud database service by the same people that build MongoDB. Atlas simplifies deploying and managing your databases while offering the versatility you need to build resilient and performant global applications on the cloud providers of your choice.
In this article, we will simulate the temperature and humidity data, and publish these data to EMQX Cloud via the MQTT protocol, and then we will use the EMQX Cloud Data Integrations to store the data to MongoDB Atlas.
Before you start, you will need to complete the following:
- Deployments have already been created on EMQX Cloud (EMQX Cluster).
- For Professional Plan users: Please complete Peering Connection Creation first, all IPs mentioned below refer to the internal network IP of the resource.(Professional Plan with a NAT gateway can also use public IP to connect to resources)
# MongoDB Atlas Configuration
If you are new to MongoDB Atlas, we recommend that you follow the MongoDB Atlas help documentation (opens new window) to create it.
Create a version of MongoDB Atlas that supports VPC peering (opens new window).
Create username and password for database authentication.
Select VPC Peering for network type.
Populate the EMQX Cloud VPC information into the peer connection page of MongoDB Atlas, and you can get the peering ID for further use.
Once you have obtained the Peering ID and VPC ID, add your MongoDB Atlas VPC information to the EMQX Cloud console.
Until the status is available, indicating that the VPC peer connection has been successfully created.
Get the connection address of MongoDB Atlas instance.
# Data Integrations Configuration
Go to Deployment Details and click on
Data Integrations on the left menu bar.
Create MongoDB Atlas Resource
MongoDB Replica Set Modeunder the Data Persistence.
Fill in the information you have just created and click
Test. If there is an error, you should check if the database configuration is correct. Then click on
Newto create MongoDB Atlas resource
Choose the MongoDB Atlas resource under Configured Resources, click on
New Ruleand enter the following rule to match the SQL statement. In the following rule we read the time
up_timestampwhen the message is reported, the client ID, the message body (Payload) from the
temp_hum/emqxtopic and the temperature and humidity from the message body respectively.
SELECT timestamp div 1000 AS up_timestamp, clientid AS client_id, payload.temp AS temp, payload.hum AS hum FROM "temp_hum/emqx"1
Click on the
Nextbutton at the bottom to enter action view. Select the resource created in the first step, select
Data Persistence - Data to MongoDB Atlasfor
Action Typeand enter the collection of your Mongodb Atlas.
Confirmto create action.
Use MQTT X (opens new window) to simulate publishing temperature and humidity data
View rule monitor
Check the rule monitoring and add one to the "Success" number.
View stored results