This presentation explores the challenges encountered in integrating Esri's Utility Network Data Model (UNDM) with CGI’s PragmaLINE Outage Management System (OMS), a critical component for efficient utility operations. The integration process has relied on manual data model adjustments and JCMB's DataPort for Extract, Transform, Load (ETL) operations to facilitate data flow between systems. These tools have been essential in overcoming integration challenges, ensuring data consistency and compatibility between Esri’s UNDM and CGI’s OMS. Throughout the project, several key data model challenges emerged, highlighting the complexity of the data and underscoring the critical collaboration between various business units essential for the success of the integration. This presentation will discuss the specific issues that arose, such as data inconsistencies and interoperability hurdles, and the approaches we took to resolve them. From leveraging manual data model adjustments to utilizing ETL processes, we will explore the solutions that were implemented to ensure data integrity and seamless integration. Additionally, the presentation will touch on the ongoing efforts to address emerging data anomalies and the collaborative work between various business units that was vital to overcoming these challenges.
