SQL4Automation (legacy)

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...

To store data into an external database:

  1. Install the SQL4Automation tool on the computer hosting the database or in a computer between the HMI device and the database.
  2. Configure the SQL4Automation tool.
  3. Create a project that use the dedicated DB actions to access at the external database.

Installing SQL4Automation

Download the latest version of SQL4automation and install it on the computer. Refer to www.sql4automation.com for details and download.

Procedures described in this document refer to SQL4Automation Connector Version 3.3.2.0

Configuring SQL4Automation

Important: Refer to the SQL4Automation user manual for detailed configuration instruction.

Here is a quick description of how to access to a MS Office Database (MS Access).

You must have the MS Office Suite installed on a computer and create an empty database using Microsoft Access.

Start SQL4Automation and follow the procedure to configure your SQL4Automation Connector:

  1. Select ODBC Admin: the ODBC Data Source Administrator dialog is displayed.
  2. Select the System DSN tab.
  3. Click Add: the Create New Data Source dialog is displayed.
  4. Select the Microsoft Access Drive
  5. Click Finish to confirm.

  6. Enter Data Source Name and Description then click Select: the Select Database dialog is displayed.
  7. Select your Access database.
  8. Click OK to confirm.

  9. At the fist connection, click New to select your Data Source
  10. Select the IP address of your computer. This will be the connection IP Address used from your HMI device.
  11. Select the Data Source.
  12. Click OK to confirm.
  13. Click Connect.

  14. Select License> Activate Test License: when the Link 1 led turns green the procedure has been completed correctly.
  15. Click OK to confirm.

Connection Limits

SQL4Automation is delivered as a USB dongle with a license for a predefined number of connections. Connections are called "Links" inside SQL4Automation Connector. The number of connections depends on the license you have purchased.

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

Or onto a separated Computer/Server: