ZipRealty Deploys Pentaho for ETL

Leading Real Estate Company Delivers Threefold Performance Increase and Simplified Maintenance with Pentaho Data Integration

March 21, 2007, Orlando, FL —

Pentaho Corp., creator of the world's most popular open source business intelligence (BI) suite, today announced that ZipRealty (NASDAQ: ZIPR) has deployed Pentaho Data Integration as part of a MySQL-based data warehouse that integrates information from disparate systems to provide visibility into agent performance, customer service, and marketing effectiveness.

ZipRealty, a national, full-service real estate brokerage, provides home buyers and sellers with an innovative real estate solution. By using the efficiencies of the Internet, ZipRealty has streamlined the real estate process and is able to pass significant savings on to its clients. The brokerage's licensed, local ZipAgents® in each of its markets allow home buyers and sellers to save thousands of dollars, without compromising on service.

Given the significance of ZipRealty's online presence to its core business, the company continually gathers large volumes of data through its Web site and other systems. ZipRealty recognized the opportunity to integrate that information and leverage it strategically to measure agent performance, enhance customer service, and analyze the return on investment (ROI) of ZipRealty's marketing programs.

The technical environment includes Pentaho Data Integration 2.4 feeding a MySQL-based data warehouse running on a Red Hat Enterprise Linux server. Most of the source data is extracted and integrated from operational sources based on the Oracle database. ZipRealty has used MicroStrategy since 2006 to provide information access and analysis capabilities for end-users.

Pentaho Data Integration was selected to replace a home-grown, java-based data extraction program. Since moving to Pentaho Data Integration, ZipRealty has significantly simplified ongoing ETL maintenance and realized a three-fold increase in data load performance, reducing their batch window by eight hours.

"With professional support and world-class ETL from Pentaho, we've been able to simplify our IT environment and lower our costs," said Ilya Dorfman, Director of Information Technology at ZipRealty. "We were also surprised at how much faster Pentaho Data Integration was than our prior solution."

"We're pleased to add ZipRealty as a Pentaho customer," said Lance Walter, VP of Marketing for Pentaho. "ZipRealty is a pragmatic and increasingly common example of organizations complementing proprietary BI products with professional open source technology and services."

About ZipRealty

ZipRealty is a full-service residential real estate brokerage firm. The Company uses the Internet, proprietary technology and efficient business processes to provide home buyers and sellers with high-quality service and value. Founded in 1999, the Company currently operates in 24 major metropolitan areas in 15 states and the District of Columbia. The Company's client-centric business strategy utilizes a sophisticated Web site, which enables home buyers and sellers to access comprehensive local Multiple Listing Services home listings data and other relevant information. The Company also utilizes a proprietary business management technology platform, which reduces costs and allows the Company to pass on significant financial savings to consumers. This Internet-enabled, technology-driven, employee-based model provides the Company with a distinct competitive advantage, allowing ZipRealty to consistently deliver outstanding service to clients. For more information on ZipRealty, visit or call 1-800-CALL-ZIP (1-800-225-5947).

About Pentaho, a Hitachi Data Systems company

Pentaho, a Hitachi Data Systems company, is a leading data integration and business analytics company with an enterprise-class, open source-based platform for diverse big data deployments. Pentaho’s unified data integration and analytics platform is comprehensive, completely embeddable and delivers governed data to power any analytics in any environment. Pentaho’s mission is to help organizations across multiple industries harness the value from all their data, including big data and IoT, enabling them to find new revenue streams, operate more efficiently, deliver outstanding service and minimize risk. Pentaho has over 15,000 product deployments and 1,500 commercial customers today including ABN-AMRO Clearing, EMC, Landmark Halliburton, Moody's, NASDAQ, RichRelevance, and Staples. For more information visit