For a long time now, my team have been using namedQuery to write and retrieve transactional record.
What am I missing if I am not using SQL Bridge?
Why and when would I use SQL Bridge?
1 Like
Where SQL Bridge really shines is giving the not so DB savvy the ability to read/write multiple related data points in/from a database without the need to understand SQL.
If you are familiar with FactoryTalk Transaction Manager (previously RSSQL) this is basically a 1 for 1 drop in for that (Only better). However, a nice shiny UI which makes it straight forward to tie PLC Values to DB columns, or DB columns to PLC values, is great for those who don't have/need/want to deep dive into scripting and SQL.
The UI also makes it easy to do middle man transformations of the data (like trimming strings from the PLC, or SCALING values) before forwarding it on to the DB or PLC.
Is it needed? No with the correct knowledge and a little work you can easily use other tools offered by the platform to produce the exact same functionality. The module just does all the nitty gritty for you.
3 Likes