Oracle Data Integrator: ODI

Why choose ODI:

Faster and simple development: Declarative
Data quality firewall
Better execution performance: ETL architecture based on RDBMS and SQL engines
Simpler and more efficient architecture
Platform Independence
Data Connectivity
Cost-savings

Data integration scenario in recent days:

• DWH
• BI
• MDM
• Big data
• Apps
• SOA

 Components of ODI:

• Repository
• Master : Contains- 
• user privilege, 
• source and target connectivity, 
• subsequent version of objects
• Work : Contains- 
• meta data of source and target definitions,
• transformation and data movement rules
• workflow for orchestration of transformation and data movement
• jobs schedules
• logs
• execution status
• Execution: required for PROD and contains
• operational meta data
• generated code
• execution results
•  statistics
• Studio
• Designer navigator
• Operator Navigator
• Topology Navigator
• Security Navigator
• Agents
• stand alone
• j2ee
• co-located(in 12c)
• Console
• OEM

My journey with 12c

Can I install 11 g and 12c on same machine.

• Step 1: get 11g pre-built 11g installation:

• Installed 11 g: http://www.oracle.com/te

chnetwork/middleware/soasuite/learnmore/vmsoa-172279.html

Much dive in for 11g vs 12c 
 http://itconvergence.blogspot.in/2014/09/oracle-soa-12c-11g-10g-upgrade-etl-odi-xslt-osb-ess-mds-xquery-fusion-middleware.html
http://itconvergence.blogspot.in/2014/09/oracle-soa-12c-upgrade-11g-10g-soap-api-sfdc-erp-integration-cloud-mobile.html

For 10g to 11g migration path?
https://blogs.oracle.com/imc/entry/oracle_soa_suite_upgrade_from

 
For 11g vs 12c:

http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0CBwQFjAA&url=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork%2Fmiddleware%2Fsoasuite%2Foverview%2Fwp-soa-suite-whats-new-12c-2217186.pdf&ei=hzJvVPKQL6OSmwWLwoHYDA&usg=AFQjCNGHOv3duhlLfXvPVyVwi-mGdpgOuQ&sig2=_pUJE2ukx3VWjjiEnlcg6w&bvm=bv.80185997,d.dGY

http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0CCEQFjAB&url=http%3A%2F%2Fwww.oracle.com%2Fus%2Fproducts%2Fmiddleware%2Fsoa%2Finside-look-soa-suite-wp-2217219.pdf&ei=hzJvVPKQL6OSmwWLwoHYDA&usg=AFQjCNG5zll35apZT8Q9Mp9hflaxXWSurw&sig2=Oniw3sBepkB_dN8CbcnaKg&bvm=bv.80185997,d.dGY


11g to 12c migration path:

https://blogs.oracle.com/SOA/entry/best_practices_for_soa_11g

Enterprise Architecture

EA has responsibility of Business and IT alignment

Scope of EA:

1. EA help CIO to develop IT strategy based on business strategy
1. Application strategy: Application support Business strategy
2. integration strategy: application need to be integrated to perform business process
3. infrastructure strategy
4. service strategy: how and which customer will get services
5. sourcing strategy: what to outsource and what is inhouse
2. Strategic planning for 3-5 years
3. IT portfolio management
1. Project portfolio management(not entirely)
2. application portfolio management
1. Measuring returns
3. infrastructure portfolio management
4. Architecture Governance through
1. Monitoring IT Portfolio
2. IT Project Process
5. System architecture
6. Meta modelling
7. Developing standard

Togaf is designed to support:

• Business architecture
• information architecture
• technology architecture
• application architecture

Phases in ADM:

• Preliminary 
• Phase A: Architecture vision
• Phase B: Business architecture
• Phase C: Information System architecture
• Phase D: Technology Architecture
• Phase E: Opportunity and solutions
• Phase F: Migration planning
• Phase G: Implementation Governance
• Phase H: Architecture change management
• Requirement Management