dis developerdaydataintegration keynote oct12
TRANSCRIPT
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
1/23
Oracle Data Integration Developer DayKeynote
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
2/23
The following is intended to outline our general productdirection. It is intended for information purposes only,and may not be incorporated into any contract. It is not acommitment to deliver any material, code, orfunctionality, and should not be relied upon in makingpurchasing decisions.
2
, ,functionality described for Oracles products remains atthe sole discretion of Oracle.
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
3/23
Program Agenda
Oracles Data Integration Strategy
Data Integration Solutions Q&A
3
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
4/23
Data Integration
Key Component of Oracle Fusion Middleware
Middleware
Applications
4
Infrastructure &Management
Database
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
5/23
1. Do More with Less
2. Compete Globally 24X7
Design metadata-driven integration
Leverage skills & dictate patterns
Design metadata-driven integration
Leverage skills & dictate patterns
Ensure continuous uptime
Access data in real time
Ensure continuous uptime
Access data in real time
Business Drivers for Data IntegrationAdd Value to the Core Business Lines
5
3. Use Data for CompetitiveAdvantage
4. Automate and AdaptBusiness Processes
Ensure the quality of your data
Actively govern most valuable asset
Ensure the quality of your data
Actively govern most valuable asset
Expose data services for reuse
Orchestrate processes using SOA
Expose data services for reuse
Orchestrate processes using SOA
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
6/23
6
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
7/23
SOA
Applications
CustomReporting
PackagedApplications
BusinessIntelligence
Analytics
DataFederation
DataWarehousing
Data Marts
Data SilosData Hubs
DataMigration
DataReplication
Unifying Information in a Mixed LandscapeMaximize the Value from BI/DW, SOA, and Business Apps
7
OLTP & ODS
SystemsData
Warehouse, Data Mart
Oracle
PeopleSoft, Siebel, SAP
Custom Apps
Files
Excel
XML
Custom
SQLJava
Scripts
OLAP
High Cost ofCustom Coding
Lack of clean,consistent data
Multiple standards,disciplines
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
8/23
MDMApplications
SOAPlatforms
OracleApplications
BusinessIntelligence
ActivityMonitoring
CustomApplications
SOA Abstraction LayerService BusProcess Manager Data Services
Data Federation
Comprehensive Data Integration Solution
Comprehensive Approach to Data IntegrationComplete, Integrated, Open Solution for the Enterprise
8
Log-based CDC
Bi-directional Replication
Real-time Data
ELT/ETL
Data Transformation
Bulk Data Movement
OLTPSystem
Flat FilesData Warehouse/Data Mart
OLAP Cube Web 2.0 Web and EventServices, SOA
Storage
Data Verification
Data Profiling
Data Parsing
Data Cleansing
Data Lineage Match and Merge
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
9/23
The Right Information at the Right TimeDIS As Part of the Information Reference Architecture
Information Delivery and Action upon Consumption are pre-requisitesfor successful Information Management
trustworthy, at the right time, scalable, secure Architecture is the key
consolidate data, for security, manageability, performance and accuracy adopt a pragmatic approach to moving towards this goal
9Copyright 2008, Oracle and / or its affiliates. All rights reserved.
Source:Oracle Reference
Architecture forInformationManagement
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
10/23
Data Sources
Full range of heterogeneous data sources frominternal, trading partner and external sourcessupported
Broadest possible data scope Master Data / Customer Data Integration (CDI) Transactional data
10
Commercial-off-the-shelf (COTS) / ERP Applications Local data such as Excel spreadsheets Structured, semi-structured and unstructured data sources
Approach to extraction and Change Data Capture(CDC) varies according to source capability, capacityand compliance and access requirements
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
11/23
ETL/ELT
Where possible, database-centric ETL (ELT) is used to utilise thepower and scale of the target Oracle database to perform datatransformations (hence Extract, Load and then Transform - ELT).
Also supports intra-ETL process from Foundation to Access andPerformance Layer (e.g. to produce relational or multidimensionalembedded marts and specialised summaries/ cube MVs)
11
ELT can be deployed where appropriate bulk actions on data,utilising power of target DW. However, when complextransformations are required, record-by-record transformations willstill be required (ETL).
ETL/ELT can be batch (e.g. overnight), frequent (drip feed), or nearreal time (via CDC ODI and GoldenGate)
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
12/23
Oracles Data Integration StrategyUnique Advantage: Pervasive Data Integration
Complete Data IntegrationTechnology PlatformComplete
Heterogeneous and Optimizedfor Standalone SaleOpen
12
Integrated with OracleTechnology StackIntegrated
Strong TechnicalDifferentiationBest ofBreed
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
13/23
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
14/23
Program Agenda
Oracles Data Integration Strategy
Data Integration Solutions Q&A
14
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
15/23
Shortcuts Enterprise Data Quality Integration Smart Export and Import
Tracking Variables and Sequences Global Knowledge Modules Groovy Editor Additional New Features
Oracle Data Integrator 11.1.1.6
15
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
16/23
Oracle GoldenGate 11g Release 2 Conflict Detection and Resolution Integrated Extract Globalization
Security and Performance Extensibility Manageability and Monitoring Heterogeneity
16
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
17/23
Business ChallengesDemanding business community of partners, manufacturers,and distributers put heavy demands on data loads for BI/DWFickle consumers with unpredictable buying patterns set newrequirements for instant access of pricing and merchandisinginformation
Oracle SolutionOracle Data Integrator and Oracle
Return on InvestmentBatch windows nearly eliminated
Improved Profitability with Real-time BI/DWOverstock.com
17
GoldenGate together provided acomplete solution for integrating datain real-time for the BI/DW
Allowed for thin middle tier with E-LTTransformations ran directly on thedatabase platformSmall mini-batches throughout theday
Low-latency data provides newopportunities for real-time campaignsMarketing and merchandisingimprovements with scoring,personalization, rankingImproved Customer Service - nowranked #2 in the nation for onlineretailersUpgraded Oracle Database withoutbusiness interruption
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
18/23
Oracle Solution Zero downtime hardware and
Return on InvestmentDecreased TCO b 80% with
Business Challenges Handle growth and scale, while reducing TCO via platform
changes Improve responsiveness to business opportunities Ensure continuous availability of Air Travel Shopping Engine
(ATSE) throughout upgrades and migrations
Standardize Infrastructure to Reduce CostsSabre
18
database migration for ATSE
Offloading looker queries to a set ofreplicas with Oracle GoldenGate
Real-time data feeds to datawarehouse
offloading looker activity to lowercost replicasReduced complexity and achievedsingle view of traveler Lowered IT costs by migrating toOracle database from legacy systems
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
19/23
Lower TCO and reduce hardware Shorten implementation, and lower development costs
Cut Costs and Shorten Time to Value
Reduce Risk
Benefits of Oracle Data IntegrationCut Costs, Reduce Risk, and Achieve Operational Excellence
19
Improve your IT infrastructure without interrupting business operations Eliminate risk associated with stale or bad quality data
Make better decisions based on accurate, timely information Provide better service to customers with continuous operations
Achieve Operational Excellence
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
20/23
Follow us on:
Join the Data Integration CommunityDiscuss, Share, Learn
www.twitter.com/ OracleDi
http://blogs.oracle.com/dataintegration
www.linkedin.com Oracle Data Integration
20
Oracle Data Integration: www.oracle.com/goto/odi Oracle GoldenGate: www.oracle.com/goto/goldengate Technical information and downloads:www.oracle.com/technetwork/middleware/data-integration/
Data Integration Events: http://www.oracle.com/events
Visit to learn more:
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
21/23
21
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
22/23
The preceding is intended to outline our generalproduct direction. It is intended for informationpurposes only, and may not be incorporated into anycontract. It is not a commitment to deliver anymaterial, code, or functionality, and should not be
22
relied upon in making purchasing decisions.The development, release, and timing of anyfeatures or functionality described for Oraclesproducts remains at the sole discretion of Oracle.
-
8/13/2019 DIS DeveloperDayDataIntegration Keynote Oct12
23/23
23