Hello,
How can I get datas from WinCC OA DB to my custom application. with ODBC or other solutions?
Thank You
Best Regards,
Hakan
Get data from WinCC OA Database
- aorange
- Posts:147
- Joined: Thu Nov 04, 2010 10:07 am
Re: Get data from WinCC OA Database
Hi Hakan, if you're using the Oracle RDB then this is fairly straight forward.. just setup an ODBC connection using the Oracle DB driver or alternatively set up a linked database from MS SQL. Both of these options will allow you to access the historical data directly from external applications.. if you are using the Value Archive however then external access becomes a bit more complicated.
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: Get data from WinCC OA Database
Hello,
for reading data from the WinCC OA database with external tools you could use the OLE DB provider.
For details please have a look at the online help: System management --> Database --> OLE DB provider.
Do you want to read data on demand?
Or do you want to export a specific amount of data, e.g. values for one day for a defined amount of dp-elements?
Best Regards
Leopold Knipp
Senior Support Specialist
for reading data from the WinCC OA database with external tools you could use the OLE DB provider.
For details please have a look at the online help: System management --> Database --> OLE DB provider.
Do you want to read data on demand?
Or do you want to export a specific amount of data, e.g. values for one day for a defined amount of dp-elements?
Best Regards
Leopold Knipp
Senior Support Specialist