Compañía de Expertos en Mercados SA (XM) operates Colombia’s National Interconnected System (SIN) electricity group and wholesale energy market. To improve its application modernization efforts, XM adopted a new reference architecture that includes Microsoft SQL Server running on Red Hat Enterprise Linux and supported by Red Hat application and integration solutions, XM has significantly improved transaction response times while reducing server resource use and maintenance time.
- Achieved 3 times faster transaction response
- Reduced resource use by 30% per server
- Reduced administrator support and maintenance time by 60%
Optimizing IT performance to support energy business
Compañía de Expertos en Mercados SA (XM) is a Colombian company in charge of operating the country’s National Interconnected System (SIN) electricity group and wholesale energy market, as well as administering international electricity transactions with Ecuador. In 2010, XM and the Columbian Stock Exchange launched Derivex, a new system for trading energy derivatives, or contracts based on underlying energy assets such as natural gas, crude oil, or electricity.
To support its electrical energy business in Colombia, XM sought a way to better manage new market trends, such as renewable energy and distributed generation, as well as related marketing management for tasks like demand generation and market integration. XM decided to migrate its core energy platform through a renovation process that includes a new application architecture and infrastructure solution.
However, the operating system and platforms supporting XM’s database management system monopolized resources and lacked visibility, leading to complaints of slow performance and delays.
“We faced issues with the previous solution, caused by a lack of optimized databases and continuous patching of SQL Server,” said Miguel Cañas, Architecture Team Leader at XM. “We needed to develop and test applications faster and wanted to enhance server performance with automation.”
Adopting an enterprise Linux solution from a proven vendor
XM sought a proven, cost-effective operating system with a transparent roadmap and experienced support. Based on energy sector case studies and compatibility with its Siemens technology, XM decided to adopt Red Hat JBoss Enterprise Application Platform (EAP) and Red Hat Fuse to support a new Microsoft SQL Server deployment on Red Hat Enterprise Linux.
Part of Red Hat Runtimes, Red Hat JBoss EAP is an open source Java™ Enterprise Edition (Java EE) application server used to deploy Java applications across IT environments, bridging front-end users and back-end databases. Red Hat Fuse is a universal integration platform that supports independent development of connected solutions across a variety of environments.
XM’s architecture team then learned about the benefits of the Linux operating system during several Red Hat events and decided to begin a pilot running SQL Server Enterprise on Red Hat Enterprise Linux, focused on analytics and reporting processes.
“Our technical team was excited to learn from Microsoft that Red Hat Enterprise Linux was compatible with SQL Server,” said Cañas. “Our main concern was how our databases would respond to the tests, because although they weren’t very large, some of them had grown organically and were not optimized as they grew. We’d also had some difficult migrations in the past.”
After a successful pilot, XM now uses its SQL Server database engine, running on Red Hat Enterprise Linux and hosted in its Microsoft Azure public cloud, to support development of database applications and microservices.