AC500 MS SQL communication
Is it possible to send data from an AC500 to an MS SQL database?
If it is, are there any functions or libraries available for this?
I greatly appreciate any suggestions!
Ifyou want live process data, use your favourite search engine to find "OPC to SQL". There are several third party apps that can do this. My personal preference is for Kepware products. The AC500 OPC server software is on your PS501 install disks.
You can also use a serial interface like Modbus as a data source and there is an open source application to link this to mySQL -> http://sourceforge.net/projects/modbu... ( I have no knowledge of how well this product actually works, but mySQL is an excellent database and much better than MSSQL IMHO )
Note, that any SQL database is fine for storing small amounts of historical data from a PLC, (eg reports, a few thousand data values etc.) but for larger amounts of data (eg a few months of high frequency trend data on a few hundred tags) you will quickly begin to run into real performance problems retrieving the data. You are much better to use a dedicated historian package.
This article sums it up quite well ... http://tinyurl.com/n6nsynk
An SQL Database can work, and several commercial historians are based on a relational database, but it can also run into performance problems if it isnt properly designed and maintained. It is very easy for the databse file size to get very large very quickly.
There is also a more technical discussion of some of the issues here ... http://tinyurl.com/l9xu7ur If you are trying to design something "simple" as a one-off solution you might find it is much more complicated than you expected.
What I am looking for is primarily a communication directly to a MS SQL 2008 database.
Like this library of functions for communication to a MySQL database: http://www.abb.com/abblibrary/Downloa...
Yes, I also prefer MySQL, but the customer would like to have the data to their MS SQL. It's not about some large amounts of data, nor should it be written so often.
If you can create a communication directly to a MySQL should not that be possible to a MS SQL also?