Database Data Integration - Overview and Strategy - PowerPoint PPT Presentation

Loading...

PPT – Database Data Integration - Overview and Strategy PowerPoint presentation | free to download - id: 6f594d-MWI0M



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Database Data Integration - Overview and Strategy

Description:

Title: Database Data Integration - Overview and Strategy Subject: Information Integration Author: Jean-Pierre Dijcks Keywords: Data Integration, Data Quality, OWB – PowerPoint PPT presentation

Number of Views:125
Avg rating:3.0/5.0
Slides: 27
Provided by: JeanP76
Learn more at: http://www.oracledwh.de
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Database Data Integration - Overview and Strategy


1
(No Transcript)
2
Database Data Integration Overview and
StrategyJean-Pierre Dijcks
Oracle Proprietary and Confidential DO NOT
DISTRIBUTE
3
Agenda
  • Joint positioning
  • Roadmap
  • Current status
  • Strategy Validation

4
Joint Positioning
5
Important Messages for Customers Do not undercut
each other!
  • Do not introduce doubt into customers mind
  • This is bad for Oracle
  • This is bad for your customers
  • No matter which product the customer chooses,
    their investment in Oracle solutions is SAFE
  • Both products are supported for many years to
    come
  • Oracle invests in both products
  • Oracle currently delivers two products in the
    data integration market with converging roadmaps
  • Both products are developed in cooperation, not
    in competition

6
General Positioning What should I offer?
  • If the main database platform in the deal is
    Oracle then you should exclusively offer OWB.
  • For competitive advantage position the tool which
    strengthens your overall business case keep the
    tool roadmap in mind!
  • There will sometimes be gray areas this is
    expected use your judgement about the
    customers real long-term needs

7
Roadmap
8
Strategic DirectionInformation Integration for
the Agile Business
From
To
9
ConvergencePervasive information management
services
Goal Achieved by
Create one pervasive data management service for database users One Repository One User Interface One Install with the database Embed the repository in the Oracle database Leverage Oracles IDE Create a single tool for all database development and design with one repository Install all required components at database install time
?
?
10
Transform and DeliverTransform any data and
deliver through data services
Batch ETL / ELT
Goal Achieved by
Deliver data through SOA to the right users at the right time in a heterogeneous environment Enable heterogeneous data transformations and processes for an SOA architecture Full spectrum of data integration patterns Allow publishing of any process to a web service Support deployment of web services on non-Oracle platforms ETL/ELT Data Federation (EII) Data Replication Message based integration (EAI) Change Data Capture
11.2
?
11
AccessHeterogeneous data integration
Goal Achieved by
Deliver heterogeneous information integration to Oracle database customers High performance native read and write to and from any platform Heterogeneous Change Data Capture Generate and maintain BI tool metadata on any platform Native data access using Knowledge Modules (KM) Allow creation / import / maintenance of KMs Data virtualization using Database Gateways Native change data capture using KMs Partnerships (Golden Gate, Attunity, DataDirect) Derive and maintain Oracle BI EE metadata from any data object in OWB Exchange metadata with any BI tool Deliver attribute level lineage and impact analysis from source to report with any BI tool
11.2
11.2
11.2
12
GovernanceActive data quality in the database
tier
Goal Achieved by
Make data quality smart and apply it to specific applications via the database tier Active data quality Applied data quality Smart data quality Integrated data quality Active auditing and monitoring solutions Data quality fire walls Deliver pre-built content for specific domains Verticals (Retail, banking, telco etc.) Horizontals (MDM for customer, product etc.) Self learning data quality engine Auto-tuning of algorithms and algorithm extensibility Leverage Oracle Data Mining for data quality Deterministic and probabilistic algorithms Single repository for DQ, ETL and data modeling Auto-generate data corrections Validate data rules
?
?
13
Enterprise Information ManagementComprehensive
Development/Integration Platform for Oracle
Database
Unified Database Development IDE
Mission Critical Applications
Packaged Applications
Master Data Management
Business Intelligence
Content Management
Rel. Data Modeler
Dim. Data Modeler
SQL Worksheet
PL/SQL Debugger
Data Movement
Data Governance
Data Warehousing
Data Migration
Data Flow Designer
Proc Flow Designer
Data Profiler
Data Auditor
SOA Deployment in Heterogeneous Environments
Dependency Analyzer
Metadata Browser
Integration Service Foundation
Data Integration
Data Quality and Profiling
Database Core Services
Consolidation (ETL)
Change data capture
Data Profiling
Data Auditing
Data Dictionary
PL/SQL
Federation (Gateway)
Archive/Restore (ILM)
Matching/Merging
Data Rules
SQL Engine
OLAP Engine
Replication (Streams)
Real time
Standardization
Intelligent Clustering
Data Mining
RAC / Grid
Unified Metadata
Extensible
Common Models
Lineage/Impact
Metadata Exchange
Change Management
Data Connectivity
Relational Databases
Non-Relational DBs
Various File Formats
XML Data
Packaged Applications
Standard Msg Formats
Message Queues
Semi-Structured Data
Oracle or 3rd Party Applications
Analytics Identity SOA Platforms Data
Grid Content Management Search
13
13
14
Current status
15
Database as Integration Platform
  • Best-of-breed Data Integration
  • Comprehensive Complete integration and data
    quality solution
  • Integrated One install, one user interface, one
    repository
  • Competitive Extreme scalability, best-in-class
    security, best-of-breed functionality
  • Integrated with Oracle Database 11g
  • With every Oracle Database install
  • With every Oracle Optimized Warehouse
  • With Oracle Real Application Clusters
  • With Oracle OLAP and Oracle Data Mining
  • With Oracle XML DB and Oracle Spatial
  • With Oracle Database Gateways
  • Pre-Integrated with Middleware Applications
  • With Oracle BI including BI Standard Edition, BI
    Standard Edition One and BI Enterprise Edition
  • With Oracle Master Data Management (UCM, CDH,
    PIM)
  • With Oracle PeopleSoft and Oracle Siebel
  • With Oracle E-Business suite including Spend
    Analyzer, Balanced Score Card, Fusion Migration
    etc.
  • With Oracle Data Integrator

