Exporting data from WinCC OA to SQLite

[cpollak]

Hello,

is there a possibility to extract/export data from WinCC OA database to external open-source database such as SQLite?

Thanks in advance for tipps!

[Gertjan van Schijndel]

You could use OPC, OleDB provider, COM manager or with 3.13 the reporting interface to read values from the WinCC OA database.

[leoknipp]

Hello,

with the CTRL-functions to access external database you can read/write data in external databases.
Maybe this also works for SQLite-databases.

For detailed information please have a look at the WinCC OA online help:
CONTROL --> Types of funtions --> Database functions.

Best Regards
Leopold Knipp
Senior Support Specialist

[mkoller]

yes, there is.
On Linux we provide the native Qt plugins for SQLite, MySQL , PostgreSQL, unixODBC (and OCI for the proprietary db) we use with the CtrlADO extension.
Check the *sqldrivers* rpm packages we provide and check the CtrlADO functions like dbOpenConnection() etc.