OPC UA to SQL Converter with FT Optix

Home / FactoryTalk Optix / Advanced Topics and Use Cases

Description
Converting from OPC UA to SQL with FactoryTalk Optix.

Build your own compact tool to read a Tag from any device thru OPC UA and store the values in a MS SQL Database, easy, saving costs and done on a snap.

On the other hand Logix controllers V36 have already OPC UA server protocol implementation.

Contributed by Xavier Florensa – YouTube – LinkedIn – GitHub

Transcript
(00:01) hi everybody in this video I will show you how to create attack from a PLC and store in a SQL database thank you to factory talk Optics as a gateway to do this task uh I will simulate the PLC with Factory talk cap server Enterprise Okay so let’s go to our demo here we have our SQL database here we have our Factory talk C server Enterprise tax simulator where here we have the variable incrementing okay and here we have the paral optic to show the database with a datag GD this is
(01:08) already running you can delete the database for instance with this SQL query like this and the database is deleted each time you delete the database you can also make it query to show the values and let’s see how this is done let’s take a look at our Optics application we just have a main window with a datag GD pointing to the SQL database we have have a variable to show the cap server OPC value we also have an OPC driver uh putting
(02:17) the tax value available on this IP address through opcua you also have uh database okay Microsoft SQL Server database running in Local Host with this database and also you have a Data Logger that will periodically uh take a data from the um PCA and the store in the database um you have also this explained in this GitHub repository where you can download the code and you can follow the instructions to make all the process and that’s all thank you very much

Tutorial List

Back to tutorials