I know that it is possible to send sensors data to Aspen IP21 by using CIM-IO connected to OPC-DA servers, but I would like to send the same kind of data by using another application (that we can build in any language) which will collect data from some IoT sensors. Is there any method or API that I can use to communicate with IP21 without buying additional licenses from Aspen?
Post data to an Aspen IP21 Historian
1.6k Views Asked by Tiago Machado At
5
There are 5 best solutions below
6
On
it depends where in the MES you want to write. Usually, the best way is to use the SqlPlus ODBC driver, and write queries like INSERT and UPDATE. Note that the driver need a windows platform. Another way is to use one of the web API, like:
http://<serverhost>/ProcessData/samples/sample_home.html
4
On
If you are just looking to move data from a PLC to a database then take a look at Node-Red. Here is a video that should help you get started. Node-Red can do OPC-UA, OPC-DA or just talk direct to the PLC with out the need for OPC in the middle it's your choice. If you need more help just ask!!
https://www.youtube.com/watch?v=LaUmhhMdoyY
Node-Red can also do the GUI.
I moved a way from products like Aspen InfoPlus.21 three years ago and never looked back!!
If you need an open source visualization software for trending, charting and reporting you can use https://grafana.com/.
If you would like an open source historian or as the new buzzword is "time-series database" to log to look at https://www.timescale.com/.
Grafana and Timescale work well together!!
0
On
Your customer may develop a web service (SQL Plus in backend). The service should have interfacing parameters as Tagname, Value and value timestamp. You should send data to the webservice and the webservice will insert the data to IP21 in the specified tag.
0
On
You IoT must have any script tool to communicate/fetch the required data from it. You can use the same to push the data into IP21 which is based on SQLPlus scripting context. I am sure that this method will not require additional licences at IP21 side, assuming that you have space for additional IP21 record within your current licence, to store above data.
Yes you can do that with the help of SQLPlus script and using IP21 advanced features. Let's say data after collection form the source is saved into SQL Database (Microsoft), then there is provision given in IP21 using specific records that such record shall be executed after schedule intervals and shall get the data from source to save into IP21 tags. This requires advance scripting on SQLPlus. Also, fetching of data from SQL DB into IP21 can also be triggered with change occurred in SQL DB (i.e. collection of new data)