Cindy Jutras: ERP meets the desktop

In the front and back offices of manufacturing companies, it's hard to imagine life without desktop productivity tools. Word processing programs, spreadsheets, and email are used by 95 percent of those dubbed “information workers.” The majority of these tools are delivered to the desktop by Microsoft.


In the front and back offices of manufacturing companies, it's hard to imagine life without desktop productivity tools. Word processing programs, spreadsheets, and email are used by 95 percent of those dubbed “information workers.” The majority of these tools are delivered to the desktop by Microsoft.

In a recent Aberdeen study on the convergence of enterprise applications with the desktop, Microsoft Office products were used in 82 percent to 99 percent of the cases. The only other vendor's product used by more than 5 percent of our survey participants was IBM Lotus Notes.

This market dominance by Microsoft—and the growing interest in the convergence of enterprise applications with desktop tools—spawned a flurry of partnership activity between the desktop giant and numerous enterprise application vendors:

  • SAP led the way with joint development of its cobranded Duet product, an approach that takes data from SAP and presents it in Office applications like Outlook.

  • Epicor's Information Worker product, released about a year ago, took a similar approach.

  • Sage and IFS used a more Excel-centric approach, presenting data in such a way that users don't have to export data to Excel—they have the advantage of a familiar look and feel without ever leaving the application.

  • Exact developed its own Web-based collaboration platform, e-Synergy, but also has a Microsoft add-in, so users can save items from any Microsoft Office application directly into e-Synergy.

What's the point? From the end user's perspective it's all about improving personal productivity, with the hope that this will translate to corporate productivity, which means profitable growth without an exorbitant investment in new staff. From the ERP vendor's point of view, it's about turning more workers into ERP users.

The key to wider adoption of enterprise applications throughout the organization is to make them easily accessible, intuitive to navigate, and perhaps even transparent to users who may not know they are touching applications such as ERP. One approach is to provide access through the familiar interface of a desktop application such as the Microsoft Office suite. This essentially turns the enterprise application into a natural extension to the desktop, reducing the user learning curve and simplifying access to enterprise information.

Not surprisingly, ERP is the enterprise application that enables the most opportunity for productivity improvement through integration with desktop tools. Data drives decisions. Since ERP forms the basic system of record for most operational and financial transactions, it is easy to see why the data stored in these systems is of most interest. Extracting data from ERP to create Microsoft Office Word documents and Excel spreadsheets is an attractive vehicle for many information workers looking to analyze and share data. Unfortunately it is not as easy to prevent data from being manipulated in these documents and then propagated throughout the organization, therefore risking bad decisions based on inaccurate or incomplete data.

The extraction of data is a baby step in the convergence of enterprise applications with desktop tools, and here the goals of the end users and the ERP vendors converge, providing easy access and easy analysis in a familiar setting while keeping users captive within ERP.

Author Information

Cindy Jutras, who oversees research and client development related to manufacturing at Boston-based AberdeenGroup, has more than 30 years worth of ERP and supply chain-related experience. Cindy, a former director for a prominent enterprise vendor, has authored numerous white papers as well as a book titled ERP Optimization.

No comments
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by...
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Additive manufacturing benefits; HMI and sensor tips; System integrator advice; Innovations from the industry
Robotic safety, collaboration, standards; DCS migration tips; IT/OT convergence; 2017 Control Engineering Salary and Career Survey
Integrated mobility; Artificial intelligence; Predictive motion control; Sensors and control system inputs; Asset Management; Cybersecurity
Featured articles highlight technologies that enable the Industrial Internet of Things, IIoT-related products and strategies to get data more easily to the user.
This article collection contains several articles on how automation and controls are helping human-machine interface (HMI) hardware and software advance.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Mobility as the means to offshore innovation; Preventing another Deepwater Horizon; ROVs as subsea robots; SCADA and the radio spectrum
Future of oil and gas projects; Reservoir models; The importance of SCADA to oil and gas
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me