Database

The Database connection reads values from a relational SQL database. User-defined SQL queries run on a configurable interval and their results map directly to tags in the Tag Database.

Supported databases

• MySQL
• MariaDB
• PostgreSQL
• Microsoft SQL Server
• SQLite
• MongoDB
• Oracle

Setup workflow

Step 1 — Configure the database connection

Enter the connection details: IP address, port, database name, username, and password.

Step 2 — Define a query

Write a SQL query to retrieve the data you want — for example:

SELECT * FROM production_data;

DataTalk runs this query on the configured polling interval and fetches the available tags from the result set.

Step 3 — Select tags

From the query results, select the specific columns (tags) you want to monitor. Assign a unique identifier to distinguish entries.

Step 4 — Import tags

The selected tags are imported into the Tag Database. Use the Read button in the Tag Database to verify the connection and confirm that values are retrieved correctly.

Connection parameters

Parameter	Description
Host	Database server hostname or IP address
Port	e.g. 3306 (MySQL/MariaDB), 5432 (PostgreSQL), 1433 (SQL Server)
Database	Schema / database name
Username / Password	Database credentials
Poll interval	How often queries are re-run (ms)