Southwest Power Pool
Southwest Power Pool is a regional transmission organization that manages the bulk electrical system to ensure reliable and cost-effective energy for ~15 million customers.
“The integrated marketplace is an important milestone in the history of Southwest Power Pool, enabling the company to coordinate next-day energy generation across the region and provide greater access to reserve energy. The marketplace also improves the regional balancing of electricity supply and demand and the integration of renewable resources.”
— Srinivas Kolluru, Chief IT Architect, Southwest Power Pool
Business Need
SPP plans to save its members $100 million annually via a real-time “Integrated Marketplace” that balances regional energy supply and demand, and enables wholesale energy to be bought and sold, in both a day-ahead and real-time market.
SPP coordinates across 75+ members to improve the regional balancing of energy supply and demand and ensure reliable, cost-effective energy for 15 million consumers.
SPP must adhere to rigorous reporting requirements of FERC/ NERC industry regulations.
Challenges
SPP needed to replicate data collected by production transactional systems from 400+ source systems (including energy produced and consumed and power line data) into an analytics data source, making it available for analysis and reporting in the Integrated Marketplace.
The scale of transactional data made it prohibitive to manage in the production database because Integrated Marketplace requires optimal performance, stability and scalability to operate effectively.
Solutions & Results
The Informatica Platform and data replication functionality facilitates near real-time data replication into an analytics data source that is optimized for analysis and reporting.
The solution reduced typical analysis time from one day to 20 minutes, resulting in significant uplift in simulated scenarios for improved energy service provision.
Products & Services
Informatica PowerCenter
Accesses, integrates, and delivers any and all data quickly and cost-effectively, without hand coding.
Informatica PowerExchange
Accesses mission-critical data and delivers it throughout the enterprise wherever it’s needed, on any schedule.
Drive Insights from Streaming Data
Capture and understand critical events in real time to improve operational decision making and rapid response with Informatica data lake solutions.
Informatica Data Explorer
Finds hidden risks, pinpoints structural issues, and stops quality problems from spreading in data.
Success Stories
M.D. Anderson Cancer Center
Informatica empowered scientific and clinical collaboration at this renowned cancer center by turning data into knowledge and facilitating self-service business intelligence
Illinois State University
Illinois State University relies on Informatica to standardize data analytics that enrich students’ experiences and promote academic achievement