oracle data integrator 12c - getting started
Post on 11-Apr-2017
210 Views
Preview:
TRANSCRIPT
OracleDataIntegrator12c:GettingStarted
MichaelRainey|BIWASummit2017
• MichaelRainey-TechnicalAdvisor• SpreadingthegoodwordaboutGluentproductswiththeworld
• OracleDataIntegrationexpertise
• OracleACEDirector
• mRainey.co
2
Introduction
we liberate enterprise data
Why“GettingStarted”
4
Manyconferencepresentationsgettootechnical,toofast
WhatisODI?
• E-LT(Extract,Load,Transform)vsETL• Heterogeneoussourcesandtargets• Builttointegratealldata
• Flexibility• Reusablecodetemplates(KnowledgeModules)
• OpenAPI
• ODIcanadapttoyourdatawarehouse-andnottheotherwayaround
• Flowbasedmappings
6
WhatisODI?
7
WheredidODIcomefrom?
Early2000s:Sunopsisformed
2006:OracleacquiresSunopsis.
2010:OracleDataIntegrator11greleased.Oracle’sfirstrealupdatetoODI.
Late2013:OracleDataIntegrator12creleased,combiningODIandOWBfeatures.
2012:ODIforBigDatafirstreleased
8
ODI12cArchitectureandComponents
*imagesource:https://docs.oracle.com/middleware/1221/odi/concepts/img/architecture.png
InstallationandConfiguration
• Knowthedifferenttypesofinstalls• Standard-usedforStandaloneAgentoronclientmachine(ODIStudioonly)
• Enterprise-JEEAgentorColocatedAgent,ODIConsole,FMCplugin
10
Chooseyourinstallationtypewisely
11
Configurationishalfthebattle
CONFIGURATION
• ODI_HOME/odi/studio/odi.sh|exe• Connecttoexistingrepository• Ifnoneexists,runRCUfirst
• Boom,you’rein!
12
ODIStudioConfiguration
• ODI_HOME/oracle_common/common/bin/config.sh|exe• RuntheWebLogicServerconfigurationwizard
• StandaloneAgent• CreatedomainoutsideofODIOracleHome
• JEEAgent• Addcredentialsmapping
• Create/configureadminserver,nodemanager,topology,etc.
13
Standalone/JEEAgentConfiguration
GettingStarted
• DataServer• Connectiontothedatasource
• PhysicalSchema• Databaseschema
• Workschema
• LogicalSchema• Abstractsthephysicalconnection/schemafromthelogical
• DevelopmentoccursagainsttheLogicalSchema
• Model• MetadataobjecttiedtoLogicalSchema
• Representsdatabaseschema,filedirectory,XMLdocument,etc
• Datastore• Logicalrepresentationoftable,file,XMLelement,etc.
15
Topology,Contexts,Models,andDatastores-Ohmy!
Alloftheseobjectsmustbecreatedandsetuppriortoanymappingdevelopmentcanoccur.
• There’sanotherwaytogetstarted-quickly!• NewModelandTopologyObjectswizard-ODI12.1.3• InODI11g,theODIQuickStartwasa10stepchecklist,whereeachstepledtoanothersectioninthedocumentation
16
Developer’sQuickstart
Mappings
18
Mappings-LogicalDatastorecomponent
Joincomponent
Splitoutputtomultipletargettables
MappingsarebuiltfromdatastoreandcomponentstologicallyformtheETL
19
Mappings-Physical
Physicalimplementationsofthemappingsarerepresentedbasedonlocationofthedatastore.KnowledgeModulesareselectedtogeneratethecode.
20
KnowledgeModules-Thesecretsauce
*imagesource:FusionMiddlewareDevelopingKnowledgeModuleswithOracleDataIntegrator
20
KnowledgeModules-Thesecretsauce
*imagesource:FusionMiddlewareDevelopingKnowledgeModuleswithOracleDataIntegrator
20
KnowledgeModules-Thesecretsauce
*imagesource:FusionMiddlewareDevelopingKnowledgeModuleswithOracleDataIntegrator
OrchestrationPackagesandLoadPlans
• It’stimeforarefresheronOracleDataIntegrator• OracleDataIntegratoris…• anE-LT/dataintegrationtool
• builttointegratealldata• flexible.ODIcanadapttoyourdatawarehouse-andnottheotherwayaround
• Chooseyourinstallationwiselyandunderstandconfigurationismoreinvolved
• ManyobjectsmustbecreatedpriortoMappingdevelopment• UsetheDeveloper’sQuickstart!
• Moreinfo:mRainey.co/odi12c-getting-started
22
Recap
23
we liberate enterprise data
thank you!
top related