Oracle数据集成解决方案

第1页Thefollowingisintendedtooutlineourgeneralproductdirection.Itisintended

forinformationpurposesonly,andmaynotbeincorporatedintoanycontract.

Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.第2页OracleDataIntegrationSolutions

ProductUpdate:

OracleGoldenGate

and

OracleDataIntegrator第3页ProgramAgendaMarketOverviewOracleDataIntegrationOverviewOracleDataIntegratorProductUpdateOracleGoldenGateProductUpdateMoreInformation第4页MarketOverview第5页MarketOverview

ExponentialGrowthinDataVolumes45PB+MaintainedbyLargeOrgs45%+AnnualGrowth15outof17IndustrySectorsintheU.S.HaveMoreDataThantheU.S.LibraryofCongress第6页MoreDataleadstoMoreDataChallengesMarketOverview

ExponentialGrowthinDataVolumes第7页MarketOverview

DataIntegrationandDataQualityMarketsestimatestheDImarketwillreach$2.8billionestimatestheDQmarketwillreach$1.75billionby

withanaveragegrowthrateof18.2%第8页DataQualityDataIntegrationProfilingStandardizationMatch/MergeETL/E-LTReplicationVirtualizationBigDataHeterogeneousOracleDataIntegration(DIS)BreadthEnablesLeverageandAgility第9页ModernizationMDMSOABigDataOracleDataIntegrationCompleteOfferingforEnterpriseDataIntegrationOracleDataIntegratorOLTPApplicationsLegacyUnstructuredSynchronizationCustomBICompleteandbest-of-breedapproachforenterprisedataintegrationMaximumperformancewithlowerTCO,easeofuseandreliabilityCertifiedforleadingtechnologiestodeliverfasttimetovalueOracleGoldenGateOracleEnterpriseDataQualityOracleDataServicesIntegratorOracleCustomersReport:

80%lowerTCOFivetimeshigherperformance70%reductionindevelopmentcosts第10页OracleDataIntegratorBulkDataProcessingandDataTransformationOracleDataIntegratorOLTPApplicationsLegacyUnstructuredCertifiedforleadingtechnologiestodeliverfasttimetovalueHigh-performance,lowcostofownershipE-LTarchitectureLightweightdeploymentFlexible,easytoenrichfunctionalityHighPerformanceE-LTDeclarativeDesignCEPDataServicesExtensibleKnowledgeModulesCapableofIntegratingStructured&UnstructuredData第11页UnstructuredOracleGoldenGateReal-timeDataIntegrationOracleGoldenGateOLTPApplicationsLegacyHigh-performance,low-impactreal-timedataintegrationandreplicationTimelydataforimprovedbusinessinsightContinuousavailabilityfor24/7operationsLog-basedChangeDataCaptureandDeliveryActive-ActiveReplicationReliabilityandTransactionIntegrityHeterogeneousSourceandTargetsCEPIntegration,Real-timeEvents第12页OracleDataIntegrator

ProductUpdate

第13页WhyDataIntegratorforOracle?HeterogeneousDatabasePlatformsNativeSupportforOracleandNon-OracleDatabasesFasterandSimplerArchitectureforHigh-endWarehousesE-LTArchitectureisSuperiorfastestdataloadingTransformationscanrunanywhere:Sources,Mid-TierorTargetEasily&ElegantlyEmbeddedRunsnativetoSOAandOracleApplicationstacktechnologies100%Java,JEEandJSEDeploymentModesE-LTArchitecturemeansnodatachokepointsinmid-tierFlexibleBatchorReal-TimeDataFlowsCommondesignpointandeasymigrationtorealtimedataflowsAutomaticallygeneratesDBCDCorbest-of-breedCDCwithGoldenGate第14页Uniquevalueproposition:Appsincludepre-builtintegrationcontentDramaticallylowersthecostofadding&integratinganapplicationExamples:OracleBIApplications,OracleGovernanceRisk&Compliance,ApplicationIntegrationArchitecture(AIA),manymore…BestofBreedStandalonePlatformEmbeddedTechnology&ContentOracleDataIntegration:TwoPartStrategy

