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.