I
I'm looking for PLC modules (can work with whatever brand PCS) that can log data directly to SQL databases. Desired features:
1. Local caching with the ability to "batch" queries. Should log like this by default to: conserve bandwidth and support a flakey connection.
2. Would be best if it supported a multitude of PLCs and SQL database types.
My justification is this. I promote http://www.FactorySQL.com to act as a historian from any OPC compatible PLC to any SQL database. It does much more than that. In many cases, integrators only need to log data from a slow remote connection to an SQL database. In this case I want to recommend a cheap hardware device that can locally batch up the historical data and send it to the database in batches or "transactions" (doesn't need to be a database supported autonomous transaction).
1. Local caching with the ability to "batch" queries. Should log like this by default to: conserve bandwidth and support a flakey connection.
2. Would be best if it supported a multitude of PLCs and SQL database types.
My justification is this. I promote http://www.FactorySQL.com to act as a historian from any OPC compatible PLC to any SQL database. It does much more than that. In many cases, integrators only need to log data from a slow remote connection to an SQL database. In this case I want to recommend a cheap hardware device that can locally batch up the historical data and send it to the database in batches or "transactions" (doesn't need to be a database supported autonomous transaction).
