ZipRealty Deploys Pentaho for ETL
Leading Real Estate Company Delivers Threefold Performance Increase and Simplified Maintenance with Pentaho Data Integration
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 Pentaho Corporation
Pentaho is delivering the future of business analytics. Pentaho's open source heritage drives our continued innovation in a modern, integrated, embeddable platform built for the future of analytics, including diverse and big data requirements. Powerful business analytics are made easy with Pentaho's cost-effective suite for data access, visualization, integration, analysis and mining. For a free evaluation, download Pentaho Business Analytics at www.pentaho.com/get-started.
Pentaho Media Contact
US & Worldwide
Director of Corporate Communications