Allows you to publish (insert / update ) your data to supported databases

• mySQL
• Microsoft SQL
• Oracle
• Postgress
• MongoDB
• MariaDB

First, create a gateway and select the type of SQL connection, – database type where the data will be published. Then, fill in all the required fields to connect to the database.
Make sure to test the connection once you have finished inserting the database details.

After that, you head to the Tag Database and select tags you want to be published inside database

Once you’re done with selecting the datapoints, head back to the gateway settings and head to the publish section – click on “create table” which will automatically create a table inside your database with pre-defined columns.

Then, depending on your preference, you can use either “Create SQL Update” or “Create SQL Insert,” which will automatically generate a query to push data into the Database according to the “Run Every” setup.