enterprise information services ray chase manager, eis
Post on 21-Jan-2016
214 Views
Preview:
TRANSCRIPT
Enterprise Information Services
Ray ChaseManager, EIS
EIS Vision
Provide reliable, innovative, centralized, and comprehensive decision support and business intelligence systems to ERCOT, the Market, and the PUCT.
Overview
Data Collection Data Integration Data Modeling and Analysis Data Transparency and Delivery The Future of Extracts Data Formats and Payload Size EIS System Transition
Data Collection
All Operational Source Systems feed into ODS Replication is near real-time All intra-day transactions Nearly all tables (rules)
PaperFree
Lodestarlodstar
Lodestarlodstar
Lodestarlodstar
Siebel
TCH
RSS
Lodestarlodstar
EMMSomsappdev
EMMSercot
EMMShis_user
SiebelPaperFree
TCH
ODS
TCR
Multi-source system data integration Removes fragmentation of solutions Single version of the truth Reusability
Various 2005 projects with integration 50017 – Collateral Calc 50130 – ESIID Lookup 40015 – TCR Reporting 50001 – BI Foundations
Data Integration
Business Intelligence
ODS
Lodestarlodstar
EMMSomsappdev
TCR
CollateralCalculation
Data Modeling and Analysis
Data Warehouse Marts
Business Intelligence
ODS
TCH
Siebel
CDW
Proposed
Lodestarlodstar
EMMSomsappdev
EMMSercot
EMMShis_user
ETSData Mart
PC
.xls
.xls
.xls
.xls
PC
.xls
.xls
.xls
.xls
PC
.xls
.xls
.xls
Data Modeling and Analysis
Potential External Data Source Additions
Business Intelligence
RSS ODS
CDW
PC
.xls
.xls
.xls
.xls
PC
.xls
.xls
.xls
.xls
PC
.xls
.xls
.xls
Census
Geographic
DetailedWeather
Portal Views
Data Transparency and Delivery
Single Design - Multiple Solutions Large Scale Market Participant Extraction Public Data Extraction Market Reporting Tool (2006) Web Service Delivered Data (50024 – SCR740, ESIID)
Type-1 – Scheduled Data Delivery Type-2 – Real-time Data Delivery
Business Intelligence
RSS ODS
CDW
Market
Data Extracts
Web Services
Report Tool
Portal Views
The Future of Extracts
Data Extraction will remain a vital part of information services between ERCOT and the Market for the foreseeable future
Methods of generation, formats, and delivery capabilities will evolve over time
Creating an efficient and effective environment for Transparency in generation Flexibility in format and delivery
Market
Data Extracts
Web Services
Report Tool
Database
Process
DDM
BI
MID
Report Net
MIR
MartsCSVs
Today
XSD XML XSL
Future
Data Formats and Payload Size
Working to create a highly flexible formatting capability through the use of XML
XSL may be applied to XML at any time or place Internal to ERCOT (set delivery format) External to ERCOT (based on the customer’s need)
Formats Existing extracts will remain available in CSV Future formats will be decided on, as needed, with a push to generate
as much as possible in XML Sizing
REST delivery Small, individual transactions obtained and navigated, based on domain
Batch delivery Still reviewing what size limitations we have Current opinion is to handle 50GB Based on generation demands and persistency
Operational DataStores
ReplicatedSource Systems
Source Systems
EIS Systems & Applications
ETS
Report Net
SummaryReporting
Business Intelligence Foundation
Application Replication & Security Framework
Security Foundations
Standard Views
Standard APIs
Custom Views
Custom APIs & BLAPIs
Application Administration
Data Delivery Module (DDM)
Web Service Based Data Delivery
Lodestar ODS
EMMS ODS
TCR ODS
EIS System Transition
Siebel ODS
Paperfree ODS
TCH ODS
Lodestar RSS
EMMS RSS
Lodestar
EMMS
TCR
Siebel
Paperfree
TCH
Siebel RSS
Paperfree RSS
TCH RSS
DetailedReporting
Extracts
Data Mart
Data Mart
Data Mart
Real-TimeReporting
ConformedData Warehouse
(CDw)
DataTransparency
T
D
6
D
D
6
6
66
6
6
6
D
Conclusion
Comments? Questions? Thank You!
top related