Page 1 of 1

Log to external database

Posted: Tue Aug 20, 2013 6:29 am
by GoranW
I need to use Wonderware Historian to
log process data. Can this be done and
if so, how?

Re: Log to external database

Posted: Wed Aug 21, 2013 2:12 am
by Edmund
I´m no Historian expert but maybe I can point you into direction.

First, what is you iX target? Panel (TxA/TxB or PC/TxC)?

Second, Wonderare Historia contains several databases, one Microsoft SQL Server and one more secred High Performance database engine.

You could talk directly with the SQL Server (and bypass Historian) but I wound not recommend it.

Historian can talk directly to I/O-Server, Wounderware Application Servers, and other HMI software vendors. Have a look if you Historian can read data from an OPC UA Server, if then you can enable the OPC UA Server in you iX application and read data from it.

Historian also have something they call Manual Data Aquisition Service (MDAS), It´s a DLL that helps you communicate with historian from you application but you will probably need to have a PC project then.

Historian also lets you import CSV files with data, maybe you can automate this.


Do you already have Wonderware Historian or planing to buy it?

Re: Log to external database

Posted: Wed Aug 21, 2013 5:22 am
by GoranW
Hi Edmund,

I am no Historian expert either, in fact I have never even seen it.

Target is T15C and it is decided (not by me) to use Historian, and
we already have it.
The Historian application will run on a different computer.

I have done some research since my first post and I am fairly
sure that Historian can read from an OPC UA server so I think
that is the way to do it.

I have recieved some information from Beijer support on how to configure
Ix so I think I will manage.
If not, I'll be back. I will update this thread anyway in case there are others
who are in the same situation.

Thanks for now
Goran

Re: Log to external database

Posted: Mon Aug 26, 2013 8:30 am
by mark.monroe
Here is an example on how to connect a iX TxC or PC Project to a external SQL database. It has examples for Access, Microsoft SQL Server, and MySQL. It only works on a PC based HMI because of the external libraries that are used to make the connection between the HMI and the external database. It is not exactly what you are looking for, but it be of help to others.
Databases_Demo.zip
(1.24 MiB) Downloaded 1178 times