Integracion de DCIM con otras aplicaciones usando ETL service v2
-
Upload
software-greenhouse -
Category
Technology
-
view
120 -
download
0
Transcript of Integracion de DCIM con otras aplicaciones usando ETL service v2
StruxureWare integration Services
Struxureware Integration Model
StruxureWare for Datacenters
BMSEMS
CMDBSCADA
INVENTORYLEGACY
ETC.
Prebuiltintegrations
Customizedintegrations
Our integration model is flexible, based on prebuilt integrations and client customized integrations.
●Strategic partnerships and integrations help us bring IT and facilities closer together!
●Seamless user experience out of the box ●Easy to configure ●Easy to use●High performance
●Rigid integration model technology limited.
Prebuilt integrations
Customized integrationsBased on a new integration tool: ETL
cloud services
files
databases
systems
old systems
Data Center Operation
Data Center Operation
DCO DBETL
Staging DB
external
system
Federation mechanism
Flexible integration tool that helps to design and deploy client oriented integrations (based on individual client requests or systems).
Graphical editor and versioning help deploy and maintain integrations.
StruxureWare Data Center Operation – ETL Editor
Load the data into StruxureWare
Extract from any data source
Transform the data as needed
StruxureWare custom integration services
Integration focused on customer needs:●Custom-built CMDBs●Homegrown or heavily customized systems.●BMS tools with particular versions or implementations.●Other non standard customer integration requests.
And providing:●Seamless client experience, from implementation to
support.●Reliable service based on an expert ETL team.●Global guarantee and support of the whole solution.
An ETL integration service designed to…
●Provide a cost/effective integration process.●Cover all the customer needs with the highest level of
quality and support. ●Increase integration keeping cost low, integrating new tools
with legacy systems.●Two-way data exchange federate your physical Datacenter
into a virtual Datacenter including all your data.● No synchronization● The world is federated!
●Isolating the final user from process and data models complexity.
We have a dedicated team for processes and Data Integration with high-level ETL expertise and an strong background & experience in complex and heterogeneous integration solutions.
Platforms:
We even have our own ETL Workflow Execution planner: EWEP
An expert dedicated ETL Team
Integration References | Smart Meter Operation Center
Power and service meters network
Data Management ( Actual & Historical)
Event & Alerts
Management
Reporting & Statistics
GIS application
Power Metering Operational(Monitoring, Network
Management, Readings)
Fraud Management
BackgroundThe Smart Metering Platform has the purpose of installing smart electricity and gas meters to all customers, including the supporting IT applications and infrastructures. Integration Description
Added value
• Implementation of tools to support Meter Operation, and exploitation of their information.
• Monitor and display Smart Meters Network.
• Integration with SAP IS-U CRMB & Billing Systems
• Full integration of IT and IT Systems through SAP PI
• Improvement of network knowhow along with the deployment.
• Network problems detection and triggering of maintenance activities.
• Better energy management, lower costs and more precise invoicing.
• Better Power Quality, fraud detection, efficient tracing of outages, and predictive maintenance.
• Availability of real time information on consumption and voltage quality.
• A full integrated system of spatial visualization, events & alarms management, analysis and reporting
Some figures:• 132 ETL processes, more than 2.000 millions of processed
records daily, 1 hour duration and 20 millions of insertions.• 24 hours, 1 hour and 15 minutes executions.• 196 dependences rules. • 8 integrated systems: SAP ISU, AMM, MDM (Metering
Equipment), Event Management, GIS …• Initial phase: 25.000 electric meters, 15.000 gas meters, 25.000
smart communication devices.• Objective: 4.000.000 electric meters.
Assets Management
Spatial operation information
Enterprise information
Integration references| ILMPS System
BackgroundAW needs a new Integrated Leakage and Pressure Management system (ILPM) to address its business requirements for the effective management of Leakage and Pressure.Service Description
Value Added
• Design and development of the ILPMS System for Leackage and Pressure Management
• Integration design and implementation in a SAP landscape (PM, IS-U, FI-CO,…).
• Integration to third party systems (enterprise solution for customer): GIS, ERP (SAP) and Hydraulic Model, SCADA and Telemetry
• Business Intelligence Platform implementation for dashboards and reporting tools
• System and IT Platform design and implementation.
• Optimization and cost reduction due to leaks.
• Information exploited to optimize and control Leaks.
• Easy and automate Leak Management
• A full integrated system of spatial visualization, events & alarms management, analysis and reporting
Telvent Gobal Services, has launched a laboratory project with Repsol to determine the way to implant de SAP IS-Retail solution and integrate it with Repsol IT legacy infraestructure.The scope of the project covers from TPVs Petrol Stations communication with HQ and real time inventory updating.
BackgroundRepsol has more than 3.000 petrol stations across Europe selling petrol and consumer goods. More than one million customers per year refuel and buy goods at Repsol petrol stations.Service Description
Value AddedReduce logistic costs by around 30%Improvements in stocks rotation management supported by real time stock management.Simplification in architecture integration model between central IT and petrol stations IT: estimates savings in IT maintenance above 15%
PI BI
Enterprise SAP Portals
MIM SHOP close (WD)
Sale and Operations(IX-Retail)
Master and prices (IX-Retail)
Reporting
POSLOG
POSDM
Fuel(WD)
Retail Store
Teradata
ECCEHP4
Retail Oil&Gas Sales
Stock movements
Teradata
Sales, stocks, costs
Integration reference | IT Petrol Station BackOffice Integration
Master and prices (IX-Retail)
Some of other referencesBusiness Blue Print and SAP for Utilities implementation and supporting in order to manage the Abengoa renewables power business. Design, build and deployment of its ISU core business within its SAP landscape and integration with operational on the field systems.
MCS project consists on the implementation of the management systems and technological infrastructure to cover all the business processes and support data entry, retrieval and reporting. Interface with the SCADA system in order.
Design and implementation of Metering System. Development of the Management System for Contract Management, Meter Maintenance & Billing Systems. Interface with SAP.
Full Business Process for the Green Energy compensation Payment. Integration with data from the energy market regulator, energy producers, consumers and payment systems.Includes Hardware, Software, Administrative management, Client attention and Legal advising.