CtrlX SQL Database Integration

[Taktt]

I've got a customer who wants to tie their CtrlX system into a SQL database to read/write data.  I've seen that there are some SQL libraries for sale on the codesys store.  Does anyone know whether these are compatible with ctrlX?  They say Codesys v3.5 is the requirement, so I'm assuming this should be compatible.

If anyone has another way they've solved this, I'm open to that as well.

https://store.codesys.com/en/mysql-library-sl.html 

[CodeShepherd · Accepted solution]

There are several possibilities depending which SQL database you like to use:

1. MySQL:
   • ctrlX CORE - Node-RED app with palette node-red-node-mysql
   • ctrlX CORE - Telegraf App
   • Bosch - DeviceBridge
2. Microsoft SQL
   • ctrlX CORE - Node-RED app with palette node-red-contrib-mssql-plus (SQL2000 ~ SQL2019)
   • ctrlX CORE - Telegraf App
   • Bosch - DeviceBridge (Feature planned for next year)

[bclapperton]

@CodeShepherd Please clarify,

I can see that Node Red can enable CtrlX to both read from and write to an SQL databases. 

However, can Telegraf and Device Bridge read and write? Most of the information/flow diagrams I can see shows data going from a PLC to a database. Not the other way round.