enabling real-time data for mobile business intelligence webinar-final_april 2012
DESCRIPTION
Mobile BI is a hot topic these days. The popularity of mobile devices like the iPad, is enabling business people to make decisions on the road, in the warehouse or at the airport. The interest in this topic is high, yet, many organizations are still struggling with basic business intelligence issues, and are not ready to invest in mobile BI. View this webinar presentation to learn more.TRANSCRIPT
Enabling Real-time Data For Business Intelligence & Mobile BI Expert insight incorporating Oracle and SQL Server #mobileBI
April 2012
Today’s Speakers
Guest Speakers
Jen Stirrup
BI Expert & SQL Server MVP
Copper Blue Consulting
Your Moderator
Richard Thomas
Director of Technical Services
Attunity, Inc.
#mobileBI
Agenda
• Introduction
• Key trends driving high interest in mobile BI
• Key use cases for mobile BI
• Essential IT infrastructure to support BI and mobile BI
• Why look to the cloud
• Initiatives IT can deliver
• Enabling technologies
• Introducing
• Live demonstration
• Q & A
An industry expert shares her insights…
Real-time Data For BI and Mobile BI
Using Oracle and SQL Server
4
Joanne Friedman Principal Analyst
Jen Stirrup Microsoft SQL MVP
BI expert
#mobileBI
Right Data, Right Time, Right Place
Use the nuggets in your data
Take advantage of the freedom that the cloud can provide
Get your data at the right place – your location
Cloud data allows you to locate your data around the globe
#mobileBI
Key Trends driving Mobile BI
• Gartner predicts that by 2013, 33% of all BI functionality will be consumed via mobile devices
• Device technology has matured • Improved connectivity • Consumerisation of IT
#mobileBI
Key Trends Driving Mobile BI
Business Priorities Technology Priorities
Increasing Enterprises growth
Analytics and Business Intelligence
Attracting and Retaining new customer
Mobile Technologies
Reducing Enterprise Costs Cloud Computing
Collaboration
#mobileBI
Key Trends Driving Mobile BI
Capability to deliver relevant and timely data to anyone, whenever they need it, wherever they are and regardless of device
Proactive alerting, triggered distribution
Push role specific predefined reports, scheduled distribution
Pull workers specify the information, ad-hoc distribution
#mobileBI
Key Trends Driving Mobile BI
#mobileBI
Key Trends Driving Mobile BI
• External factors driving Mobile BI adoption: • Consumerisation of IT • Device maturity • User expectations and constant connectivity
• Internal drivers: • Increasing productivity • Improving data delivery • Real-time reporting and analytics
#mobileBI
Key Use Cases for Mobile BI
#mobileBI
Key Use Cases for Mobile BI
#mobileBI
Essential IT Infrastructure
• 1.8 million zetabytes – Data Deluge!
• Data will grow 44 x this decade
• Right Data, Right Time, Right Format
#mobileBI
Why look to the Cloud?
#mobileBI
Why Look To The Cloud?
#mobileBI
Summary
Key trends driving high interest in mobile BI
Key use cases for mobile BI
Mobile Business Intelligence
Essential IT infrastructure to support BI and mobile BI
Why look to the cloud?
#mobileBI
Effective strategy & implementation
to enable real-time BI and mobile BI
Real-time data integration
High performance data replication
17
Richard Thomas Director Technical
Services
#mobileBI
Agenda
• Introduction
• Key trends driving high interest in mobile BI
• Preparing IT infrastructure to support BI and mobile BI
• Why look to the cloud
• Initiatives IT can deliver
• Enabling technologies
• Introducing
• Live demonstration
• Q & A
Business drivers for real-time data
1. Timely information improves
Decision support
Business operations
Customer satisfaction
2. Deliver timely data mobile devices
3. Reduce data latency to seconds
4. Reduce impact on operational systems
5. Reduce downtime and batch windows
6. Reduce risks of failing long batch jobs
7. Reduce costs with efficient data processing
19
#mobileBI
Getting Started - Checklist
• Create business intelligence strategy
• Evaluate types of decisions being made
• Users or groups involved in decision making
• Business processes affected
• Create mobile BI strategy
• Consider decentralized and mobile workers
• Applications & devices users request (Blackberry, iPhone, iPad, Android)
• Evaluate on-premise or cloud-hosted solutions
• Use this information to determine
• How BI improves performance
• Gap analysis
• Asses current data availability to meet business needs
20
Getting Started – Checklist (Con’t)
• Evaluate IT requirements to enable real-time BI
• Ensure main IT infrastructure is in good shape
• Data warehouse, BI platform, data integration, data quality
• Identify use cases require access timely data
• Priority for BI prior to moving to mobile BI
• Evaluate IT’s ability to handle ‘Big Data’ challenges – 3 V’s
• Run a small test pilot testing mobile BI applications
• Reporting & dashboards
• Field worker reports
• BI content mobilization
21
#mobileBI
About Attunity
20 years of R&D and experience with data integration
Leading independent provider of CDC and Data Replication
Thousands of customers worldwide
Technology of choice for Oracle, Microsoft, IBM and others
22
High-Performance Information Availability Solutions. Made Radically Simple.
#mobileBI
Technology and Partner of Choice
License Attunity Connect High speed ETL connectors
and Attunity Stream Attunity CDC for SSIS
OEM Attunity Connect SOA for mainframe tuxedo
OEM Attunity Stream CDC
OEM Attunity Connect Connectivity for archiving
OEM Attunity Connect NonStop connectivity
Connectivity partner Platform connectivity
For OpenVMS and HP NonStop
Sales, Marketing and Referral
Partners
#mobileBI
An Emerging Worldwide Standard
Need – Real Time Information
Real-time access to real-time
information
The age of “instant”
Going mobile
Competitive pressures
Business needs access to data, anytime, anywhere
Google search is sub-second Faster and better decisions, operations, and customer service
#mobileBI
Big Data Challenges
26
Volume
Variety
Velocity
$
$
$
Attunity Information Availability Products
27
Data Integration Applications & Infrastructure
Data Replication
File Replication
Data Access
Information Availability Office workers, decentralized and mobile
Production Database
BI / Analytics Server
Data Warehouse
28
Users
Attunity Replicate
29
High-performance data replication software for
heterogeneous systems in data centers & in the cloud
Simplicity and Power
Click-2-Replicate design
Zero footprint technology
Lowest total cost of ownership
#mobileBI
Complete Data Replication
30
Automates all three aspects of database replication:
1. Schema and DDL Replication
Generate and update target database based on the source db
2. Snapshot Replication (Full Load)
With fast extract and load technology
3. Delta Replication (Incremental Load)
Transactional, low impact with log-based CDC
#mobileBI
Quickest Time to Value
31
1 Select a source
2 Select a target
3 Click-2-Replicate
#mobileBI
32
1. Select a source
33
2. Select a target
34
3. Click-2-Replicate
Zero Footprint Technology
35
Zero Footprint: No replication software installed on
source or target database servers
Reduce impact on the server
Reduce impact on IT (support, upgrades, maintenance)
Reduce total cost of ownership
Available for the mainstream relational databases:
Oracle
SQL Server
DB2 for LUW
Architecture for Oracle, SQL Server, DB2 LUW
36
High Performance, Scalable
High Throughput
Multi-threaded, Multi-task, Multi-server
High speed extraction and load
Low Latency
Transactional streaming of changes
Second to sub-second
Low Impact
No install on source (Oracle, SQL, DB2) and target
Log-based CDC
37
#mobileBI
Configurable and Manageable
Filtering
Table Selection, Column Selection, Row-based Filtering
Pattern-based Filtering (for tables and records)
Mapping/Transformation
Column transformation
Calculated columns
Monitoring and Control
Management dashboard/console with metrics and alerts
Support for system management tools
38
#mobileBI
Web-based Design
39
40
Dashboards
Summary Key points
#mobileBI
42
Agenda
• Introduction
• Key trends driving high interest in mobile BI
• Preparing IT infrastructure to support BI and mobile BI
• Why look to the cloud
• Initiatives IT can deliver
• Enabling technologies
• Introducing
• Live demonstration
• Q & A
43
Demo
Agenda
• Introduction
• Key trends driving high interest in mobile BI
• Preparing IT infrastructure to support BI and mobile BI
• Why look to the cloud
• Initiatives IT can deliver
• Enabling technologies
• Introducing
• Live demonstration
• Q & A
For More Information
Get a FREE 30-day evaluation: Attunity Replicate at www.Attunity.com
Contact Attunity
Phone and email
For US & Canada: 1 781-730-4070
For United Kingdom: +44(0) 1344 742 805
Email: [email protected]
Join the discussion: Blog.Attunity.com
Stay abreast of the latest news!
Attunity Community: www.LinkedIn.com
Twitter: twitter.com/#!/attunity
Facebook: www.facebook.com/attunity
Contact Jen Stirrup, Copper Blue Consulting
Follow Jen’s social media groups for the latest news!
Twitter: twitter.com/jenstirrup
LinkedIn: www.linkedin.com/in/jenstirrup
Email: [email protected]
45
Thank You
www.attunity.com
blog.attunity.com
Follow us at: