| DOTS and Microsoft Office |
 |
 |
|
Save Time by Automating Time Consuming Data Entry No software and no plug-ins mean fast application roll-out. Automatically refresh online information contained within Office documents With Service Objects' DOTS Web Services, you can deliver online information direction to desktop applications, such as Microsoft Excel and Word, and keep that information up-to-date as it changes. DOTS Web Services are the ideal solution for applications needing to deliver online information to the desktop in a controlled and programmable fashion. With no additional plug-ins, Microsoft Excel can communicate through XML messaging to the DOTS central server, unlocking the true potential of Excel with bi-directional, real-time data gathering and access. The DOTS Server maintains a library of live data sources that can be queried and updated directly through Excel. DOTS access data sources such as relational databases; customer relationship applications, financial feeds, and other Web-based providers. Web Services support provides out-of-the-box, code-free integration with .NET and J2EE systems, leveraging the W3C's XML, SOAP, WSDL, and UDDI standards. It is possible to call DOTS from within any Microsoft Office application. If you have the .Net Framework you already have everything you need to use DOTS in your Office application. If you don't have .Net Framework, then you should install the Microsoft SOAP Toolkit 3.0 (see link below). All DOTS Web services support the Web Services Definition Language (WSDL) 1.1 standard. WSDL is a formal way to describe SOAP message formats in a human- or machine-readable format. The SOAP Toolkit 2.0 reads WSDL files and dynamically generates COM interfaces that correspond to the operations defined in the WSDL file. Microsoft SOAP Toolkit 3.0 DOTS GeoPhone Example for Excel DOTS IP Address Validation Example for Excel |