from oracle warehouse builder to oracle data integrator fast and safe

Oracle Data Integration Solutions EMEA Partner Community Forum

Massimo Sposaro - marketing managerAlessandro Drago - technical team leader

Database & Technology

11th - 12th February 2014Prague, Czech Republic

From Oracle Warehouse Builder to Oracle Data Integrator fast and safe

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.

Database & Technology

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

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

About the Converter

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.

Product overview

Supported versions

OWB v. 9.2 or higherODI v. 10g or higher

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.

Conversion process

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

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

How Converter Migrates OWB Metadata

Where is it semi-automatic?

OWB

Processflows

Processflows

MappingsMappings

DT Analyze

ODI

Load PlanLoad Plan

MappingsMappings

KMTopology

Conversion

Why is it semi-automatic?

Locations VS Topology

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 ManagementSetting Customize KM on MappingReady to run mappings

Why is it semi-automatic?

OWB to ODI ConversionManual process Automatic process

Assessment

Conversion

Test

Debugging anditerative test

Manualrecognition

Manualcoding

Manualdebugging and

verification

Manualverification

Full testedconverter

Automatic

Automatic

Manualverification

Conversion standard timing

Conversion

1/2 days

Assessment

.mdl fileAssessmentreport

5/10 days.mdl file

DB’s schema(no data)

ODI Projectxml

ODI Topology xml

Assessment meeting

Application logic

Enterprise job scheduler

Workflow manager

Architecture: typical scenarios(Pre-conversion)

Oracle Warehouse BuilderProject

Oracle Workflow(for example)

Oracle Warehouse BuilderProject

Scenario 1 Scenario 2

Application logic

Enterprise job scheduler

Workflow manager

Oracle Data IntegratorProject

Oracle BPEL(for example)

Oracle Data IntegratorProject

Scenario 1 Scenario 2

Architecture: typical scenarios(Post-conversion)

OWB to ODI Conversion project

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, …)

Success Story

Ireland

Brazil

Netherlands

Belgium

Our Partners:

Largo Promessi Sposi, 420142 Milano, ItalyPhone +39 02 8950 0080Fax +39 02 8954 9736Mobile +39 348 6979791

Email: massimo.sposaro@databtech.comalessandro.drago@databtech.comdt.marketing@databtech.net

Websites:www.owb2odiconverter.comwww.databtech.com OWB to ODI

migration group

Database & Technology