sap integration at viena...
TRANSCRIPT
04.11.2015 1 Esri European User Conference 2015 – Salzburg, Austria ©2015 AED-SICAD
SAP Integration with GIS at Vienna Networks
Eric Schmalen, AED-SICAD AG Oct. 17th 2015
Esri European User Conference 2015, Salzburg, Austria
04.11.2015 2 Esri European User Conference 2015 – Salzburg, Austria
Agenda
1. Facts about Vienna Networks
2. Business process support with SAP-GIS integration
3. Types of integration
4. Analyses & reports
5. Summary
04.11.2015 3 Esri European User Conference 2015 – Salzburg, Austria
Some facts about Vienna Networks
Responsible for the operation and maintenance of
• Electricity network
• District heating network
• Telecommunication network
• Gas network
The largest gas distributor in Austria
• 683 059 customers
• 122 473 service points
• 678 323 gas meters
• 4 599 km length
A multi-utility enterprise GIS from Desktop to Web and Mobile solutions
04.11.2015 5 Esri European User Conference 2015 – Salzburg, Austria
Typical IT landscape of utility companies
Middleware for system integration
BAPI Adapt.
GIS
XML Adapt.
SOAP Adapt.
proprie-tary
RFC Adapt.
IDOC Adapt.
SAP <IT-System>
XML Adapt.
SOAP Adapt.
04.11.2015 6 Esri European User Conference 2015 – Salzburg, Austria
Business process support with SAP – GIS integration The chellange
Technical asset data:
• Line type
• Material
• Dimension
• Length
• Creation date
Administrative asset data:
• Value
• Booking year
• Maintenance period/order
• Depreciation
1 dataset from 2 datasources! But 1 real world object!
ArcFM UT Database
SAP Database
04.11.2015 7 Esri European User Conference 2015 – Salzburg, Austria
The middleware - UT Integrator • Based on Esri ArcGIS for Server • Bi-directional • Close to real-time • Synchronous / asynchronous • Interfaces
• SOAP / XML • IDoc • RFC • Table Reader • CSV files
• Reliable and secured communication • Logging (Messages, Jobs, …) • Email notification
Business process support with SAP – GIS integration
04.11.2015 8 Esri European User Conference 2015 – Salzburg, Austria
SAP - GIS interface improves three major processes
• Service Point Management
• Pipe Network surveillance
• Outage Management
ArcFM UT Integrator – interface from GIS to
• SAP PM
• SAP BI
Backend and Frontend integration
Business process support with SAP – GIS integration
04.11.2015 9 Esri European User Conference 2015 – Salzburg, Austria ©2015 AED-SICAD
Backend Integration
SAP Integration with GIS at Vienna Networks
04.11.2015 10 Esri European User Conference 2015 – Salzburg, Austria
Types of integration: Backend integration
SAP
XI
(WB
I / TIBC
O
/ BIZTA
LK)
SOAP
UT In
tegrator
Database SAP
SAP GUI ArcFM UT
IDoc
RFC
SOAP
ArcGIS Server
Fron
tend
B
ackend
Transfer of data and function calls in the background
04.11.2015 11 Esri European User Conference 2015 – Salzburg, Austria
Examples of Backend integration Creation of a new service point line
Middleware
automatically
generates a new
alpha-numerical
record in GIS and
transfers the
technical SP
attributes
UT Integrator
Service center creates a
new service point line in
SAP PM including all
technical attributes
SAP PM
GIS Engineer
draws the SP line
and connects the
alpha-numerical
record with the new
graphics
ArcFM UT
Advantage: Continous workflow, no paperwork anymore, errors avoided
04.11.2015 12 Esri European User Conference 2015 – Salzburg, Austria
reg
ula
tio
ns
UT Integrator and la
ws
Austrian Gas Norms
Examples of Backend integration
Pipe network surveillance and inspection
ArcFM UT SAP PM
Selection via spatial and attribute criteria
Grouping
Import of group into a „free“ Functional Location (FL)
Creation of maint. order
04.11.2015 13 Esri European User Conference 2015 – Salzburg, Austria ©2015 AED-SICAD
Frontend Integration
SAP Integration with GIS at Vienna Networks
04.11.2015 14 Esri European User Conference 2015 – Salzburg, Austria
Types of integration: Frontend integration Calling the GUI of the other system
SOAP
UT In
tegrator
Database SAP
IDOC
RFC
SOAP
ArcGIS Server
Fron
tend
B
ackend
Call of SAP GUI
SAP GUI WebGIS
SAP
XI
(WB
I / TIBC
O
/ BIZTA
LK)
04.11.2015 15 Esri European User Conference 2015 – Salzburg, Austria
Types of integration: Frontend integration Calling the GUI of the other system
SAP GUI
Fron
tend
Call of GIS GUI
WebGIS
SOAP
UT In
tegrator
Database SAP
IDOC
RFC
SOAP
ArcGIS Server
Backen
d
SAP
XI
(WB
I / TIBC
O
/ BIZTA
LK)
04.11.2015 16 Esri European User Conference 2015 – Salzburg, Austria
Examples of Frontend integration
With a Shortcut from GIS to SAP PM ...
Service point (SAP PM)
04.11.2015 17 Esri European User Conference 2015 – Salzburg, Austria
Examples of Frontend integration
... directly to the corresponding functional location in SAP PM …
Service point (SAP PM)
04.11.2015 18 Esri European User Conference 2015 – Salzburg, Austria
Examples of Frontend integration
Access to all wellknown SAP PM functions, e.g.: show
components, meter status, commissions, …
Service point (SAP PM)
04.11.2015 19 Esri European User Conference 2015 – Salzburg, Austria
Examples of Frontend integration Regulator stations (SAP PM)
Works in the same
way with gas
regulator stations…
© 2
01
4 W
IEN
ER
NE
TZ
E G
mb
H, M
art
in
ST
RO
BL
04.11.2015 20 Esri European User Conference 2015 – Salzburg, Austria
Examples of Frontend integration Regulator stations (SAP PM)
with just a few mouse clicks all details of the regulator
are available!
04.11.2015 21 Esri European User Conference 2015 – Salzburg, Austria
Examples of Frontend integration Supply situation - integrated data query with GIS & SAP PM
Which customers
are supplied by this
service point?
This can be displayed in
the map by GIS – SAP
integration !
04.11.2015 24 Esri European User Conference 2015 – Salzburg, Austria
Examples of Frontend integration Display of consumption situation (SAP PM)
© 2
01
4 W
IEN
ER
NE
TZ
E G
mb
H, M
art
in
ST
RO
BL
Consumption average
over the last 3years!
04.11.2015 25 Esri European User Conference 2015 – Salzburg, Austria
Outage Management with GIS and SAP
Outage Management starts in SAP PM where a fault
notification is created ...
04.11.2015 26 Esri European User Conference 2015 – Salzburg, Austria
All fault information such as construction documents are
stored in SAP PM. Location of the fault is
documented in GIS –easily accessed via button in SAP
Outage message
Outage Management with GIS and SAP
04.11.2015 27 Esri European User Conference 2015 – Salzburg, Austria
Outage Management with GIS and SAP
A symbol which is linked to the fault message shows the location in
WebGIS
04.11.2015 28 Esri European User Conference 2015 – Salzburg, Austria ©2015 AED-SICAD
Analysis & Reports
SAP Integration with GIS at Vienna Networks
04.11.2015 29 Esri European User Conference 2015 – Salzburg, Austria
Analyses & Reports
UT Integrator
+ =
Examples: How many outages in a certain district? Which materials were involved? Injured persons?
04.11.2015 30 Esri European User Conference 2015 – Salzburg, Austria
Simulation calculator
Trend analysis, Fault propability,
Strategy for exchanging assets
Analysis & Reports
BI – Output
04.11.2015 31 Esri European User Conference 2015 – Salzburg, Austria
Enterprise GIS integration with SAP
Benefits for Vienna Networks
• Business process support across established IT-Systems
• GIS and SAP information synchronized and combined in one BI database for processing, analysis, reporting, asset management
• Better documentation with GIS and SAP integration
• Better visualization of asset information in the map
• Better informed enterprise decisions
• Reliability of processes and operations improved
• Reduced costs through lean and efficient processes
More details: Please read AED-SICAD forum international 2014 p 10-12
04.11.2015 32 Esri European User Conference 2015 – Salzburg, Austria
Thank you for your attention!
Eric Schmalen
AED-SICAD AG
Carl-Wery-Str. 22
81739 München
www.aed-sicad.de