Hamburger Hamburger Hamburger

Press Release

December 10, 2014

City of Chicago Embeds Pentaho to Build Open Data Portal

City of Chicago Creates Smarter, Healthier Applications and Initiatives for Constituents Delivering Data with OpenData ETL Utility Kit

December 10, 2014, — Delivering the future of analytics Pentaho Corporation today announced that the City of Chicago has developed an OpenData ETL Utility Kit with Pentaho Data Integration, enabling the automated delivery of the city's massive, open data sets from sources like traffic congestion, crime data, water quality statistics and car permit data. This data is driving the development of initiatives and applications that make life easier, healthier and more efficient for Chicago citizens.

Chicago has built a leading open data program relying on automation to deliver updated data. While initially created to increase transparency and accountability for Chicago's government, multiple departments and developers have begun launching programs that enrich the lives of Chicago's residents. For example, developers created Rack It, an iOS app that lets people find bike racks throughout the city. The Sweep app leverages street sweeping records to notify residents when to move their cars and avoid street cleaning tickets.

"Pentaho allows us to automate the delivery of hundreds of data sets to the public, which can be used for accountability, application development, or even research," said Tom Schenk, Chief Data Officer at City of Chicago. "Pentaho Data Integration has allowed us to develop an open-source framework that can be used by the hundreds of other cities with open data portals. Their commitment to an open source innovation model has helped us grow efficiently and share our work with other governments."

The complexity and quantity of these data sets encouraged the City of Chicago to embed Pentaho Data Integration, to deliver hundreds of the city's data sets to the public. The Pentaho ETL capabilities transform and refine the data, allowing anyone, in any city, in any department, to deploy automated ETL using the Pentaho software. Other cities are being encouraged to leverage the same tools that the City of Chicago has created, so that they too can start to address societal challenges through the lens of data.

"Pentaho makes it easy and cost-effective for the City of Chicago to orchestrate the process of preparing large, diverse, blended data sets to build these next generation applications and initiatives for the city," said Donna Prlich, Vice President Product Marketing at Pentaho. "The work we're seeing from the team is transformational - this is the true power of connecting people and data."

About City of Chicago's DoIT
The City of Chicago Department of Innovation and Technology (DoIT) was introduced in 2008 to add innovation to the charter of the former Department of Business and Information Services. As the central information technology organization for the City, DoIT provides a number of technology and telecommunications services to departments, the Mayor, Aldermen, other city agencies, residents, businesses and tourists. For more information on the DoIT projects, see the links below.

Open Data ETL Utility Kit:

Open Data Portal:

About Pentaho, a Hitachi Group company
Pentaho, a Hitachi Group 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, BT, EMC, NASDAQ and Sears Holdings Corporation. For more information visit

{ "FirstName": "First Name", "LastName": "Last Name", "Email": "Business Email", "Title": "Job Title", "Company": "Company Name", "Address": "Address", "City": "City", "State":"State", "Country":"Country", "Phone": "Business Telephone", "LeadCommentsExtended": "Additional Information(optional)", "LblCustomField1": "What solution area are you wanting to discuss?", "ApplicationModern": "Application Modernization", "InfrastructureModern": "Infrastructure Modernization", "Other": "Other", "DataModern": "Data Modernization", "GlobalOption": "If you select 'Yes' below, you consent to receive commercial communications by email in relation to Hitachi Vantara's products and services.", "GlobalOptionYes": "Yes", "GlobalOptionNo": "No", "Submit": "Submit", "EmailError": "Must be valid email.", "RequiredFieldError": "This field is required." }