Streamlining Torque Data with Real-Time Insights and Enterprise Integration
Zelite Solutions streamlined torque data management for a leading Railway manufacturer with a custom web application integrated with IoT components and enterprise systems like SAP. This solution automated data collection, enhanced accuracy, improved traceability, and facilitated real-time insights, empowering informed decision-making and boosting operational efficiency.
Industry
Time Required
Engagement Model
Solution
Current Phase
Technologies
A leading manufacturer in the Railways sector faced the following challenges with their current torque data management process:
- Manual Data Collection: Time-consuming and prone to errors.
- Data Silos: Lack of centralized data storage hindered analysis and reporting.
- Limited Traceability: Difficulty in associating torque data with specific bogies.
- Real-Time Needs: Access to real-time torque data was essential for improved decision-making during testing.
- Enterprise Integration: Seamless data exchange with SAP and Alert Gateway systems was required for centralized data management and timely alerts.
Zelite Solutions designed and developed a custom web application with a 3-tier architecture and modern technologies to provide a comprehensive solution:
- API Architecture: An API Gateway acts as a single-entry point for external systems and devices to access functionalities. Secured APIs enable communication between the web application and various components.
- Frontend: An Angular framework-based user interface facilitates efficient interaction for managing bogies, Bogie Torque Sensors, test data, and reports.
- Backend: Robust .NET Core server-side technologies ensure secure data storage and processing of collected torque data.
- Database: A scalable Microsoft SQL Server (MS SQL) database management system efficiently stores and manages torque data for easy retrieval and analysis.
- Data Integrator: This component facilitates data transfer between various sources:
- Bogie Torque Sensors: Secure two-way communication with Bogie Torque Sensors enables real-time data acquisition from torquing tools.
- SAP System: APIs enable seamless data exchange with the client’s SAP system for centralized data management.
- Alert Gateway: Integration with the Alert Gateway allows for sending and receiving alerts related to critical torque data deviations, ensuring timely response to potential issues.
- Admin Module: Manage user access, roles, and system configurations.
- User Management: Create, manage, and assign roles to users within the system.
- Bogie Management: Create and manage bogies (test equipment units) within the system.
- Bogie Torque Sensor Management: Configure and manage Bogie Torque Sensors associated with specific bogies.
- Test Data Management: Set up test procedures and map collected torque data to corresponding bogies.
- Data Visualization: Utilize Power BI to visualize torque data for better understanding and data-driven insights.
- Reporting: Generate comprehensive reports on:
- Torque Data: Analyze average, minimum, maximum, and standard deviation of torque measurements across test runs and bogies.
- Test Results: Identify trends, anomalies, and potential issues based on torque data and other test parameters.
- Compliance Reports: Ensure adherence to quality standards and specifications by documenting torque data for regulatory purposes.
- Increased Efficiency: Automation eliminates manual data collection, saving time and resources.
- Enhanced Data Accuracy: Real-time data acquisition reduces human error and ensures data integrity.
- Improved Traceability: Clear mapping of torque data to specific bogies facilitates better traceability and troubleshooting.
- Data-Driven Decisions: Real-time insights and Power BI visualizations enable informed decision-making throughout the testing process.
- Streamlined Enterprise Integration: Seamless data exchange with SAP and Alert Gateway improves overall operational efficiency and data visibility across the organization.
This custom web application empowered the client to gain better control over their torque data management, leverage IoT for real-time data acquisition, and utilize Power BI for data visualization. This ultimately contributed to improved product quality, efficiency, and data-driven decision-making.
