EDF Energy cuts mainframe data congestion with datawarehouse


EDF Energy cuts mainframe data congestion with datawarehouse

Arif Mohamed
EDF Energy, one of the UK's largest electricity suppliers, has used a datawarehouse system to solve the problem of accessing data from its IBM z900 mainframe.

EDF's problems centred around transferring essential customer data to and from the mainframe - a five-stage process which resulted in a congested network whenever files were transferred from the mainframe storage to an AIX platform. In October last year, EDF worked with mainframe data access software specialist Corigin to build an access system.

EDF had a complex IT system as a result of a number of acquisitions that included SWEB Energy and Seeboard Energy.

Rachel Smith, datawarehouse application manager at EDF Energy, said, "Our recent acquisitions almost doubled our data requirements and our infrastructure needed to be able to keep up with our changing business requirements."

The Corigin system runs on a mid-range server, extracting data from an HDS storage subsystem into an open Unix-based datawarehouse, bypassing the mainframe, said Smith. "Corigin then reads the DB2 logs to propagate the datawarehouse with data change," she said.

"The implementation of Corigin did not require any mainframe coding development, just configuration changes within the DB2 set-up." The result has provided significant time and cost savings.

For example, Corigin can transfer selected data into the Oracle database directly from DB2 in less than two hours, instead of the previous 10-plus hours, said EDF.

Another benefit is that EDF can update the datawarehouse in near real-time, quickly reflecting changes in the DB2 database on the corresponding Oracle database.

Email Alerts

Register now to receive ComputerWeekly.com IT-related news, guides and more, delivered to your inbox.
By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

COMMENTS powered by Disqus  //  Commenting policy