Slide 25
Slide 25 text
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Discovery, Exploratory and
Visualization Style Analytics
• Oracle Endeca, Big Data Discovery
• Tableau, Cliq, Spotfire
• DataMeer etc
Business Intelligence, Reporting and
Dashboard Style Analytics
• Oracle BIEE, Visual Analyzer
• Cognos, SAS, MicroStrategy
• Business Objects, Actuate etc
ETL Offload
Oracle Confidential, under Non-Disclosure 25
DBMS
(on prem or cloud)
Sandbox
ETL Offload
Staging
2. ETL Offload:
– Stakeholder: Information Technology (IT)
– Core Value: Cost avoidance on DW/Marts
– Innovation: YARN/Hadoop empowers lower cost
compute and lower cost storage
– Industries: Teradata, Netezza & AbInitio customers
Supports “Model First” Style of Analytics
– Schemas required
(for working areas, sources and targets)
– Staging data requires modeled staging tables
– Data preparation required (mapping data sets)
(un/semi-structured data sets require pre-parsing)
Typical Customer Data Types / Sets
– Usually bringing in Structured Data from OLTP Apps
(Primary data is their existing Application data)
– Occasionally adding new data types to EDW schema
(Secondary data is clickstream, logs, machine data)
– Business value is usually tied to the “cost avoidance”
around escalating DW and ETL tooling costs
Data First
Analytics
Model First
Analytics
Primary Data Flow Requires
Data Integration Tools