NYSE turns to data warehousing in BI consolidation

NYSE Euronext, which operates the New York Stock Exchange, Euronext and other stock markets, is accelerating its business intelligence systems consolidation.

Share

NYSE Euronext, which operates the New York Stock Exchange, Euronext and other stock markets, is accelerating its business intelligence systems consolidation.

It will use data warehousing appliances from Greenplum and Netezza, said Steven Hirsch, senior VP. Those appliances from Greenplum and Netezza have significantly accelerated analysis of the company's internal business and performance data, he said.

The New York-based stock exchange operator's previous BI infrastructure consisted of Oracle data warehouses paired with BI servers running analysis software from SAS Institute, Hirsch said. Having separate servers for data warehousing and BI "doesn't work when you are processing terabytes of data per day", he added. He declined to disclose the cost of the appliances.

The "long process of consolidating" the multiple BI tools used at NYSE Euronext, created in 2007 with the merger of NYSE Group and Euronext NV, is continuing, Hirsch said. "From SAS to Business Objects to Brio, we've got pretty much everything that's been released in the last five to 10 years," he noted.

A year ago, it emerged that NYSE Euronext would be slower to deliver IT-driven revenue synergies arising from the merger of NYSE and Euronext than the group originally forecast, partly down to the group’s decision to bring its European trading platforms back in-house.

The need to consolidate BI tools is widespread, according to the results of a Forrester Research survey of 82 CIOs and IT managers that was released late last month. More than 40 percent of respondents said that their firms are using three to five different BI analysis and reporting tools. More than one out of five are running six or more tools, the survey found.

Hirsch said that NYSE Euronext has been using the Greenplum 4500 appliance for about nine months to store and analyse data that can help managers determine the causes of slowdowns during the process of taking, executing and acknowledging trades for stocks, bonds and other securities.

The Netezza appliances have been used a bit longer to track and audit trades and orders, Hirsch said. Both vendors' appliances have so far kept up with the "pretty sophisticated types of analytics" required by stock exchanges, he added.

Hirsch said he also evaluated appliances from Datallegro (now part of Microsoft), ParAccel, Aster Data Systems and Teradata.

Promoted