This python module provides access to the Microsoft SQL Server 2005 database underlying Siemens WinCC. Tested with WinCC 7.0 and 7.3 on Windows 7 32 bit and 64 bit.

1. Read any data from WinCC configuration and WinCC runtime database (using SQLOLEDB.1 provider)
2. Read data from WinCC TagLogging and AlarmLogging archives (using WINCCOLEDB provider)

1. python 2.7
2. python modules
   • adodbapi
   • win32com
   • click
   • jinja2
3. WinCC
   • WinCC Connectivity Pack Client or Connectivity Station(?)
   • Modify the registry (see below)

In order to enable the adodbapi module to work with the WINCCOLEDBProvider.1 proceed as follows. Open 'regedit' and search for 'WINCCOLEDBProvider'. The first result should lead to
HKEY_LOCAL_MACHINE - SOFTWARE - Classes - CLSID - Some string (e.g. {3EE5243C-3779-4545-A573-F60ABC436816}). Now, at this key, add a DWORD value with name "OLEDB_SERVICES" and value 0xffffffff. See screenshot 'regedit_oledb_services.png'.

1. WinCC 7.0 (previous or newer versions may also work)
2. VPN connection to remote machine (e.g. OpenVPN)
3. Firewall settings to allow connection from remote machine

The windows user calling the python program must also exist on the remote machine and must be part of the SIMATIC WinCC user groups (according to WinCC installation manual) for access rights on the WinCC database.