1 / 14

How I Solved My Data Integration Problem

How I Solved My Data Integration Problem. A discussion about data integration and facing challenges in your organization. Agenda. Introductions Audience survey Approaches to data integration challenges Discussion. Introductions. Peter Campbell IT Director, Earthjustice, Techcafeteria

dillon
Download Presentation

How I Solved My Data Integration Problem

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How I Solved My Data Integration Problem A discussion about data integration and facing challenges in your organization

  2. Agenda • Introductions • Audience survey • Approaches to data integration challenges • Discussion

  3. Introductions • Peter Campbell • IT Director, Earthjustice, Techcafeteria • Richard Jeong • IT Specialist, Friends Committee on National Legislation • Corey Snipes • Founder and Principal Partner, Twomile Information Services; Volunteer, Engineers Without Borders • Dahna Goldstein • Founder, PhilanTech, LLC

  4. Audience Survey • Are you currently facing a data integration challenge in your organization? • What are you here to learn?

  5. Approaches to Data Integration Challenges • Peter Campbell, Earthjustice

  6. Approaches to Data Integration Challenges • Peter Campbell, Earthjustice and Techcafeteria • Richard Jeong, Friends Committee on National Legislation

  7. Approaches to Data Integration Challenges • Peter Campbell, Earthjustice and Techcafeteria • Richard Jeong, Friends Committee on National Legislation • Corey Snipes, Engineers Without Borders

  8. The Situation • An Access database • The website • Quickbooks • Adding Salesforce

  9. The Motivation • Staff time doing duplicate data entry • Staff time answering questions • Hard to answer simple questions • Hard to understand and communicate needs

  10. The Solution • Centralized data warehouse • Business Intelligence reporting layer (Pentaho) • Web services layer to connect the systems • While we’re at it: • New project tracking system • New membership system and process

  11. Managing the Process • Initial staff buy-in was simple • Board and E.D. trusted us to make decisions • Ongoing communication • Trying to do it all at once

  12. Lessons Learned • Lots of moving parts, lots of coordination • Avoid communication and technical bottlenecks • Requires significant effort and staff time • Don’t try to do everything at once • Start small and show successes

  13. Learn More • EWB: http://www.ewb-usa.org • Me: corey@twomile.com • SOA: http://en.wikipedia.org/wiki/Service-oriented_architecture • BI: http://en.wikipedia.org/wiki/Business_intelligence • Pentaho: http://www.pentaho.com

  14. Discussion

More Related