1 / 31

Enterprise ETL: Webinar Findings from The Forrester Wave™

Discover the latest trends in enterprise ETL, including real-time data management, cloud integration, and big data. Get insights from The Forrester Wave™ report.

rpurser
Download Presentation

Enterprise ETL: Webinar Findings from The Forrester Wave™

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. WebinarFindings From The Forrester Wave™: Enterprise ETL, Q1 2012 Noel Yuhanna, Principal Analyst May 29, 2012. Call in at 12:55 p.m. Eastern time @nyuhanna

  2. Agenda

  3. Enterprise ETL is expanding to focus on supporting new and emerging data management initiatives Real-time DW App retirement Data virtualization ETL/DI Cloud integration Social media Big data Data migrations MDM

  4. Data integration maturity remains high “How would you rate your organization’s current level of data integration maturity(ETL/batch data movement)?” Base: 173 professionals whose organizations have purchased ETL software(percentages do not total 100 because of rounding) Source: October 2011 Global ETL Online Survey

  5. ETL is mostly used for batch use cases, but real-time integration is becoming more popular “What are you currently using your ETL tool to support?” (Select all that apply) Base: 173 professionals whose organizations have purchased ETL software (multiple responses accepted) Source: October 2011 Global ETL Online Survey

  6. ETL is broadly adopted throughout most organizations “How broad is the adoption of this solution?” Base: 173 professionals whose organizations have purchased ETL software Source: October 2011 Global ETL Online Survey

  7. Data profiling, metadata management, and data quality management are the most common add-ons to ETL solutions “Have you purchased any complementary data management solutions through your ETL vendor?” (Select all that apply) Base: 173 professionals whose organizations have purchased ETL software (multiple responses accepted) Source: October 2011 Global ETL Online Survey

  8. Most ETL implementations are more than two years old “How long have you employed the vendor’s solution?” Base: 173 professionals whose organizations have purchased ETL software Source: October 2011 Global ETL Online Survey

  9. Most ETL vendors provide positive customer experiences “Please agree or disagree with the following statements: My vendor(’s) . . . ”(percentage answering “Strongly agree” or “Agree”) Base: 173 professionals whose organizations have purchased ETL software (multiple responses accepted) Source: October 2011 Global ETL Online Survey

  10. Most enterprises like their ETL solution! Base: 197 professionals whose organizations have purchased ETL software(percentages do n Source: October 2011 Global ETL Online Survey

  11. What it means • Most organizations have built strong data integration competencies with broad adoption across the enterprise. • More organizations require data to be transferred in real time in addition to traditional scheduled batch transfers. • Most organizations like their current ETL product. • Vendor consolidation of data quality management, data profiling, and metadata management into ETL platforms is justified by customer adoption of these complementary capabilities.

  12. Agenda

  13. Overall fit with business requirement Scalability Vendor stability Low TCO Fast deployment What are the most important, nonfunctional criteria when choosing an ETL solution?

  14. What are the most important, functional criteria when choosing an ETL solution? Performance and scalability Database and platform support Source/target connectivity High availability User-friendly development and UI

  15. Large software vendors that offer broad data management coverage: Ab Initio, IBM, Informatica, Microsoft, Oracle, SAP, and SAS Specialized, pure-play vendors that offer greater automation and lower cost: iWay Software, Pervasive Software, Pentaho, Talend, and Syncsort Service providers that offer support for data integration/ETL: Accenture, Bearing Point, CSC, Deloitte, EDS, IBM GS, SAP, TCS, and Wipro The ETL market can be segmented into three categories

  16. Vendors evaluated for the enterprise ETL Forrester Wave Source: February 27, 2012, “The Forrester Wave™: Enterprise ETL, Q1 2012” Forrester report

  17. The Forrester Wave™: Enterprise ETL, Q1 2012 Source: February 27, 2012, “The Forrester Wave: Enterprise ETL, Q1 2012” Forrester report

  18. The Forrester Wave™: Enterprise ETL, Q1 2012 (cont.) Source: February 27, 2012, “The Forrester Wave™: Enterprise ETL, Q1 2012” Forrester report

  19. Forrester Wave: Ab Initio

  20. Forrester Wave: IBM

  21. Forrester Wave: Informatica

  22. Forrester Wave: iWay Software (Information Builders)

  23. Forrester Wave: Microsoft

  24. Forrester Wave: Oracle

  25. Forrester Wave: Pervasive Software

  26. Forrester Wave: SAP

  27. Forrester Wave: SAS Institute/DataFlux

  28. Forrester Wave: Talend

  29. Agenda

  30. Migrate custom code to packaged ETL before it’s too late! Consider consolidated ETL expertise as a shared service. Network with your peers to influence ETL vendor selection. Look at the Forrester Wave — customize the criteria/weightings to meet your requirements. Extend ETL to support new requirements — cloud, real-time BI, big data, and external data sources. ETL along with CDC/replication can enable real-time integration. ETL/DI remains a critical component of data management. Recommendations

  31. Noel Yuhanna +1 650.581.3807 nyuhanna@forrester.com Twitter: @nyuhanna www.forrester.com Thank you

More Related