A Unified Data Architecture for Multi-System Construction Environments: Integrating Salesforce, Procore, And ERP Platforms

Abstract

The construction industry faces significant challenges due to fragmented data across platforms such as Salesforce CRM, Procore project management, and ERP systems, leading to inefficiencies, delays, cost overruns, and poor decision-making. This research proposes a Unified Data Architecture (UDA) that integrates these systems, leveraging API-led connectivity and introducing a novel Sensible Analytical System (SAS) for real-time sentiment analysis of project communications. The proposed solution aims to enhance data synchronization, improve decision-making, and predict project outcomes more accurately. The UDA is tested on a simulated dataset of 100 construction projects, reflecting industry data distributions, and demonstrates a 97.9% reduction in synchronization time and a 26% improvement in forecasting accuracy. The SAS module also helps predict project delays by analyzing sentiment in RFIs, submittals, and emails. The findings extend multi-system integration paradigms to the construction industry, enabling proactive risk management and scalable analytics across platforms. The proposed framework aligns with current industry trends towards digital transformation, offering a comprehensive solution for improving operational efficiency, project tracking, and risk management in construction projects.