Edge SQL-PLC Example

Integrate SQL and PLC data at the edge.

How-to → Examples → Architecture → Edge SQL-PLC

Configuration workflow

1. Create Tags – Define the tags to store values.

2. Create Devices – Set up a PLC/value simulator (or a real connector).

3. Create Historian – Configure the connection to your SQL database.

Step 1: Create the Tags

• In Unified Namespace → DataTemplate, create a template named PVs with 10 members.

• In Unified Namespace → Tags, create a tag named PVs using the PVs template.

Result: one tag (PVs) containing 10 members.

Step 2: Create Communication

For this example, we use the Value Simulator Connector to generate test values:
Value Simulator Connector - FrameworX 10.1 - Tatsoft LLC

You can substitute any supported connector for a real device. See the Devices Module How-to Guide for connection details:
Devices Module How-to Guide - FrameworX 10.1 - Tatsoft LLC

Devices/Points table

The Devices/Points table lists all created tags. The Address column indicates where each point reads from in the configured connection. For the Value Simulator driver, it also defines how the random value is generated.

Step 3: Create a Historian connection

In Historian → Historian Tags, add the tag created earlier and configure the settings as follows:

The table used is pre created in the solution and uses SQLite, if you wish use another database provider, check the link below:

Historian Module How-to Guide - FrameworX 10.1 - Tatsoft LLC

Step 4: Test and Monitor

Go to Runtime / Startup and Run Startup

Communication Testing

1. Open Property Watch

2. Monitor tag values:

   • Check Quality (192 = Good)

   • Verify values update

Data Collection Testing

1. Go to Historian → Monitor

2. Verify Archiving:

   • Check RowCount increasing

   • Monitor LastStoredTimeStamp

   • Review ErrorCount

3. Test Retrieval:

   • Open the SQLite database in Datasets / DBs and “SQLite Admin…” button and see the data.

In this section...