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.”
Chief IT Architect, Southwest Power Pool
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 must adhere to rigorous reporting requirements of FERC/ NERC industry regulations.
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 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.