Hello Support Team,
We are using 3.13 version and configured DB Logger to get the data to MySQL(Using StandardHistory Table type). But we also need to get the data of Alarms/Events. How can we achieve this through DB Logger. If there is no option in DB Logger to get the alarm data then how can we get this to MySQL. Please help ASAP.
Thanks & Regards,
RaghuPavan Veeranki
DB Logger
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: DB Logger
Hello,
with the DBLogger alarms cannot be saved in an external database.
If you want to write/read information into/from an external database you can write a CTRL-script which uses the Control-ADO functions.
For detailed information please have a look at the online help: Special functions --> Control-ADO (Access to external databases).
Best Regards
Leopold Knipp
Senior Support Specialist
with the DBLogger alarms cannot be saved in an external database.
If you want to write/read information into/from an external database you can write a CTRL-script which uses the Control-ADO functions.
For detailed information please have a look at the online help: Special functions --> Control-ADO (Access to external databases).
Best Regards
Leopold Knipp
Senior Support Specialist
- raghupavan
- Posts:10
- Joined: Tue May 20, 2014 1:08 pm
Re: DB Logger
Hi Leo,
Thanks for the reply. I have one more question.
1) We started to push the data to MySQL on the remote machine using ODBC DSN through DBLogger.
2) In the middle, we removed the connection.
3) After reconnecting, the data logging resumed.
But the data, while the connection was down was lost/not logged into MySQL.
Does the DBLogger bufferes the data and puhes the backup data after regaining the connection. If not then how can we get the lost data.
Thanks for the reply. I have one more question.
1) We started to push the data to MySQL on the remote machine using ODBC DSN through DBLogger.
2) In the middle, we removed the connection.
3) After reconnecting, the data logging resumed.
But the data, while the connection was down was lost/not logged into MySQL.
Does the DBLogger bufferes the data and puhes the backup data after regaining the connection. If not then how can we get the lost data.
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: DB Logger
Hello,
the DBLogger does not have a functionality to buffer data when the connection is lost.
If you want to have this data available you have to write your own script which checks if the connection is available. When the connection is reestablished missing data is written to the database.
Have you thought about using the RDB-manager (writing data to an Oracle database) instead of MySQL?
For the RDB-manager you can configure that data shall be buffered when the connection is lost.
Best Regards
Leopold Knipp
Senior Support Specialist
the DBLogger does not have a functionality to buffer data when the connection is lost.
If you want to have this data available you have to write your own script which checks if the connection is available. When the connection is reestablished missing data is written to the database.
Have you thought about using the RDB-manager (writing data to an Oracle database) instead of MySQL?
For the RDB-manager you can configure that data shall be buffered when the connection is lost.
Best Regards
Leopold Knipp
Senior Support Specialist
- fandersen
- Posts:51
- Joined: Tue Aug 26, 2014 12:39 pm
Re: DB Logger
Switching to Oracle just to have alarms in an external database is not cost efficient at all. First of all you need proper training to handle an oracle db. Second there is a free express version but it is limited to database size and RAM. A commercial version is very expensive.
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: DB Logger
Hello,
the RDB manager can write event and alert information to the Oracle database. The DB logger can only write event information to an external database and does not have the complete functionality compared to the RDB manager.
Also the RDB manager has a buffer functionality which stores data in memory and/or the local harddisc if the connection is broken.
Best Regards
Leopold Knipp
Senior Support Specialist
the RDB manager can write event and alert information to the Oracle database. The DB logger can only write event information to an external database and does not have the complete functionality compared to the RDB manager.
Also the RDB manager has a buffer functionality which stores data in memory and/or the local harddisc if the connection is broken.
Best Regards
Leopold Knipp
Senior Support Specialist