Open Access Open Access  Restricted Access Subscription or Fee Access

Exchange of Data between PLM and ERP Systems through Middleware Integration

B.N. Prashanth, R. Pramod, M.E. Shashi Kumar, S.M. Mahesh


PLM and ERP are key components of any manufacturer‘s application strategy, and should be adopted in a way that it encourages and supports product innovation. Both PLM and ERP are important, and should be prioritized and selected based on business need and relative product capabilities. Since any transaction of components, whether it is a design of a Prototype or a Production component or generating manufacturing plan or specifying purchase requirements at the company should happen through their ERP system. The above being the case, the creation of Item Master and BOM in ERP system happens to be one of the most important aspects even for the New Product Development process. In the present scenario, the format incompatibility between Windchill and ERP suites resulted in loss of productivity during the exchange of data at both Engineering and Managerial levels. The above being the case, an Enterprise Application Integration (EAI) software provided by TIBCO® is used for the exchange of data between various Oracle Databases. Connecting PLM and ERP systems through middleware integration- optimizes and automates business processes, improves operational efficiencies, and creates opportunities to add value not available with isolated systems. Further the integration allows direct sharing of engineering and manufacturing data through an automated process ensuring seamless information flow between functional groups, such as engineering and manufacturing and their respective enterprise applications and the synchronization of these systems is an ensured receipt of the most current design information for more efficient production processes. The work concludes in creating an integrated environment which decreases redundant efforts and guarantees that all departments involved in the product development and manufacturing cycle have access to current and accurate product data and being able to deliver higher quality products in less time and maintain a competitive advantage in the marketplace.


Product Data, PLM, ERP, Middleware Integration, Manufacturing Data

Full Text:



B.N. Prashanth, R. Pramod, M.E. Shashi Kumar and S.M. Mahesh, ―Exchange of Data between PLM and ERP Systems through Middleware Integration‖, Conference Proceedings ICAET‘2011.

Teamcenter Gateway for SAP, A collaborative framework for transforming PLM and ERP integration, [Online]. as sited on 02/08/2008.

Fre´de´ric Danesi, Nicolas Gardan, Yvon Gardan and Michael Reimeringer, P4LM: A methodology for product lifecycle management, Computers in Industry 59, pp. 304–317, 2008.

Sudarsan S.J, Fenves R.D, Sriram and F. Wang, A product information modeling framework for product lifecycle management, Computer-Aided Design 37, pp. 1399–1411, 2005.

C.D. Tarantilis, C.T. Kiranoudis and N.D. Theodorakopoulos, A Web-based ERP system for business services and supply chain management:Application to real-world process scheduling, European Journal of Operational Research 187, pp. 1310–1326, 2005.

J X Gao, Hayder Aziz, P G Maropoulos and W M Cheung, Application of Product Data Management Technologies for Enterprise Integration, International Journal of Computer Integrated Manufacturing, vol. 16, Iss. 7-8, pp. 491-500, Oct-Dec. 2003.

Michael Burkett, Kevin O'Marah and Laura Carrillo, CAD Versus ERP Versus PDM: How Best To Anchor a PLM Strategy?, Sep. 30, 2003.

Jim Brown, Can ERP Speak PLM?, Aug. 1, 2003.

Severin V. Grabski and Stewart A. Leech, Complementary controls and ERP implementation success, International Journal of Accounting Information Systems 8, pp. 17–39, 2007.

White Paper Windchill ESI, Connecting PLM to ERP and other Enterprise Systems with Windchill ESI, [Online]. as sited on 30/08/2008.

Aberdeen Group, Enabling Product Innovation: The Roles of ERP and PLM in the Product Lifecycle, Nov. 2005.

Vale´rie Botta-Genoulaz and Pierre-Alain Millet, A classification for better use of ERP systems, Computers in Industry 56, pp. 573–587, 2005.

Liaquat Hossain, Jon David Patrick and M.A. Rashid, Enterprise Resource Planning-Global Opportunities & Challenges, Idea Group Publishing, pp. 15-27.

F. Robert Jacobs, F.C. ‗Ted‘ Weston Jr., Enterprise resource planning (ERP)—A brief history, Journal of Operations Management 25, pp. 357–363, 2007.

Mahesh Gupta and Amarpreet Kohli, Enterprise resource planning systems and its implications for operations function, Technovation 26, pp. 687–696, 2006.

Chuck Cimalore, ERP and PLM: Defining Their Roles and Creating a Collaborative Environment for Success, pp. 1-4.

Press Release, Grand River Successfully Integrates ERP System with PTC Windchill, [Online]. as sited on 31/08/2008.

A CIMdata Report, PLM and ERP Integration: Business Efficiency and Value, pp. 3-10.

Frederic Adam and David Sammon, the Enterprise Resource Planning Decade: Lessons Learned and Issues for the Future, Idea Group Publishing 2004.

Shyam Durai, Industry requirements and the benefits of Product Lifecycle Management, Cranfield University, 2006-09-06.

Sudarsan Rachuri, Eswaran Subrahmanian, Abdelaziz Bouras, Steven J. Fenves, Sebti Foufou and Ram D. Sriram, Information sharing and exchange in the context of product lifecycle management: Role of standards, Jun. 2007.

Release, New Windchill Module Delivers Turnkey Integration to Connect PLM with ERP, [Online]. as sited on 02/09/2008.

Vijay Srinivasan, Open Standards for Product Lifecycle Management, International Journal on Product Lifecycle Management.

Gu¨nther Schuh , Henrique Rozenfeld , Dirk Assmus and Eduardo Zancul, Process oriented framework to support PLM implementation, Computers in Industry 59, pp. 210–218, 2008.

Antti Saaksvuori and Anselmi Immonen, Product Lifecycle Management - Second Edition, Springer 2003.

Eswaran Subrahmanian, Sudarsan Rachuri, Steven J. Fenves, Sebti Foufou and Ram D. Sriram, Product Lifecycle Management Support: A Challenge in Supporting Product Design and Manufacturing in a Networked Economy, MD 20899-8263.

A CIMdata Report, Service-Oriented Architecture for PLM, an Overview of UGS‘ SOA Approach, Sep. 2006.

Claire Berchet, Georges Habchi, ―The implementation and deployment of an ERP system: An industrial case study‖, Computers in Industry 56 (2005) 588–605.

Windchill 8.0, April 2007, ―ERP Connector User‘s Guide‖, pp-2-1.

PLMIG 2005, ―Two Views of PLM & ERP‖, May 2005, Issue No. 17.


  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.