Microsoft Office Integration with PLM Solution

The design solution was Aras MS Office Connector, a full-featured, business-ready solution built on top of MS Office. It extends MS Office functionality into Aras PLM, providing a simple and flexible way to incorporate MS Office documents into PLM processes.

aras
Customer: Aras

Client
Aras is the leading provider of enterprise open source Product Lifecycle Management (PLM) software solutions. Freedom from licensing eliminates up-front expenses and per user costs while superior technology makes Aras the most advanced enterprise PLM solution suite available. Customers include Motorola, Freudenberg, GE, Hitachi, Lockheed Martin, Rolls-Royce, Textron and TEVA Pharmaceuticals. Aras is privately held with global headquarters in Andover, MA.

Business Challenge
MS Office is used extensively in business operations, including PLM. Many Aras customers incorporate MS Office documents into their PLM processes. These customers want to streamline their processes by directly accessing MS Office documents in their PLM solution, eliminating the barrier between MS Office and PLM.

Solution
The design solution was Aras MS Office Connector, a full-featured, business-ready solution built on top of MS Office. It extends MS Office functionality into Aras PLM, providing a simple and flexible way to incorporate MS Office documents into PLM processes.

Design Challenges
Key technical and operation challenges included:

  • Installation

PLM systems are known to be difficult to set up and configure for specific business needs. Once the system is up and running, training personnel to use them effectively can require considerable time and investment. For this reason Aras Office Connector had to be implemented to provide packaged functionality out-of-the-box, optimized for corporate-wide PLM business processes, and designed with a familiar look and feel to get users throughout the company up and running quickly.

  • Security

Product designs and other project documentation are highly confidential, so the system had to be implemented to provide security features to satisfy the most demanding regulatory environments.

  • Technology

Requirements for hardware and software infrastructure for Aras Office Connector had to be the same as for MS Office

The Solution
The solution consisted of two components:

  • Extension (add-in) for MS Office
  • Customized version of Aras Innovator

scrArasOfficeConnector1

The solution achieves customization of Aras Innovator by setting up administrative preferences and implementation of server-side API methods to support integration with the client-side extension for MS Office. The client-side extension for MS Office was implemented so as to support the Aras user experience.

To customize a solution for specific business needs, Aras Office Connector uses the same model based SOA framework as Aras Innovator.

Implementation
At the start of the project, Aras provided functional specifications that were only 50% complete. On receipt of these initial project specifications, the AMC Bridge team thoroughly reviewed the documentation, clarified requirements with an Aras product definition specialist, estimated the time required for each task, and proposed a development schedule approved by an Aras project manager, with the understanding that the specification would need to be completed, and probably modified, during the actual development process.

After project development began, the quality assurance engineer assigned to the project developed a set of test plans for the product, which were approved by the Aras project manager.
In order to keep everyone up-to-date on the progress of development and quality assurance, weekly conference calls were set up with the full team. These provided an excellent platform for resolving issues in a timely manner.

Project development of the project was accomplished in iterations, providing deliverables of the developed functionality on a regular basis. This made it possible for the quality assurance engineer to test each iteration, for product definition specialists to ensure that the functionality was properly implemented, and for user interactions to be continuously evaluated and improved.

AMC Bridge Performance
Although the product had to be developed within a tight time frame, Aras decided to use an offshore software development model and retained AMC Bridge for development and quality assurance because of its proven track record of successfully-completed MS Office related projects. The quality of work delivered by AMC Bridge exceeded client expectations:

  • AMC Bridge provided quality results based on project specifications that were refined and completed during the development process.
  • AMC Bridge proved resourceful at filling in gaps and providing experience-based solutions, and especially excelled during implementation of the Aras Innovator server-side preferences and MS Office add-in.
  • During stabilization of the product AMC Bridge proved to be quick and responsive, with short turnaround time.
  • The project was completed well within the schedule and budget.

 

Sep 25, 2013
You may also be interested in:
Innovate, Transcend, Realize—Aras ACE 2019 (Commentary)

Key takeaways:

  • Aras’ mission is simple—Great, Good, Important—great for shareholders, good for stakeholders, and solving important problems.
  • Recent investments of $110M from top tier investors are helping support Aras’s 55% annual growth rate, acquisitions, headcount increases to almost 500 people, and internal process retooling.
  • Customer presentations from Microsoft and GM described the scale and scope of problems that can be solved with Aras Innovator.
  • Aras continues to focus on the product lifecycle from requirements and systems engineering through simulation, design, manufacturing, to MRO.
May 30, 2019
more
Dassault Systèmes and Centric Software Come Together to Accelerate Digital Transformation of Fashion, Retail and Consumer Goods Companies: Dassault Systèmes to Acquire Majority Stake in Centric Software

Dassault Systèmes (Euronext Paris: #13065, DSY.PA) today announced that it has entered into a definitive agreement to acquire a majority stake in Centric Software, a privately-owned industry market leader driving digital transformation with software innovation in the fashion, apparel, luxury and retail sectors. With this investment, Dassault Systèmes aims to accelerate the digital transformation of companies seeking solutions for the increasingly complex development of collections that respond to today’s on-trend and on-demand consumers, representing a multi-billion dollar total addressable market.

Jun 14, 2018
more
Aras Introduces Flexible Effectivity to Solve How Manufacturers Manage Complex Effectivity at Scale

Aras®, the leader in open product lifecycle management (PLM) software for the enterprise, today announced availability of version 11 SP14 of the Aras PLM Platform, which features Effectivity Services. Aras delivers a flexible, multi-factor approach to effectivity to enable manufacturers to manage complex effectivity at scale. Using Aras’ Effectivity Services, organizations are able to create and apply customized effectivity rules and manage all variants in a single, dynamic product structure. The result is a massively simplified approach for engineering teams to specify and manage large numbers of variants and customized product configurations, collaborate on designs, and incorporate effectivity into the Digital Thread.

Jun 06, 2018
more
  • Top