Model Web Services Business Logic with Microsoft Excel

Freiburg, December 1, 2005 -- Jedox GmbH now offers an enterprise solution for Microsoft Excel: its new Worksheet-Server extension enables business analysts to create SOAP-compatible Web services using Microsoft Excel. Through this technology, Excel users from operational or technical departments across the enterprise can create Web services, using their expert knowledge directly without having to take the detour of time-consuming coding by a programming specialist. These Web services can then be accessed through any SOAP compatible architecture such as .NET, Java, or SAP NetWeaver. The new technique is demonstrated in detail at http://www.jedox.com.

Expert users and business analysts are now able to set up their own Web services, opening an interesting perspective on how software systems can be developed from now on. The basic maintenance such as authentication, application control, and database transactions will remain the responsibility of IT specialists in the centralized data processing departments. The managerial, commercial, and technical contents, however, can now be developed and kept up-to-date within the departments themselves. The result can be made available to their addressees easily in a Service Oriented Architecture (SOA). This saves coding and coordination expenses and reduces development time for both newly implemented and modified functionality.

A typical example is a pricing tool for a technical product. Based on a set of given parameters, a Web service would retrieve the appropriate product and calculate the price and conditions automatically. A demo on the Jedox Web site shows in detail, how an existing Excel workbook can be transformed into such a Web service application and how it can then be used through .NET or PHP.

About Jedox

Jedox GmbH, based in Freiburg im Breisgau (Germany), is a leading supplier for Excel-to-Web Solutions. More information about Jedox can be found at http://www.jedox.com.

Must Read Articles