Technology
Aveva
Industry
Petrochemical
Client
NATPET
Country
KSA
Goals
Develop app to automate data extraction from InfoPath forms
Integrate extracted data into SQL Server and PI System
Improve lab data entry accuracy and efficiency
Enable real-time data updates via RDBMS interface
Challenges
Parsing complex XML data accurately from InfoPath forms
Mapping XML data to correct PI tags with precision
Ensuring data consistency across SQL Server and PI System
Configuring reliable RDBMS interfaces for automation
Solutions
Built custom application to read and parse InfoPath XML data
Configured PI tags to receive automated lab data entries
Established seamless, reliable data transfer from SQL Server to PI System
Tested and validated the entire automated data pipeline
Results
Automated lab data integration boosting accuracy and efficiency
Reliable, real-time updates to PI System from InfoPath data
Improved operational workflows with reduced manual input errors
High client satisfaction with project delivery and functionality
 |
InfoPath Forms Data AutomationEMI also delivered a transformative automation project aimed at streamlining laboratory data management for NATPET. The project involved developing a custom application capable of extracting complex XML data from SharePoint InfoPath forms and integrating it efficiently into SQL Server and the PI System. This automation addressed critical challenges such as parsing structured XML data accurately, mapping it to the correct PI tags, and ensuring consistency across different systems. |
EMI configured PI tags to receive automated laboratory data entries and established a reliable RDBMS interface to enable real-time data transfer from SQL Server to the PI System. The entire pipeline was thoroughly tested and validated to ensure accuracy, reliability, and operational efficiency. As a result, the automation eliminated manual data entry errors, accelerated laboratory workflows, and enabled timely updates to the PI System, significantly improving NATPET’s data management capabilities. The project was completed successfully, meeting all objectives and earning high client satisfaction due to its impact on operational efficiency and data accuracy.