Forum Home › Forums › Understanding the Software › Writing additional data (for example infotext) to historical DB
- This topic has 9 replies, 3 voices, and was last updated 7 years, 3 months ago by Mikhail.
-
AuthorPosts
-
March 12, 2016 at 1:34 pm #900BlazeParticipant
Hello
Is it possible to write additional data to the historical DB, for example to comment a high value logged a day ago?
If it possible? Can that only be done by the Web-Interface (then User must be checked, cause not everyone must be able to alter the comment).
Or maybe is it possible to use a 3rd Party Software to connect to the DB (port 1000) and write Data to it, so it is only displayed in a Table View (for example a comment at yesterdays date 12:00).
How should the Data Fields be defined in the SCADA-Administrator (they must not be connected to a device right?)?Greatings
BlazeMarch 12, 2016 at 3:20 pm #901MikhailModeratorHello,
I think, comments should be inserted into event tables. The format of event tables allows to write 50 bytes of auxiliary event data. Is it enough? If it is not enough, another storage must be used.
Anyway custom development is required for the forms for entering data and showing inserted comments.
Could you provide more details of your question about SCADA-Administrator?
Also it is possible to use one of the popular DBMS to solve your task.March 12, 2016 at 4:15 pm #902BlazeParticipantHello Mikhail
Currently I am thinking about the possibilities of Rapid Scada.
Gathering data to put them on the network available is an interesting feature.
An example:
Currently data from PLCs is logged daily to a specific time and later supplemented with laboratory data. All this is be done by using Excel.
I wonder if it is possible that Rapid SCADA would store the PLCs data (by using OPC) in its database.
A great feature would be to add laboratory measurements with the date/time stamp the laboraytory sample has been taken.
People would be able to look back historicly at the lab data together with the PLC data.
Right now they insert the laboratory data into an excel sheet and print it out. Next day the data will be overwritten and only the printed report is left.Greetings
BlazeMarch 12, 2016 at 4:56 pm #903BlazeParticipantBy the way..
Which DBMS can be used to establish a connection to Rapid Scada?
Is there a description how to connect to Rapid Scada by using a dbms or a 3rd Party Software?March 12, 2016 at 6:01 pm #904MikhailModeratorRapid SCADA uses its own data format for storing archives by default.
May be for your task the optimal way is using standard DBMS. It depends on a way how data is processed and shown.
There is ModDBExport.dll – a SCADA-Server module. It allows online export data to Oracle, MS SQL, MySQL, PostgreSQL, etc. The examples of settings is in dbexport_en.pdf in the installation package.March 12, 2016 at 6:06 pm #905MikhailModeratorIntegration with Rapid SCADA article describes how to access to Rapid SCADA native data programmatically.
March 13, 2016 at 2:01 pm #906BlazeParticipantA ODBC Connection is not possible right?
March 13, 2016 at 5:24 pm #907December 3, 2016 at 9:59 am #1801tom040264ParticipantHello Mikhail,
I have a “basic question” (there are no stupid questions): after I have connected the module ModDBExport.dll, which program can I use the SQL data base with? I have found the description in dbexport_en, but honestly speaking I don’t understand is it a mater of Administrator or Communicator.
Thank you in advance
T.December 3, 2016 at 11:28 am #1802MikhailModeratorHi,
You should:
1. Choose what type of DBMS to use: MySQL, PostgreSQL, etc.
2. Install DBMS software.
3. Create a database using DBMS tools.
4. Create tables and indexes by the scripts from dbexport_en.pdf
5. Open ModDBExport properties and configure them.
6. Restart SCADA-Server service.
7. You can use Generator of SCADA-Server to emulate new values. -
AuthorPosts
- You must be logged in to reply to this topic.