第15页KeyODIInternalOEMPatternsFusionERPApplicationsBusinessProblem:ERPAppsrequire“interfacetables”forbulkloadingBasicPattern:ODIpre-builtcontentformovingfrominterfacetobasetablesUniqueAttribute:ODIembeddedintoApps,nonewETLserversFusionGRCControlsBusinessProblem:NeedtoextractERPdataintoGRCforanalysisBasicPattern:GRCjavaprogramdynamicallydrivesODIAPIsforextractsUniqueAttribute:100%dynamic,usingOWLtogenerateRDFwithODIBusinessIntelligenceAppsBusinessProblem:Needhigh-performanceextractandloadforDW/MartsBasicPattern:ODIpre-builtcontent,3-tierETLarchitectureUniqueAttribute:Size&volumeofETLcontent(~40,000maps)OracleAIABusinessProblem:DirectintegrationbetweenAppsattheDBlevelBasicPattern:ODIpre-builtcontentforsyncbetweenOLTPtablesUniqueAttribute:Built-inmetadataexchangewithBPEL,OSB&MediatorERPGRCODIERPDWODIAppAppODIERPODI第16页EngineeredTogether@Oracle

ODIIntegratedODIEmbeddedPre-builtContentODIIntegratedODIEmbeddedPre-builtContentKey:ODIIntegratedODIhasspecialtechnicalintegrationsorfeaturestosupportthenamedOracleApplication/ComponentODIEmbeddedODIisincludedwiththeOracleApplication/Componentwithaspeciallicensetype(eg:RestrictedUseetc)Pre-builtContenttheOracleApplication/Componentisdeliveredwithpre-builtETLmappings/contentthatruninODIGenerallyAvailableRoadmapAgileBusinessIntelligenceAgileDataWarehouseAgilePLMforProcessAgileDataloadOracleFinancialServicesFlexCUBEOracleFinancialServicesMantasHyperionPlanningHyperionFinancialManagementHyperionProfitabilityMgmtHyperionEssbaseHyperionEPMA/ERPIBIEEServerBIApplications(&7.9.7)BIApplications(11gPS1)SOA-BusinessActivityMonitorSOA-ComplexEventProcessorSOA-ServiceBus,Mediator&ESBSOA-BPELProcessManagerOracleGoldenGateOracleInternetDirectory&OVDOracleWebLogicJEEAppServerOracleCoherenceOracleMySQLOracleDatabaseSE&EEOracleExadataOracleExalyticsOracleBigDataApplianceE-BusinessSuite11i10andhigherzzE-BusinessSuiteFinancialsIntegrationPeopleSoft8.xandhigherSiebelCRM7.7andhigherOracleCRMOnDemandJDEdwardsEnterpriseOne8.x+JDEdwardsWorldA7.3andhigherFusionCRMFusionFinancialsFusionHumanCapitalManagementFusionSupplyChainManagementFusionApplicationMigrationsFusionGRCControlsAIA-CommsRevenueAccounting(BRM-EBS)AIA-CommsAgentBillingCare(SBLCRM–BRM)AIA-FinancialsOpsControl:OracleRetail(PSFT,EBS)AIA-OrderstoCash(SiebelCRM–EBS)AIA–SiebelFieldWorktoReal-TimeSchedulerAIA-SerializationandTracking(OPSM-EBS)AIA-ValueChainPlanningRetailApps-MerchandiseFin.PlanningRetailApps-ItemPlanning/AssortmentPlanningRetailApps-SizeProfileOptimizationRetailApps-PlanogramImporterRetailApps-MacroSpaceManagementRetailApps-RetailAnalyticsNote:Thislistisnotallinclusive第17页OracleETLRoadmap

第18页EvolvingDataIntegrationRoadmap

Oracle’sInvestmentDirectionisConstantlyReviewedandRefined

OWBOWB-EETLRoadmaptoRoadmaptoOWB-EETLODIOWB-EETLODINewETLOWB(freeDBfeatures)OWB(freeDBfeatures)OWB(freeDBfeatures)ODIOWB-EETLOWB(freeDBfeatures)KMsRoadmaptoRoadmapfromJantoCurrentKMs第19页OracleETLRoadmapSinceJanAsCommunicatedtoOWBandODICustomersWorld-WideIn-DatabaseETLFeaturesKnowledgeModulesODI-EELicenseUnified

