implementing relational use cases with mongodb …files.meetup.com/1742411/pentaho and...

Implementing Relational Use Cases with mongoDB and Pentaho

January 16, 2013

Dave Henry ([email protected]) Dave Diegtel ([email protected])

© 2012, Pentaho. All Rights Reserved. pentaho.com. Worldwide +1 (866) 660-7555

mailto:[email protected]

mailto:[email protected]

Agenda

• Pentaho / 10Gen – Partnership Background • Pentaho for Big Data • Relational Use Cases - Pentaho & mongoDB • Pentaho for mongoDB – planned enhancements

2 © 2012, Pentaho. All Rights Reserved. pentaho.com. Worldwide +1 (866) 660-7555

About Pentaho

• “Penta “–Greek for 5. Based on Pentaho’s 5 founders, – Headquarters, Orlando, FL.. With office is San Francisco, CA. – Achieve positive, disruptive change in Data Integration and BI Markets.

• Achieved Critical Mass – 10,000 production deployments in 185 countries

• Subscription-based – Pay-as-you-go, lower upfront cost, only renew when you achieve your ROI

• Training and Consulting • Stewardship of open source analytics projects (Kettle, Mondrian, and WEKA)

– Pentaho is based on open source software and benefits from a continuous stream of innovation from the open source community. Pentaho contributes back many new capabilities and provides employment for many of the most skilled and innovative community project leaders.

3

INDUSTRY RECOGNITION OVER 160 PARTNERS GLOBALLY


Healthcare Embedded Pentaho to better patient care & compliance through analysis of unstructured digital pen data stored in CouchDB

Online Retailer Understanding the buying patterns of 5 million users from click stream data stored in Hadoop & HBase

Gaming Better monetization of premium game features through analyzing large volumes of player data - stored in MongoDB & Infobright

Social Commerce Better campaign performance through monitoring social media, page clicks and email marketing data stored in HP Vertica

Travel & Entertainment Helping thousands of travel partners like expedia.co.uk and thomascook.fr improve promotional targeting using Hbase and Hadoop

Mobile & Digital Media Embedded Pentaho to measure massive volumes of mobile and event data generated from mobile devices stored in MongoDB

Commercial Innovation


✚

Big Data Partnership

Announcement May 23, 2012 Working together, Pentaho and 10gen offer the first

mongoDB-based big data analytics solution to the market.

mongoDB is a scalable, high-performance, open source NoSQL database featuring document-oriented storage, auto-sharing for horizontal scalability, rich document-based queries and fast in-place updates.

This is leveraged by Pentaho’s visual interfaces for high-performance data input, output and manipulation, as well as data discovery, visualization and predictive analytics.

Target Audience is IT staff, developers, data scientists and

business analysts.


Using Pentaho with mongoDB

Complete business analytics – In addition to visual data loading and manipulation, Pentaho Business Analytics provides a complete end-to-end analytics suite that includes data discovery and predictive analytics.

Productivity – With Pentaho, mongoDB users

have an integrated visual environment to deploy, manage, report, visualize and explore big data. Pentaho’s visual interface enables up to a 15X productivity improvement for developing and managing big data.

Orchestration – By integrating mongoDB is woven

more tightly into the broader fabric of big data and traditional data sources.


✚

mongoDB Input

Pentaho in the Big Data Fabric

Big

Dat

a M

gmt

B

ig A

naly

tics

Hadoop

NoSQL Databases

Analytic Databases

Data Integration Job Orchestration Workflow

Pentaho Business Analytics

Scheduling High Performance Visual IDE

R 3rd Party BI Tools Applications

Dat

a In

tegr

atio

n

3rd Party Tools

Relational Use Cases – Pentaho & mongoDB

• In’s & out’s (the basics)

• Using mongoDB as the source for a data warehouse dimension (extract-transform-load)

• OLAP analysis using Pentaho Instaview (extract-transform-present)

• mongoDB as the source for a predictive analytic web service

• Planned enhancements (new mongoDB input step)


Our Questions for You

• Do you have BI use cases for mongoDB?

• Do you have SOA use cases requiring the use of 3rd-party integration tools?

• Do you have use cases requiring predictive analytics?

• Fill in the blank: “If only I could _______ with mongoDB

…”


Thank You


Join the conversation. You can find us on:

http://blog.pentaho.com @Pentaho Facebook.com/Pentaho Pentaho Business Analytics

implementing relational use cases with mongodb …files.meetup.com/1742411/pentaho and...

Documents