Integrating Office applications with - Part I

Integrating Office applications with - Part I

May 05, 2009 0 Comments

As a regular reader of this blog, you probably remember we discussed at various occasions the ability to query, update and create Microsoft Office documents, using the DataDirect Integration Suite. But wait... all those examples were based on Microsoft Excel? As you expect, nothing prevents you from querying other formats, like Microsoft Word documents.

As we’ve discussed before, DataDirect XQuery, an integral part of DataDirect Integration Suite, allows to integrate diverse systems, in a simple and declarative way. For example, it also offers the ability to easily access web services.

In this new series we will show how to retrieve your business data from a Microsoft Word documents, and use that information to update your system. We’ll access through its web service interface.

Let’s consider a fairly simple scenario. The sales representatives at your company, compile their reports in Microsoft Word form, when flying home, on the train, wherever. Back in the office, the trip report is processed, and the system updated. No need to manually enter all the data in, no more error-prone copy/paste. Everything is handled through an automated system.

The Microsoft Word document could look as follows.

And after processing, we have the following account information in our system. Note that it does not only include the general account details, but also one or more contacts, and has the trip report attached as a note. In other words, multiple records are inserted and updated. And the process actually behaves conditionally. For example, if the account does not yet exist go through the creation of a new account, but if it exists only the new trip report needs to be added to the account.

In this series we’ll build step by step such solution, sharing concrete and fully functional code.


Marc Van Cappellen

View all posts from Marc Van Cappellen on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.

Comments are disabled in preview mode.
Latest Stories in
Your Inbox
More From Progress
The New Mobile Development Landscape
Download Whitepaper
IDC Spotlight Sitefinity Thumbnail
Choosing the Right Digital Experience Platform to Improve Business Outcomes
Download Whitepaper
The Fastest Way to Build Mobile Apps With Cloud Data
Watch Webinar