1 / 26

Database Data Integration Overview and Strategy Jean-Pierre Dijcks

Database Data Integration Overview and Strategy Jean-Pierre Dijcks. Oracle Proprietary and Confidential – DO NOT DISTRIBUTE. Agenda. Joint positioning Roadmap Current status Strategy Validation. Joint Positioning. Important Messages for Customers Do not undercut each other!.

cecilia-silva
Download Presentation

Database Data Integration Overview and Strategy Jean-Pierre Dijcks

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. Database Data Integration Overview and StrategyJean-Pierre Dijcks Oracle Proprietary and Confidential – DO NOT DISTRIBUTE

  2. Agenda • Joint positioning • Roadmap • Current status • Strategy Validation

  3. Joint Positioning

  4. Important Messages for CustomersDo not undercut each other! • Do not introduce doubt into customer’s 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

  5. General PositioningWhat 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 customer’s real long-term needs

  6. Roadmap

  7. Pervasive Service Standalone Tool Right Time Delivery Batch ETL / ELT Heterogeneous Oracle Centric Passive Data Quality Active Data Quality Strategic DirectionInformation Integration for the Agile Business From To

  8. Pervasive Service Standalone Tool ConvergencePervasive information management services  

  9. Right Time Delivery Batch ETL / ELT Transform and DeliverTransform any data and deliver through data services Batch ETL / ELT 11.2 

  10. Heterogeneous Oracle Centric AccessHeterogeneous data integration 11.2 11.2 11.2

  11. Passive Data Quality Active Data Quality GovernanceActive data quality in the database tier  

  12. 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 Transformation Service Data Quality Service Metadata Service Integration Service Foundation Data Integration Data Quality and Profiling Database Core Services Change data capture Consolidation (ETL) Data Profiling Data Auditing Data Dictionary PL/SQL Archive/Restore (ILM) Federation (Gateway) Matching/Merging Data Rules SQL Engine OLAP Engine Real time Replication (Streams) Standardization Intelligent Clustering Data Mining RAC / Grid Unified Metadata Lineage/Impact Extensible Common Models 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

  13. Current status

  14. 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 With Oracle Fusion Middleware including BPEL PM 15

  15. 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

  16. Oracle 11gConvergent and Pervasive

  17. Oracle 11g Release 2Access and Deliver

  18. Data Transformations using OWB ETL 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 and Build Load Data Other Sources EnableSummaryManagement Create ETL SAP/R3 OWB Repository Create Objects PeopleSoft Import Metadata Relational Star Message Queues

  19. Correct Data Validate Rules 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 Connector SAP/R3 Connector UCM Interface UCMRules Connector PeopleSoft Connector Connector Other Sources PIM Interface Message Queues OWB In-Database Processing

  20. Fusion ApplicationsSimplified Migration ETL architecture Source Database (A) Fusion Database (B) Finalize Staging (A’) Source Tables Source Tables Custom Fusion Tables CDC OWB Redo Logs Source Change Logs Upgrade Mappings Incremental Replication Fusion Services MDS IDM Security DM AMX

  21. 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

  22. Verify ODI KM Apply KM to Map Deploy map to J2EE Start map Verify interface Add OWB Xforms Deploy map to J2EE Start map 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

  23. Strategy Validation

  24. > 250,000 database customers > 10,000 OWB customers Strategy Validation Internal Use Only

More Related