15
16
Release Roadmap
  • Oracle 11g
  • Convergent integrated data quality / ETL /
    metadata
  • Pervasive integrated with every database
    install
  • Oracle 11g Release 2
  • Access high-performance heterogeneous read and
    write
  • Deliver full web service enablement

17
Oracle 11gConvergent and Pervasive
OWB 11g Features Benefits
OWB 11g Delivers OWB integrated in Database Install One repository for Oracle Database Out-of-the-box data integration service Applied data quality for Oracle MDM Data Profiling and Data rules Full featured DP component Detect, define and validate data rules Quality aware ETL (match/merge etc) Fully generate correction logic from rules Data Modeling Declarative rich object metadata Data model aware ETL Schema correction based on profiling SDK and Experts for automating and embedding OWB Single unified install delivers a complete environment for Oracle customers Secure metadata store with maximum flexibility Pre-packaged data governance for a better MDM solution Convergence delivers better information to end users Convergence increases developer productivity Convergence simplifies ETL Simplified ETL reduces errors Convergence increases developer productivity Highest productivity Simple to embed in any application
OWB 11g Major New Certifications Oracle 11g DB Oracle 11g Gateways Siebel CRM Connector Best for Oracle Better connectivity to non-Oracle and enhanced federation Best for Siebel Integration
18
Oracle 11g Release 2Access and Deliver
OWB 11g R2 Features Benefits
Projects Full heterogeneous support, incorporate all ODI functionality into OWB Import, create and manage all KMs Import ODI Interfaces OC4J agent infrastructure Heterogeneous web service support Combine best optimized for Oracle with Native heterogeneous capabilities Out-of-box integration with Oracle BI Industry leading heterogeneous data access High performance Leverage existing ODI components already developed Full SOA enablement across platforms Best for both worlds Easiest to maintain metadata End-to-end metadata and change propagation (source to report)
Integration Change to Oracle Fusion Client Platform Componentization of architecture Single user interface across Oracle tools Share components across products to reduce developer cost
19
DatabaseCreating, loading and maintaining Oracle
OLAP structures
  • Full design support for complex OLAP objects
  • Life-cycle support for managing OLAPobjects
  • Transparent loading of OLAP using standard OWB
    constructs
  • Flexibility in loading strategies (incremental /
    replace)
  • End-to-end lineage

Data Sources
Reporting capabilities for Oracle OLAP
Siebel CRM
Oracle OLAP
Oracle EBS
Load Data
Load and Build
Other Sources
EnableSummaryManagement
Create ETL
SAP/R3
OWB Repository
Create Objects
PeopleSoft
Import Metadata
Relational Star
Message Queues
20
Applications Leveraging applied OWB profiling
and correction rules for MDM
Data Sources
Validation with pre-built rules
Target
Oracle Master Data Management
Siebel CRM
OWB Repository
Connector
CDH Interface
CDH Rules
Oracle EBS
Connector
MDM Base Tables
PIM Rules
Corrected and validated data ready for MDM master
SAP/R3
Connector
Connector
UCM Interface
UCMRules
PeopleSoft
Connector
Connector
Connector
Other Sources
PIM Interface
Message Queues
OWB In-Database Processing
21
Fusion ApplicationsSimplified Migration ETL
architecture
Source Database (A)
Fusion Database (B)
Staging (A)
Finalize
Source Tables
Fusion Tables
Source Tables
Custom
CDC
OWB
Redo Logs
Upgrade Mappings
Source Change Logs
Incremental Replication
Fusion Services
MDS
IDM
Security
DM
AMX
22
Fusion MiddlewareIntegrating with OBI SE/EE
Data Sources
Oracle Warehouse Builder
Oracle BI EE
Siebel CRM
Data Warehouse
Data
BI EE Server
Data
Oracle EBS
Dashboards
OBIEE Enterprise Semantic Layer (RPD)
Other Sources
ETL Data Objects Data Quality
SAP/R3
Database Repository
Distribute Metadata
PeopleSoft
Metadata
OBI SE End User Layer
Ad-Hoc Reports
Lineage Impact Change Propagation Runtime
Statistics
22
23
Fusion MiddlewareIntegrating with Oracle Data
Integrator
ODI
OWB
ODI UI
OWB UI
Design ODI Interfaces and KMs
OWB Repository
ODI Repository
Import any interface from ODI repository
Maps
Interfaces
KMs
KMs
Import any KM from ODI
J2EE Agents
Execute on any platform
Execute any ODI interface
24
Strategy Validation
25
Strategy Validation
Internal Use Only
  • gt 250,000 database customers
  • gt 10,000 OWB customers

26
(No Transcript)
About PowerShow.com