TeamODI-EELicenseOWB-EE11gR2ODI11g

ODI12c

12.1ODI11g

JulSepJanOctLateCY13OWB-EETL

ConceptsNonewmajorfeatureenhancements.Bugfixes,patchesandDBcertificationscontinueODI11g

CY13第20页ODIReleaseThemes

ODIBigData

Jan2012Theme:

BigDataKeynewfeaturessupportingHadoopintegrationODI

Feb2012Theme:BIAppsKeynewfeaturessupportingBusinessIntelligenceapplicationsbuiltonODIETLODI

CY2013Theme:

XMLKeynewfeaturessupportingXMLhandlingfunctionalityODI12.1.2

CY2013DeveloperJumpstartProductivity&usabilityfeaturesforconventionalETLdevelopers第21页ODICoreReleaseCycle.0.0JanuaryBigDataFlexRelease.012cH1CY11H1CY12H1CY12H1CY13CY13第22页OWBSupportPoliciesReleaseGADatePremier

SupportEndsExtended

SupportEndsSustainingSupportEndsOWB9.2JulOctNotAvailableOctOWB10.1AprJulNotAvailableJulOWB10.2JulJulJulIndefiniteOWB11.1AugAugAugIndefiniteOWB11.2SepCurrentDates:

JanFutureDates:SameasDB12CurrentDates:

JanFutureDates:SameasDB12IndefiniteFormoreInformationaboutSupportLevels:/us/support/lifetime-support/index.html

CustomerDownloadableOWBSupportPolicies:/us/support/library/lifetime-support-technology-069183.pdf

第23页MustOWBCustomersMigratetoODI?ExistingOWBcustomersareNOTbeingforcedtomigratetoODIOracleisnotintendingtocreatea“forcing-function”forexistingOWBcustomerstopaymoreLicensefeesOracleoffers“LifetimeSupport”optionforSustainingSupportonallOWBfeaturesForOWBcustomerswhoareinitiatingnew‘greenfield’ETLprojects–OraclerecommendstoconsiderODIfirstForanynewcustomerswhoareinitiatingnew‘greenfield’ETLprojects–OraclerecommendstoconsiderODIfirstODIisthestrategicgo-forwardETLplatformfromOracle第24页OracleBestPracticesforTechMigrationsUnderstandthatOWBandODIaredifferentETLtoolsThereisno“freelunch”whenmigrating–atechnicalmigrationbetweendifferenttoolswillneverbe100%perfectorpredictable

Manualre-implementationmightbethebest-betOptimizingETLjobsinODIwilltypicallyyieldthebestperformingresults(vs.semi-automaticconversionutilities)Semi-automatedconversionservicesareavailableOraclePartnersoffersemi-automaticconversionutilitiesandoffshoreservicesthatmaydramaticallyaccelerateyourconversionfromOWBtotheODIproduct.Oracledoesnotguaranteeanyoftheseservices,butdoesadviseandgiveinputtothe3rdpartypartnersonthedevelopmentoftheirconversionutilities.第25页OWBtoODIComponentEquivalencyOWBETLOracleDataIntegratorAllOWBETLfeatureswouldmaptoODI

(whereapplicable,thisdoesnotmeanthatthetwoproductsarefeature-equivalent)OWBDataQualityOracleEnterpriseDataQualityforODIAllOWBDQfeatureswouldmaptoEDQforODI

(whereapplicable,thisdoesnotmeanthatthetwoproductsarefeature-equivalent)Exceptions:ODIoffersbuilt-in“CheckFlow”featuresthatsupplylightDQfunctionalityinlinetotheETL–theseareconsideredbaseETLfeaturesOWBDataProfilingOracleEnterpriseDataProfilingAllOWBDPfeatureswouldmaptoEDP

