Automation of Business Process by Optimization of Data Extraction and Loading
An automobile industry is transitioning to a new electronic enterprise Product Lifecycle Management (PLM) environment using the WindchillPDMLink 10.0 application from Windchill 5.0. The development teams were using software called EIS, which does not have proper workflow. Even though new software exists the users were using the legacy EIS database. Data migration between EIS and WindchillPDMLink 10.0 has to be performed parallel. This involved a mechanism of downloading the data from EIS database and upload into Windchill database. In order to extract the data from EIS database, SQL scripting language is used.