Dynamic Data Exchange
In computing, Dynamic Data Exchange (DDE) is a method of interprocess communication under Microsoft Windows or OS/2. It allows one program to subscribe to items made available by another program, for example a cell in a Microsoft Excel spreadsheet, and be notified whenever that item changes. DDE was partially superseded by Object Linking and Embedding (OLE), but remains used for simple interprocess communication tasks.
Dynamic Data Exchange was first introduced in 1987 with the release of Windows 2.0 as a method of interprocess communication so that one program could communicate with or control another program, somewhat like Sun's RPC (Remote Procedure Call). It used the "Windows Messaging Layer" functionality within Windows. DDE continues to work even in modern versions of Windows, but has been superseded by newer technologies. Windows for Workgroups introduced a remoting version called NetDDE.
OLE and OLE Automation are more advanced than DDE, but have proven to be bulky and difficult to code. OLE is far more sophisticated and capable than DDE because it is built on top of Microsoft's Component Object Model, but also suffers from COM's problems of a higher performance penalty and a much steeper learning curve. COM that works between networked machines is known as DCOM (Distributed COM). .NET Remoting provides a layered architecture for interprocess communication in the .NET Framework. However, legacy DDE is still used in several places inside Windows, e.g. for Shell file associations and for the copy, cut and paste functions.
The primary function of DDE is to allow Windows applications to share data. For example, a cell in Microsoft Excel could be linked to a value in another application and when the value changed, it would be automatically updated in the Excel spreadsheet. The data communication was established by a simple, three-segment model. Each program was known to DDE by its "application" name. Each application could further organize information by groups known as "topic" and each topic could serve up individual pieces of data as an "item". For example, if a user wanted to pull a value from Microsoft Excel which was contained in a spreadsheet called "Book1.xls" in the cell in the first row and first column, the application would be "Excel", the topic "Book1.xls" and the item "r1c1".
A common use of DDE is for custom-developed applications to control off-the-shelf software. For example, a custom in-house application might use DDE to open a Microsoft Excel spreadsheet and fill it with data, by opening a DDE conversation with Excel and sending it DDE commands. Today, however, one could also use the Excel object model with OLE Automation (part of COM). The technique is, however, still in use, particularly for distribution of financial data. DDE has also been widely used in the SAS programming language for manipulating Excel and transferring data between SAS and Excel and can be used to format Excel workbooks from within a SAS program.
California-based company Wonderware developed an extension for DDE called NetDDE that could be used to initiate and maintain the network connections needed for DDE conversations between DDE-aware applications running on different computers in a network and transparently exchange data. A DDE conversation is an interaction between client and server applications. NetDDE could be used along with DDE and the DDE management library (DDEML) in applications.
/Windows/SYSTEM32 DDESHARE.EXE (DDE Share Manager) NDDEAPIR.EXE (NDDEAPI Server Side) NDDENB32.DLL (Network DDE NetBIOS Interface) NETDDE.EXE (Network DDE - DDE Communication)
Microsoft licensed a basic (NetBIOS Frames protocol only) version of the product for inclusion in various versions of Windows from Windows for Workgroups to Windows XP. In addition, Wonderware also sold an enhanced version of NetDDE to their own customers that included support for TCP/IP. The technology is extensively used in the SCADA field. Basic Windows applications using NetDDE are Clipbook Viewer, WinChat and Microsoft Hearts.
NetDDE was still included with Windows Server 2003 and Windows XP Service Pack 2, although it was disabled by default. It has been removed entirely in Windows Vista. However, this will not prevent existing versions of NetDDE from being installed and functioning on later versions of Windows.
- Component Object Model (COM)
- Distributed Component Object Model (DCOM)
- Microsoft .NET
- Object Linking and Embedding (OLE)
- Observer pattern
- Charles Petzold. "Dynamic Data Exchange" in Programming for Windows 95. Microsoft Press.
- MSDN: About Dynamic Data Exchange (DDE)
- Dynamic Data Exchange (DDE) and NetDDE FAQ
- Clojure Bindings for DDE, for use in Clojure or Java Applications