(whereapplicable,thisdoesnotmeanthatthetwoproductsarefeature-equivalent)第26页OWBFeaturesNotSupportedinODI11gOracleDataIntegratorisahighlyadvancedbest-of-breedETLproduct,butOWBhadevolvedseveralfeaturesthatwerestronglycoupledtootherOracletechnologies.Hereareourplanstofillthegaps:OracleDiscovererIntegrationWhy:ODIintegrateswithOBIEEforLineage&ImpactAnalysisFuture:deepODIintegrationwithOracleBIServerDimensionalModelingWhy:WithODI,datamodelingcomesfrombest-of-breedmodelingtoolsFuture:tightlyintegrateODIwithOracleSQLDeveloperOMBScriptingWhy:ScriptingwithODIleveragesODIJavaSDKAPIsFuture:integratedGroovyscriptingPL/SQLCodeGenerationWhy:ODIgeneratestransformationSQL(nativetowhicheverDBisrequired),noproceduralcodeisgeneratedfromODI.第27页OracleGoldenGate

ProductUpdate

第28页OverviewofNewFeaturesIntegratedCaptureEnhancedConflictDetection&ResolutionSupportforGlobalDeploymentsSecurityandPerformanceExtensibilityManageabilityandMonitoringExpandedHeterogeneity第29页IntegratedCaptureOverviewOracleGoldenGate11gR2IntegratedCaptureforOracleDatabaseMovesGoldenGate’scapturecapabilitiesclosertotheOracleDatabaseengine.Enables100%supportforcaptureanddeliveryofcompressedobjectswithinOracleDatabaseandOracleExadata第30页BringsGoldenGateCapture(Extract)closertotheRDBMSengineLeveragesProprietaryOracleDatabaseMiningAPIParallelisminminingandtransformingredorecordsintoLCRsImprovedRACcoordinationandautomatednodehandlingTighterintegrationandfasterdevelopmentofnewOraclefeaturesMultiThreadedUsesproducerthreadtocaptureREDOrecordandconsumerthreadtoprocesstheREDOrecords.PerformancegainfromparallelprocessingIntegratedCaptureOverview第31页SupportsmultipledeploymentconfigurationSource:SourcedatabaseandIntegratedCaptureprocessareinthesamemachineDownstream:SourcedatabaseandIntegratedCaptureprocessareinthedifferentmachineEasytransitionforexistingGoldenGatecustomersCustomersmaychoosewhichoptiontheypreferbasedontheirrequirements.IntegratedCaptureOverview“OnSource”“Downstream”第32页ClassicCaptureWhentoConsiderClassicCaptureIfyoudon’tneedXMLtypes,XAonRAC,compressionsetc.FutureDirectionClassicCapturewillbearoundforlongtimeCorespecificfeatures,bugfixesandpatcheswillbeavailableonbothCapturesOraclespecificfeatureswillbeonlyavailableinintegratedextract.AddingOraclespecificfeatureexclusivelytoclassicextractwillnotbepossible.

