F.A.Q.

How many HMI and Databases can I connect to SQL4Automation Connector ?

Written by Mark Olding | Sep 21, 2023 8:19:56 AM

What to know

JMobile Studio allow to connect to the SQL4Automation Connector, a software solution for the industrial usage.
It connects HMI, PLC and robotic controls directly with SQL databases. HMI directly access SQL databases via the connector and can query data from tables, insert, change and delete data in tables by using SQL commands [structured query language].

The database site communicates by ODBC. Therefore all SQL databases can be integrated, which support an ODBC interface. The SQL syntax needs to be adapted to the given database, e.g. MS SQL Server, mySQL, MS Office Access, SQLite, Oracle, PostgreSQL...

Connection Limits

SQL4Automation comes as a USB Dongle allowing 1 connection, as known as Links inside SQL4Automation Connector.
With this license you are able to connect one Exor HMI to one Database.

SQL4Automation Connector can be installed on the same Computer/Server running the databse:

Or onto a separated Computer/Server: