From Oracle Warehouse Builder to Oracle Data Integrator fast and safe.

100 %
0 %
Information about From Oracle Warehouse Builder to Oracle Data Integrator fast and safe.
Technology

Published on February 17, 2014

Author: databtech

Source: slideshare.net

Description

What Oracle Warehouse Builder to Oracle Data Integrator migration service consists of and how it's carried out.
Hear about all the benefits it generates for companies.

Oracle Data Integration Solutions EMEA Partner Community Forum 11th - 12th February 2014 Prague, Czech Republic Massimo Sposaro - marketing manager Alessandro Drago - technical team leader Database & Technology

From Oracle Warehouse Builder to Oracle Data Integrator fast and safe

Database & Technology Database & Technology was founded in Milan, Italy in 1999. We specialize in providing consulting services, support and training with regard to business intelligence and database administration. We have excellent Oracle Data Integrator and Oracle Golden Gate skills and our highly-experienced professionals are certified in these technologies.

Database & Technology In addition, since 2008 we have been performing OWB to ODI migrations, having designed and developed a semi-automated tool that allows any company to migrate to ODI, saving them a great deal of time and money compared to a manual migration. For having developed this migration tool, we have been referenced by Oracle Corporation itself. We are also offering our experience in migrating from OWB to ODI using the tool recently developed by Oracle regarding migrations from the latest release of OWB11g to the latest release of ODI12c.

From Oracle Data Integration Statement of Direction: So if client has to migrate or wants to migrate from OWB to ODI, a transfer of the OWB components to equivalent ODI components needs to be planned

About the Converter  OWB2ODI Converter is a semi-automatic tool developed by D&T to assist the migration of OWB projects into ODI projects  OWB2ODI Converter can speed up the migration process significantly  The conversion can be done either at the customer or in outsourcing, starting from export of the OWB project

Product overview OWB2ODI Converter acquires OWB repository’s metadata and it generates the corresponding ODI repository. Algorithms in OWB are transferred in ODI and OWB operators are transformed in corresponding ODI operators. Supported versions OWB v. 9.2 or higher ODI v. 10g or higher

Conversion process After initial assessment phase with the client, a specific Converter component extracts metadata from the OWB .mdl file. In their own laboratories, D&T uses the OWB2ODI Converter to automatically generate the corresponding ODI project from the original OWB one. The generated ODI project is sent to the client for the acceptance test.

General architecture

How Converter Migrates OWB Metadata OWB2ODI Converter can migrate:  OWB Project ODI Project  OWB Location ODI Topology Logical Schema  OWB Module ODI Folder  OWB Mapping ODI 11g: ODI Packages ODI Interfaces ODI Temporary Interfaces ODI 12c: ODI Package ODI Mapping

How Converter Migrates OWB Metadata Migration to ODI 11g Complex Mappings need to be split into several interfaces to generate the same SQL Code

How Converter Migrates OWB Metadata Migration to ODI 12c Many similarities between ODI 12c and OWB mapping. Little rework for particular combination of operators

Where is it semi-automatic? KM OWB Topology ODI Mappings Process flows Mappings DT Analyze Conversion Load Plan

Why is it semi-automatic? Locations VS Topology

Why is it semi-automatic? Datastore Management  Access to updated metadata  Management of NOT BOUND operators  Management of operators with NO LOCATIONS  Synchronization between NOT BOUND operators and BOUND operators  Customize Models organization (SubModel hierarchy)

Why is it semi-automatic? KM Management  Setting Customize KM on Mapping  Ready to run mappings

OWB to ODI Conversion Manual process Assessment Manual recognition Automatic process Automatic Automatic Conversion Test Debugging and iterative test Manual coding Manual verification Manual verification Manual debugging and verification Full tested converter

Conversion standard timing Assessment .mdl file 1/2 days Assessment report Assessment meeting Conversion .mdl file DB’s schema (no data) ODI Topology xml 5/10 days ODI Project xml

Architecture: typical scenarios (Pre-conversion) Scenario 1 Scenario 2 Enterprise job scheduler Oracle Workflow (for example) Oracle Warehouse Builder Project Workflow manager Oracle Warehouse Builder Project Application logic

Architecture: typical scenarios (Post-conversion) Scenario 1 Scenario 2 Enterprise job scheduler Oracle BPEL (for example) Workflow manager Oracle Data Integrator Project Oracle Data Integrator Project Application logic

OWB to ODI Conversion project Success Story Scenario PEDW (Pirelli Enterprise DW)  OWF (400 flows)  OWB v. 10.2 (2.300 mappings)  Oracle DB v. 10g  ODI v. 11.1.1.6  Platforms (Oracle, Sql Server, SAP, sequential files, …)

Our Partners: Ireland Brazil Netherlands Belgium

Database & Technology Largo Promessi Sposi, 4 20142 Milano, Italy Phone +39 02 8950 0080 Fax +39 02 8954 9736 Mobile +39 348 6979791 Email: massimo.sposaro@databtech.com alessandro.drago@databtech.com dt.marketing@databtech.net Websites: www.owb2odiconverter.com www.databtech.com OWB to ODI migration group

Add a comment

Related presentations

Related pages

From Oracle Warehouse Builder to Oracle Data Integrator ...

From Oracle Warehouse Builder to Oracle Data Integrator fast and safe. Massimo Sposaro marketing manager Alessandro Drago technical team leader
Read more

Making the Move from Oracle Warehouse Builder to Oracle ...

Making the Move from Oracle Warehouse Builder to Oracle Data ... A detailed guide to a phased migration to Oracle Data Integrator 12c. ... FAST _CHECK ...
Read more

Oracle® Fusion Middleware - docs.oracle.com

Migrating From Oracle Warehouse Builder to Oracle Data ... Oracle Fusion Middleware Migrating From Oracle Wa rehouse Builder to Oracle Data Integrator ...
Read more

OWB-EE 11gR2: New features provide fast, flexible data ...

Oracle Data Integrator ... integration offering from Oracle. Now Warehouse Builder Enterprise ... provide fast, flexible data integration to ...
Read more

Oracle Warehouse Builder 11gR2: OWB ETL Using ODI ...

... Oracle Data Integrator is used in Oracle Warehouse ... Oracle Warehouse Builder 11gR2: OWB ETL ... fast, flexible, heterogeneous data ...
Read more

Space: Warehouse Builder | Oracle Community

Oracle Warehouse Builder 11.2 to Oracle Data Integrator ... Has anyone upgraded Oracle Warehouse Builder from ... I'm trying to create a data warehouse ...
Read more

Introduction to Data Replication and Integration - Oracle

1 Introduction to Data Replication and Integration. ... solutions for integrating data. See Oracle Warehouse Builder ... has fast, local access to the data.
Read more

Oracle Data Integrator - Oracle | Integrated Cloud ...

Oracle Data Integrator is a ... It includes interoperability with Oracle Warehouse Builder ... Oracle Management Pack for Oracle Data Integrator. Oracle ...
Read more