×
Siemens Industry Online Support
Siemens AG
Entry type: Application example Entry ID: 109483465, Entry date: 09/08/2016
(71)
Rate

WinCC/IndustrialDataBridge: Writing data from SIMATIC WinCC or from SIMATIC controllers in MS Office files

  • Entry
  • Associated product(s)
How to write process data from SIMATIC WinCC V7 or from SIMATIC controllers in MS Office files using SIMATIC WinCC/IndustrialDataBridge V7.

SIMATIC WinCC/IndustrialDataBridge (IDB) is a WinCC option which enables data exchange between various automation systems, e.g. via:

  • WinCC OLEDB
  • Send/Receive
  • OPC DA

The WinCC/IndustrialDataBridge also provides data exchange with other applications for the analysis and storage of process values in Office formats, such as:

  • CSV/TXT,
  • Microsoft Excel or
  • Microsoft Access.

It is also possible to integrate databases (e.g. SQL Server, Oracle) for archiving larger amounts of data.

The figure below shows a schematic overview of the different applications and format supported by the WinCC/IndustrialDataBridge.


Figure 01


Example 1: Industrial Data Bridge with “WinCC OLE DB” provider interface

  Documentation (2,1 MB)
 Registrierung notwendig  Example project for IDB V7.3 (20,0 MB)


Example 2: Industrial Data Bridge with “Send/Receive” provider interface

  Documentation (2,4 MB)
 Registrierung notwendig  Example project for IDB V7.3 (2,7 MB)


Example 3: Industrial Data Bridge with “WinCC User Archive” provider interface

  Documentation (1,5 MB)
 Registrierung notwendig  Example project for IDB V7.3 (9,5 MB)


Example 4: Industrial Data Bridge with “OPC Data Access” provider interface

  Documentation (1,3 MB)
 Registrierung notwendig  Example project for IDB V7.3 (4,4 MB) 


Example 5: Industrial Data Bridge with "XML File" provider interface

  Documentation (1,4 MB)
 Registrierung notwendig  Example project for IDB V7.4 (7,9 MB)
 

Security Information
Siemens provides products and solutions with industrial security functions that support the secure operation of plants, systems, machines and networks. In order to secure plants, systems, machines and networks against cyber threats, it is necessary to implement (and continuously maintain) a holistic, state-of-the-art industrial security concept. With this in mind, Siemens’ products and solutions are only part of such a concept. It is the client’s responsibility to prevent unauthorized access to his plants, systems, machines and networks. Systems, machines and components should only be connected with the company’s network or the Internet, when and insofar as this is required and the appropriate protective measures (for example, use of firewalls and network segmentation) have been taken. In addition, Siemens’ recommendations regarding appropriate protective action should be followed. For more information on industrial security, visit http://www.siemens.com/industrialsecurity.
Siemens’ products and solutions undergo continuous development to make them even more secure. Siemens explicitly recommends to carry out updates as soon as the respective updates are available and always only to use the current product versions. Use of product versions that are no longer supported, and failure to apply latest updates may increase customer’s exposure to cyber threats. In order to always be informed about product updates, subscribe to the Siemens Industrial Security RSS Feed at http://www.siemens.com/industrialsecurity.

Security information
In order to protect technical infrastructures, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art IT security concept. Siemens’ products and solutions constitute one element of such a concept. For more information about cyber security, please visit
https://www.siemens.com/cybersecurity#Ouraspiration.