Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Build, protect and deploy apps across any platform and mobile device
Automate decision processes with a no-code business rules engine
A complete cloud platform for an app or your entire digital business
Deploy automated machine learning to accurately predict machine failures with technology optimized for Industrial IoT.
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
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 salesforce.com system. We’ll access salesforce.com 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 salesforce.com system updated. No need to manually enter all the data in salesforce.com, 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 salesforce.com 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.
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.
Copyright © 2017 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.