Transaction Manager Still the Way to Go in 2023?

[Chris Elston 79]

If I have a 1000 records with recipes that live in an SQL database, is transaction manager still the way to go to get my recipes from the SQL database into my Rockwell PLC? Or in the last 5 years, has Rockwell came out with something else easier? Even if that means moving my 1000 records from SQL to something else. The 1000 records are static information, I just need about 30 PLCs to always look at the static data as a "lookup" and the static records can be changed from a master source later on down the road.

Just asking to make sure. 

[pturmel 160]

SQL is still the way to go, IMNSHO.  (I'd use Ignition before any of Rockwell's software, though.)

[Chris Elston 79]

They already have Transaction Manager running, so it will be an existing install so getting Ignition purchased and installed here will be tough.