Oracle Data Integrator architecture Complete all components list
Showing posts with label ARCHITECTURE. Show all posts
Showing posts with label ARCHITECTURE. Show all posts
Tuesday, 24 June 2014
List of ODI Tools in ODI 12c
List of ODI Tools in ODI 12c
Oracle Data Integrator Tools by Category
This section lists Oracle Data Integrator tools by category.
Metadata
OdiReverseGetMetaData
OdiReverseManageShortcut
OdiReverseResetTable
OdiReverseSetMetaData
Oracle Data Integrator Objects
OdiDeleteScen
OdiExportEnvironmentInformation
OdiExportLog
OdiExportMaster
OdiExportObject
OdiExportScen
OdiExportWork
OdiGenerateAllScen
OdiImportObject
OdiImportScen
Utilities
OdiAnt
OdiBeep
OdiEnterpriseDataQuality
OdiKillAgent
OdiOSCommand
OdiPingAgent
OdiPurgeLog
OdiReinitializeSeq
OdiRemoveTemporaryObjects
OdiStartLoadPlan
OdiStartOwbJob
OdiStartScen
OdiUpdateAgentSchedule
Internet Related Tasks
OdiFtp
OdiFtpGet
OdiFtpPut
OdiInvokeWebService
OdiReadMail
OdiScpGet
OdiScpPut
OdiSftp
OdiSftpGet
OdiSftpPut
OdiSendMail
Files
OdiFileAppend
OdiFileCopy
OdiFileDelete
OdiFileMove
OdiFileWait
OdiMkDir
OdiOutFile
OdiSqlUnload
OdiUnZip
OdiZip
SAP
OdiSAPALEClient and OdiSAPALEClient3
OdiSAPALEServer and OdiSAPALEServer3
XML
OdiXMLConcat
OdiXMLSplit
Event Detection
OdiFileWait
OdiReadMail
OdiSleep
OdiWaitForChildSession
OdiWaitForData
OdiWaitForLoadPlans
OdiWaitForLogData
OdiWaitForTable
Changed Data Capture
OdiManageOggProcess
OdiRefreshJournalCount
OdiRetrieveJournalData
OdiWaitForData
OdiWaitForLogData
OdiWaitForTable
Alphabetical List of Oracle Data Integrator Tools
This section lists Oracle Data Integrator tools in alphabetical order.
OdiAnt
OdiBeep
OdiDeleteScen
OdiEnterpriseDataQuality
OdiExportAllScen
OdiExportEnvironmentInformation
OdiExportLog
OdiExportMaster
OdiExportObject
OdiExportScen
OdiExportWork
OdiFileAppend
OdiFileCopy
OdiFileDelete
OdiFileMove
OdiFileWait
OdiFtp
OdiFtpGet
OdiFtpPut
OdiGenerateAllScen
OdiImportObject
OdiImportScen
OdiInvokeWebService
OdiKillAgent
OdiManageOggProcess
OdiMkDir
OdiOSCommand
OdiOutFile
OdiPingAgent
OdiPurgeLog
OdiReadMail
OdiRefreshJournalCount
OdiReinitializeSeq
OdiRemoveTemporaryObjects
OdiRetrieveJournalData
OdiReverseGetMetaData
OdiReverseManageShortcut
OdiReverseResetTable
OdiReverseSetMetaData
OdiSAPALEClient and OdiSAPALEClient3
OdiSAPALEServer and OdiSAPALEServer3
OdiScpGet
OdiScpPut
OdiSendMail
OdiSftp
OdiSftpGet
OdiSftpPut
OdiSleep
OdiSqlUnload
OdiStartLoadPlan
OdiStartOwbJob
OdiStartScen
OdiUnZip
OdiUpdateAgentSchedule
OdiWaitForChildSession
OdiWaitForData
OdiWaitForLoadPlans
OdiWaitForLogData
OdiWaitForTable
OdiXMLConcat
OdiXMLSplit
OdiZip
ODI multiple agents with cluster RAC configuration
The following is a depiction of ODI agent deployed in a cluster, connected to Oracle RAC repository.
Physical , Context and Logical Architecture Relations in TOPOLOGY in ODI
Physical , Context and Logical Architecture Relations in TOPOLOGY in ODI
Always Your Physical Architecture will connect direct applications or database or flat files data servers.
Context is an interface or mediator between Logical and Physical Architecture and It will act as a Environments or Set of Servers related to the Environment or Locations.
Logical Architecture is an alias or synonym for you physical schemas. we can create one logical schema
for your set of physical schemas based on contexts.
Always Your Physical Architecture will connect direct applications or database or flat files data servers.
Context is an interface or mediator between Logical and Physical Architecture and It will act as a Environments or Set of Servers related to the Environment or Locations.
Logical Architecture is an alias or synonym for you physical schemas. we can create one logical schema
for your set of physical schemas based on contexts.
Difference between ELT & ETL Architecture
ETL versus ELT Architecture.
Extract -- the action of reading data from a database.
Transform -- the action of transforming the extracted data from its previous form into the resultant form.
Load -- the action of writing the data into the target database.
Transform -- the action of transforming the extracted data from its previous form into the resultant form.
Load -- the action of writing the data into the target database.
Difference between ELT & ETL
| Column1 | ETL | ELT |
| Approach | Traditional | Modern/Future |
| Transformations | Row-By-Row | Bulk |
| Data Movement Throgh Network | Twice | Only Once |
| Engine(Staing server) | Require | Not Required |
| Database Performance | No need to be high | Should be high |
| Licensing cost | High | Comparitively Low |
| Examples | Datastage,Informatica | ODI/ Sunopsis |
Saturday, 26 May 2012
Oracle Data Integrator Architecture
Oracle Data Integrator Architecture
The architecture of Oracle Data Integrator relies on different components that collaborate together, as described in Figure 1-6.
Subscribe to:
Comments (Atom)