introduction to data virtualization (session 1 from packed lunch webinar series)
TRANSCRIPT
© 2013 Denodo Technologies
6 Sessions Covering Key Data Integration Challenges Solved with Data Virtualization
Session 1: Data Virtualization: An Introduction
Topics covered: *Making BI agile
*Integrating Big Data *Combining SOA and Data
Integration *Enhancing and Extending MDM
and DW *Creating a single view of your
customer
© 2013 Denodo Technologies
Today’s Speakers
■ Paul Moxon Senior Director, Product Management
■ Tom Forman Senior Solutions Consultant
© 2013 Denodo Technologies
Agenda
■ What is Data Virtualization and why is it important
■ How Data Virtualization enhances existing data
architectures
■ Demonstration of Data Virtualization capabilities
■ Summary
■ Q&A and Next Steps
© 2013 Denodo Technologies
Agenda
■ What is Data Virtualization and why is it important
■ How Data Virtualization enhances existing data
architectures
■ Demonstration of Data Virtualization capabilities
■ Summary
■ Q&A and Next Steps
© 2013 Denodo Technologies
Enterprise Data Challenges Getting Bigger
Inventory System (MS SQL Server)
Log files (.txt/.log files)
CRM (MySQL)
Billing System (Web Service - Rest)
Big Data, Cloud (Hadoop, Web)
Product Catalog (Web Service -SOAP)
Customer Voice (Internet, Unstruc)
Product Data (CSV)
Exponential Data Growth
Data Silos
IT Complexity,
Rigidity
Inherent Latency
Move to Cloud
Unstructured & Web
High Costs
Agile BI, big data, cloud, real-time, unstructured… these are some of the trends driving need for a new data approach to complement existing ones
© 2013 Denodo Technologies
What is Data Virtualization?
Data Virtualization combines disparate data sources into a single “virtual” data layer that provides unified access and integrated data services to consuming applications in real-time (right-time)
BASE VIEW
BASE VIEW
BASE VIEW
DERIVED VIEW
Connect &
Virtualize
Combine &
Integrate
Publish as a Data Service
© 2013 Denodo Technologies
Data Virtualization – Key Tenets
■ Realize Value from all Data • Universal data access across internal, external, web,
structured or unstructured
■ Virtualization Minimizes Replication
• Flexible integration options with fine control – virtual real-time, cached or scheduled batch
■ Abstracted and Unified Data Services
• Abstracted data delivered as reusable data services Managed access control, service levels
■ Enterprise Class – Powerful and Agile
• Performance and scalability • Data governance, lineage, management • Easily integrated into existing IT infrastructure
© 2013 Denodo Technologies
Agenda
■ What is Data Virtualization and why is it important
■ How Data Virtualization enhances existing data
architectures
■ Demonstration of Data Virtualization capabilities
■ Summary
■ Q&A and Next Steps
© 2013 Denodo Technologies
Consumers
Sources
Data Virtualization – Key architectural capabilities
■ Abstraction – decouple data complexities from the business logic
■ Logical Representation – define canonical data models for business unit and enterprise
■ Centralized Governance – common model for security and data lineage
■ Real/Right-time Data Access – data on demand, cached or scheduled batch
■ Lighter Agile Integration – reusable models are easy to transform, combine, change
■ Reduced Replication Costs –
HW, SW, governance costs of unnecessary data replication
■ Integrates with Existing Tools – leveraged through hybrid models
ETL DW DM ODS
Virtual Data Layer
© 2013 Denodo Technologies
Data Virtualization Platform Architecture
Dat
a C
onsu
mer
s Enterprise Applications, ESB Reporting, BI, Portals Mobile, Web, Users
Dat
a Vi
rtua
lizat
ion Design Tools
Optimizer
Cache
Scheduler
Monitoring
Governance
Metadata
Security
Publish Real-time (Right-time) Data Services
Combine Transform, Improve Quality, Integrate
Connect Normalized Views of Disparate Data
Denodo Platform
Library of Wrappers Web Automation Any Data or Content Read and Write
Dat
a So
urce
s
Databases & Warehouses
Enterprise Applications
Cloud / SaaS Applications
XML, Excel, Flat Files
Big Data, NoSQL
Web 2.0 Soc. Media
PDF, Docs, Index, Emails
More Structured Less Structured
Business Solutions Access Information- as-
a-Service
Denodo Platform Right Information at the Right Time
Disparate Data Any Source Any Format
Multiple Protocols, Formats
Linked Data Services Query, Search, Browse
Request/Reply, Event Driven
Secure Delivery
© 2013 Denodo Technologies
Data Virtualization Platform Architecture
Dat
a C
onsu
mer
s Enterprise Applications, ESB Reporting, BI, Portals Mobile, Web, Users
Dat
a Vi
rtua
lizat
ion Design Tools
Optimizer
Cache
Scheduler
Monitoring
Governance
Metadata
Security
Publish Real-time (Right-time) Data Services
Combine Transform, Improve Quality, Integrate
Connect Normalized Views of Disparate Data
Denodo Platform
Library of Wrappers Web Automation Any Data or Content Read and Write
Dat
a So
urce
s
Databases & Warehouses
Enterprise Applications
Cloud / SaaS Applications
XML, Excel, Flat Files
Big Data, NoSQL
Web 2.0 Soc. Media
PDF, Docs, Index, Emails
More Structured Less Structured
Business Solutions Access Information- as-
a-Service
Denodo Platform Right Information at the Right Time
Disparate Data Any Source Any Format
Multiple Protocols, Formats
Linked Data Services Query, Search, Browse
Request/Reply, Event Driven
Secure Delivery
Universal Data Access
Agile High Performance
Universal Data
Publishing
Unified Data Governance
Unified Virtual Data
Layer
© 2013 Denodo Technologies
• Real-time Reporting
• Unified Dashboards
• Virtual Logical DW/Marts
• Big Data/Predictive Analytics
• Self-Service & Mobile BI
• Customer Single View - Call Center, Portals
• Data Services for BPM
• Operational Decision Data
• Unified Desktops - Underwriting, Loans,
• Big Data for Enterprise
• Cloud/SaaS Integration
• Web Data Aggregation
• Social Media, Feedback
• Multi-structured
• Linked Data Services (IaaS)
• Unified Data Layer
• Logical Data Abstraction – Migration/Modernization
• Data Mashups
• Unified Source of Reference - Virtual MDM
Typical Data Virtualization Use Cases
• DS for Mobile Apps
Agile Business Intelligence
Unified View
Big Data, Cloud Integration Data Services
© 2013 Denodo Technologies
Data Virtualization – Customers
Agile Business Intelligence
Unified View
Big Data, Cloud Integration Data Services
© 2013 Denodo Technologies
Data Virtualization – Customer Success
Cost savings of $600,000 and 15% ROI in 3 months
to deliver secure and timely manner
information
50% improvement in productivity with 75%
reduction in-store waiting times and 87% reduction
in errors due to manual data input
Access new data sources 60% faster
with change requests met in just a few days with IT using 40% less analyst time to support.
New suite of agile reports to sales &
management in 3X the speed with 1/3rd the team size
Agile Business Intelligence
Unified View
Big Data, Cloud Integration Data Services
© 2013 Denodo Technologies
Agenda
■ What is Data Virtualization and why is it important
■ How Data Virtualization enhances existing data
architectures
■ Demonstration of Data Virtualization capabilities
■ Summary
■ Q&A and Next Steps
© 2013 Denodo Technologies
Agenda
■ What is Data Virtualization and why is it important
■ How Data Virtualization enhances existing data
architectures
■ Demonstration of Data Virtualization capabilities
■ Summary
■ Q&A and Next Steps
© 2013 Denodo Technologies
Consumers
Sources
Data Virtualization – Key architectural capabilities
■ Abstraction – decouple data complexities from the business logic
■ Logical Representation – define canonical data models for business unit and enterprise
■ Centralized Governance – common model for security and data lineage
■ Real/Right-time Data Access – data on demand, cached or scheduled batch
■ Lighter Agile Integration – reusable models are easy to transform, combine, change
■ Reduced Replication Costs –
HW, SW, governance costs of unnecessary data replication
■ Integrates with Existing Tools – leveraged through hybrid models
Virtual Data Layer
ETL DW DM ODS
© 2013 Denodo Technologies
Better Quality Information Focus on business information needs
Integrate disparate data silos
Include Web/Cloud, Big Data, unstructured
Lower Cost & Increased Agility Lower integration costs by 80%
Flexibility to Change
Real-time (Right-time) Data Services
Fast Time to Solution Projects in 4-6 weeks
ROI in <6 months
Adds new IT and Business capabilities
Data Virtualization Benefits - Summary
© 2013 Denodo Technologies
Agenda
■ What is Data Virtualization and why is it important
■ How Data Virtualization enhances existing data
architectures
■ Demonstration of Data Virtualization capabilities
■ Customer Successes
■ Q&A and Next Steps
© 2013 Denodo Technologies
Data Virtualization - Next Steps
Move forward at your own pace Whitepaper: Data Virtualization Goes Mainstream – Solving Key Data
Integration Challenges Where Traditional Technologies Fall Short http://www.denodo.com/en/resources/whitepapers/data_virtualization/index.php
Attend Packed Lunch Webinar Sessions – Covering Data Virtualization
for…
Move forward with one of our Data Virtualization experts Phone: (877) 556-2531 | Email: [email protected]
www.denodo.com
Making BI Agile
Integrating Big Data
Combining SOA and Data Integration
Enhancing and Extending MDM and DW
Creating a Single View of Your Customer
© 2013 Denodo Technologies
Next Session:
Topics covered: *Making BI agile
*Integrating Big Data *Combining SOA and Data
Integration *Enhancing and Extending MDM
and DW *Creating a single view of your
customer
Thank You!
Delivering an Agile BI Strategy with Data Virtualization Wednesday, May 14th 2014