Hi Witch toll or software do we recommend to connect directly to the SQL lite DB located on the AXC F 2152? Customer want to use the data logger option but do not want to drag and drop the DB file, he want to create a direct link and send SQL request to it. Thanks
https://www.sqlite.org/draft/useovernet.html [quote]Summary If your data lives on a different machine from your application, then you should consider a client/server database. SQLite is designed for situations where the data and application coexist on the same machine. SQLite can still be made to work in many remote database situations, but a client/server solution will usually work better in that scenario.[/quote]
However, historical data from the DataLogger can be accessed from a remote machine through the OPC UA server, using the historical data access feature: https://www.plcnext.help/te/Service_Components/OPC_UA_Server/OPC_UA_historical_access.htm This is demonstrated in this series of videos: https://www.plcnext-community.net/index.php?option=com_content&view;=article&id;=407 So, any software that can access OPC UA historical data should be able to get data from the sqlite database on the PLC. I suppose that most industrial SCADA software (e.g. Wonderware) probably supports this feature.