第33页EnhancedConflictDetection&Resolution(CD&R)OverviewOracleGoldenGate11gR2EnhancedConflictDetection&ResolutionAutomateddetectionandresolutionofdataconflictsforactive-activeormulti-masterdeployments.Robust,easiertocode,andlesstimetoimplement.第34页Replacesexpensivehand-codingofCD&Rruleswitheasyandexpandablerules.Optionstousepre-builtmethodstoresolveconflictsOverwrite,Ignore,Discard,UsemaxandUseminSupporteddatatypesNUMERIC,DATE,TIMESTAMP,CHAR/NCHAR,VARCHAR/NVARCHARSupportsheterogeneousdeploymentsEnhancedConflictDetection&ResolutionOverview第35页SupportforGlobalDeploymentsOverviewOracleGoldenGate11gR2GlobalDeploymentSupportAllowsOracleGoldenGatetosupportdatabasesusingmulti-byte/Unicodeobjectandcolumnnames.第36页GoldenGatedeploymentinanon-EnglishenvironmentSupportsEuropeanAccentcharacters,Multi-bytecharactersAutomaticconversionsoftransactionaldataacrossdifferentcharactersetenvironmentsNativeerrormessages,supportscasesensitivityDatabaseobjectnamesupportNonUS-ASCIICharacterSupport(bothDDL/DML)DatabaseLikeObjectLevelCaseSensitivitySupportSupportforGlobalDeploymentsOverview第37页SecurityOverviewOracleGoldenGate11gR2SecurityTheMostSecureVersionofGoldenGateOracleGoldenGate11gR2supportsFederalInformationProtectionStandard(FIPS)andBLOWFISHencryptionalgorithmstoprovidesecuredatamovementacrosssystemsandregions第38页SupportFIPScompliantencryptionalgorithminadditiontocurrentBLOWFISHalgorithmOndiskencryptionfortrailfileInpasswordencryptionWhentransferringdataacrossthenetworkNOTE:OnlysupportedonLinux,Windows,andUnix.IPv6supportMandatefromthegovernmentTheexistingGoldenGatelibraryofIPCroutinesisbasedonIPv4.AllexistingGoldenGatecallsusingIPv4APwerechangedtouseIPv6APIs.SecurityOverview第39页PerformanceOverviewOracleGoldenGate11gR2PerformanceImprovementsPerformanceimprovementsfordatareplicationacrossgeographicallyseparatedsystemsinhigh-latencynetworks第40页PerformanceOverviewofDataPumpImprovementsPriortoOracleGoldenGate11gR2SynchronousdatacommunicationbetweenDataPumpandremotecollectorprocessOracleGoldenGate11gR2AcknowledgementmessagecanbeskippedforeverydatasentRemotecollectordoesnotsendanacknowledgementtotheDataPumpunlessapacketcontainsaflagrequestingaresponse.第41页ExtensibilityOverviewOracleGoldenGate11gR2ExtensibilityUsingEventMarkersallowsGoldenGateimplementationstobeextendedtokick-offactionsbasedonanincident(DML,DDL,datavalue)第42页ExtensibilityOverviewEventMarkerSystemsEnablestheOracleGoldenGateprocessestotakeadefinedactionbasedonaneventrecordinthetransactionlogorintheTrailSupportedEventActionsTRACE,LOG,CHECKPOINTBEFORE,IGNORE,DISCARD,SHELL,ROLLOVER,REPORTABORT,CHECKPOINTAFTER,FORCESTOP,STOPRobustoptionforcustomersrequiringnon-standardprocessingbasedonspecializedevents.第43页EventMarkerSystemTargetDatabaseSourceDatabaseUser/ApplicationchangesTransactionLogsLAN/WAN/INTERNETOverTCP/IPACTIONSTRACELOGCHECKPOINTBEFOREIGNOREDISCARDROLLOVERREPORTABORTCHECKPOINTAFTERFORCESTOP/STOPSHELLwithparametersSUSPENDDDLEventrecordEventrecordEventrecord第44页Manageability&MonitoringOverviewOracleGoldenGate11gR2MonitoringThenewOracleGoldenGateMonitorproductprovidescompleteviewoftheGoldenGateimplementations.IntegrationwithOracleEnterpriseManager第45页Advancedmonitoring,alerting(SNMPsupport),laggraphs,andhistoricalrepository.Basedonnewagentinfrastructure,whichwillbethefoundationforallfutureintegrationprojects.SupportsGoldenGate.1+ManagementPackforOracleGoldenGateOracleGoldenGateMonitorMonitoring第46页OraclePreferredmonitoringtool,coversentireOraclestack–Database,Storage,FMWetcForcustomers,whopreferstodrillintoDBsessions,OSstats,etc,apartfrommonitoringGoldenGateprocessIncludedinManagementPackManagementPackforOracleGoldenGateEnterpriseManagerPlug-inMonitoring第47页ExpandedHeterogeneityOverviewOracleGoldenGate11gR2ExpandedHeterogeneityExpandeddatatypesupportforexistingsupportedplatformsAddednativelogbasedcapturefromIBMDB2oniSeriesandDeliverytoPostgreSQL第48页DescriptionPlatformExpandedHeterogeneityOverviewIBMi-series(AS/400)CapturesupportPostgreSQLDeliverysupportTeradataMultibyteDDLSQLServerCLRdatatypes,Geometry,GeospatialdatatypesSybaseComputedColumnsNewdatatypes-BIGINT,UnsignedInteger,OptimizedLOBmanagementMySQLMySQL5.5,NewDatatype–UINT64IBMz/OSPerformanceimprovementduringInitialload第49页DB2iSeriesCaptureSupportedDatatypesNumeric(BIGINT,DECIMAL,DOUBLE,FLOAT,INTEGER,NUMERIC,REAL,