Endesa, S.A. is a leading electric utility company in Spain and the largest private electricity multinational in Latin America. The company provides services to more than 25 million customers. Founded in 1944, Endesa’s strategic priorities include streamlining assets and optimizing costs to deal with expanded regulatory requirements.
In Spain and Portugal, Endesa’s core business is the generation, distribution, and supply of electricity. This involves 100 million to 150 million back-office transactions and 4,000 to 5,000 file uploads daily to set prices, based on constantly fluctuating internal and external factors.
With Oracle GoldenGate, Oracle provided an optimal solution to upgrade and migrate two databases with different data management requirements and volumes to Oracle Database 11g Release 2, with nearly no downtime.
“We never considered opting for a supplier other than Oracle. Only Oracle GoldenGate would allow us to successfully complete the migration without negatively affecting the performance of our business-critical applications running on the database,” said Fernando Romero, business relationship manager, Endesa S.A.
“One of the key factors for opting for Oracle GoldenGate is that it allowed us to execute a data import-export and synchronization. We began exporting data from our databases of origin one week before the migration, importing it to Oracle Database 11g databases and replicating it. During that week we reviewed the replication process to ensure the information was correctly applied in the destination database. This gave us the peace of mind to complete the migration knowing the data was correctly replicated and that the process could be interrupted, if necessary, without affecting users,” said Adam Escudero, solution manager, Endesa.
Oracle Advanced Customer Support Services helped Endesa identify the must-haves for the migration. It also worked with Endesa’s database administrator to understand and choose the best Oracle GoldenGate option. Oracle Advanced Customer Support Services actively participated in preproduction tests, development, and implementation, and proactively addressed challenges to ensure a successful implementation.