Waterworks’ SAP-GIS Integration

1. Waterworks’ SAP-GIS Integration Charlene Sevier and Marietta Washington Newport News Waterworks

2. Waterworks had silos of information. Customer and Billing information GIS data There was redundancy and often duplication of effort. Work processes would be improved by integrating systems GIS was at the tail-end of most business processes Background

3. Overall Vision • The Waterworks Information Technology Division is tasked to upgrade all major systems. • The division will strive to increase efficiency and productivity while guiding investments in technology to meet the growing business needs of Newport News Waterworks and our service community.

4. In July 2007 Waterworks went live with SAP CIS GIS was integrated with SAP as part of the project The Customer Information System

5. CIS-GIS Integration Scope of Work • Business Strategy Summary The project included integration of its SAP Industry Solution for Utilities and ESRI’s ArcGIS Server Technology to produce a near-time exchange of customer related information between SAP and GIS. The effort included strategic visioning for GIS over the longer term, system architecture design, and application design and development.

6. SAP-GIS Integration Scope of Work • Business Process Involved • Customer reps are using maps to improve customer service and provide problem resolution more quickly • Dispatchers are better informed of customer issues and better informed in the field • New device locations are automatically being created in GIS. Customer wants service at a new address, the system takes address and creates X/Y point and automatically draws on a map. • Engineering uses the data to track consumption and plot high demand

7. SAP – GIS Integration Components A fully interactive map triggered from within the SAP CRM GUI Integrated Map An outbound transfer of new supply points / service locations SAP to GIS Geographically allocated attributes such as meter reading routes, cross streets and zip codes are sent to SAP GIS to SAP Transfer of customer, metering, service line and consumption Information from SAP to GIS Nightly Synchronization Components of the Integration

8. A map window was added to the SAP 80% screen that displays Water utility features (pipes, laterals, hydrants, valves, and meter locations) Water quality service order locations Planned activity area General information (roads, buildings, etc.) The Integrated Map

9. The Integrated Map

10. Viewing GIS Data in SAP The Integrated Map Select the Identify tool see the combination of SAP and GIS attributes for service locations.

11. Viewing Water Quality Concern Details The Integrated Map This identifies a location where a service order has been created in SAP. Water Quality Activity is updated on the map as it is entered in SAP

12. Viewing Planned and Unplanned Field Activity The Integrated Map The map provides a way to show areas of activity such as • Pipe Breaks • Hydrant Maintenance • Planned Improvements

13. Requirements for the Interactive Map • SAP IS-U/CCS • Uses ArcGIS Server 9.2 • ArcGIS 9.2 • SQL Server 2005 • Messaging Gateway • Messaging Web Service • XI XI

14. SAP – GIS Integration Components A fully interactive map triggered from within the SAP CRM GUI Integrated Map An outbound transfer of new supply points / service locations SAP to GIS Components of the Integration

15. Process view – Example ‘Create Locations’ for Non-Individuals GIS system moves data to a holding table GIS system merges point from AutoCAD with data from SAP GIS Team confirms location Planned service location added to design in AutoCAD Service location data sent to GIS via XI Temporary point placed on the map Location data is sent to SAP via XI Technical Master Data created in SAP GIS infrastructure AutoCAD SAP XI

16. Service location details sent to GIS via XI Address details for the service location are geocoded Process view – Example ‘Create Functional Location’ for Individuals GIS processes inbound record from XI match No match User creates TMD for new service in SAP GIS team confirms location Temporary point placed on the map Location data sent to SAP via XI GIS team adds point to the map Record is stored in a temporary table GIS infrastructure SAP XI

17. Requirements for the SAP to GIS Transfers • SAP CIS (IS-U/CCS) • ArcGIS 9.2 • SQL Server 2005 • Messaging Gateway • XI

18. SAP – GIS Integration Components A fully interactive map triggered from within the SAP CRM GUI Integrated Map An outbound transfer of new supply points / service locations SAP to GIS Geographically allocated attributes such as meter reading routes, cross streets and zip codes are sent to SAP GIS to SAP Components of the Integration

19. GIS Updates SAP • Customized Editing Tools • When GIS confirms a location the map grid, zip code and meter reading route are sent to SAP • When the cross street is added or updated it is sent to SAP • New tools created to associated table records with the correct point

20. GIS Updates SAP

21. Updating Meter Reading Routes GIS assigns meter reading routes

22. GIS to SAP Requirements • Custom Code • ArcGIS 9.2 • SQL Server 2005 • Messaging Gateway • Messaging Web Service • XI

23. SAP – GIS Integration Components A fully interactive map triggered from within the SAP CRM GUI Integrated Map An outbound transfer of new supply points / service locations SAP to GIS Geographically allocated attributes such as meter reading routes, cross streets and zip codes are sent to SAP GIS to SAP Transfer of customer, metering, service line and consumption Information from SAP to GIS Nightly Synchronization Components of the Integration

24. The nightly process sends updated attributes to GIS including Move-in and move-outs Meter changes Consumption information Data is sent using XI and written to a holding table Nightly Synchronization

25. Nightly Synchronization Requirements • Uses ArcGIS Server 9.1 • ArcGIS 9.1 • SQL Server 200X • XI XI

26. Network Infrastructure • GIS operations hosted at Waterworks • SAP functionality being hosted offsite • For the SAP MapIt functionality there are two transports through the network for the SAP user to retrieve the map image

27. Newport News Waterworks Benefits • The amount of time it takes to update the GIS with confirmed service locations has been reduced to less than 1/3 of the time it took in the past. • By providing high performance real-time and batch links between the two systems, data integrity is ensured and both systems offer enhanced capabilites for end-users, delivering critical operation information (such as outages and networks issues) rapidly throughout the organization

28. Newport News Waterworks Benefits • Customer Service Representatives use the integrated map to see the locations of water quality complaints or if a customer lives in an area where there is planned activity • Dispatchers use the integrated map to quickly determine which map page and grid a service location is in

29. Newport News Waterworks Benefits • The Meter Shop and Meter Reading use it to assist with planning • Casual users get a frame of reference for the location of a customer or meter • All users benefit from up-to-date information in the context of other information about the account

30. Marietta Washington mvwashington@nngov.com Charlene Sevier csevier@nngov.com