201103 cuore forms2_adf v0.2

38
Herramientas de migración automática de Oracle Forms a Oracle ADF

description

 

Transcript of 201103 cuore forms2_adf v0.2

Page 1: 201103 cuore forms2_adf v0.2

Herramientas de migración automática de Oracle Forms a Oracle ADF

Page 2: 201103 cuore forms2_adf v0.2

Agenda

Presentación compañías

Roadmap Oracle Forms

¿Porqué Oracle ADF?

¿Porqué PITSS?

Referencias

Page 3: 201103 cuore forms2_adf v0.2

Presentación atSistemas

Page 4: 201103 cuore forms2_adf v0.2

Compañía 100% capital español con presencia en Madrid, Barcelona y Cádiz

Fundada en 1994 15 Millones de Euros de facturación y 350 profesionales

Presente en los principales sectores del mercado

Excelencia en uso efectivo de Nuevas Tecnologías IT

Inversión I+D+i

Quiénes somos01

LA COMPAÑÍA

1.1

Page 5: 201103 cuore forms2_adf v0.2

1.0 atSistemas en cifras

2004 2005 2006 2007 2008 2009 2010

0

50

100

150

200

250

300

350

EMPLEADOS

2004 2005 2006 2007 2008 2009 2010

02468

10121416

FACTURACIÓN

Mil

lon

es

Productividad Costes reducidos Excelencia Tecnológica Muy alta motivación

Agilidad Flexibilidad Solvencia Compromiso

15 M de € de

facturación

350

profesionales

* Previsión de ventas

Page 6: 201103 cuore forms2_adf v0.2

1.0 atSistemas presencia geográfica

Madrid

Barcelona

Jerez de la Frontera

Page 7: 201103 cuore forms2_adf v0.2

Nuestro socioTecnológico:Pitss

Page 8: 201103 cuore forms2_adf v0.2

Copyright 2011 PITSS GmbH www.pitss.com

The Forms and Reports Modernization Experts

PITSS – Professional IT Software & Services

More than 15 years experience with Oracle technology

Oracle Gold Partner

Member of Oracle Modernization Alliance

Oracle Forms Migration Partner

Customer references around the world

PITSS GmbH PITSS America LLC www.pitss.com www.pitssamerica.com www.pitss.de

Page 9: 201103 cuore forms2_adf v0.2

RoadmapOracle Forms

Page 10: 201103 cuore forms2_adf v0.2

2.0 Roadmap Oracle Forms

Aproveche inversión• Reutilice sistemas actuales• Beneficios de arquitectura SOA• Integración• Bajo riesgo

Introducción nuevas herramientas• Explorar oportunidades• JDeveloper / ADF• Nuevas funcionalidades (Web

services)• Integración• Bajo riesgo

Recomendación

Page 11: 201103 cuore forms2_adf v0.2

¿PorquéOracle ADF?

Page 12: 201103 cuore forms2_adf v0.2

3.0¿Qué és ADF?

Framework de desarrollo JEE de Oracle

Más Productividad

Más usabilidad

Web 2.0, Ajax, JSF, Multicanal.

Desarrollo basado en estándares

EJB 3 (JSR-220), JSF (JSR-127): Trinidad

Data Binding (JSR-227), Portlets (JSR-168)

Page 13: 201103 cuore forms2_adf v0.2

3.0¿Qué es ADF?

Page 14: 201103 cuore forms2_adf v0.2

3.0¿Qué es ADF?

ADF es el corazón de Fusión Applications y más …

Page 15: 201103 cuore forms2_adf v0.2

3.0Fusion Applications

Page 16: 201103 cuore forms2_adf v0.2

¿Porqué PITSS.CON?

Page 17: 201103 cuore forms2_adf v0.2

4.0 Soluciones de modernización de Forms

JHeadstart Forms2ADF Generator PITSS – PITSS.CON Tool OraFormsFaces

__________________________

CipherSoft - Exodus Migration Tool VGO Software - EVO Forms-to-Java Tool Imex Systems – Ormit Java/ADF Tool Qualogy – QAFE

Recomendación

Page 18: 201103 cuore forms2_adf v0.2

4.0 ¿ Porqué PITSS?

Forms Application Repository Metadata

Met

adat

a R

epos

itory

ADF Application

Page 19: 201103 cuore forms2_adf v0.2

Application Analysis Phase

1st Challenge: Know Your Own ApplicationForms Reports

Database

initial developers still with the company?

full documentation available?

Revision Control? ALL sources secured? Menus

Documentation

Libraries

External components

App Analysis

“…The combination of older code, lack of documentation, applications size and complexity all contribute to very high barriers to migrate for many Oracle Forms deployments…” Mark Driver – Gartner - 2007

Cha

lleng

es

Page 20: 201103 cuore forms2_adf v0.2

Obsolete objects in orders.fmb: 142 out of 245 = 58%

Calendar functionality for date fields

Alert for validating fields

Graphics: rectangles

Visual Attribute: current_record

Orphan objects: 1 object group, 1 program unit, 1 LOV

Unused Objects Analysis Phase

Should we migrate ALL objects?

Alert 1Attached Library 1Blocks 2Canvas 1Graphics 53Items 51Object Groups 2Object Childs 12Program Units 2Property Class 1Triggers 11Visual Attributes 4Window 1

142

App Analysis

Unused Objects Analysis

Reduce Redundant Objects

The unused ones? Irrelevant? Null code? Redundant?

Skills: Forms &

ADF

Cha

lleng

es

Page 21: 201103 cuore forms2_adf v0.2

Do we have Redundancies?Forms Objects/ Business Logic→ Components Reuse → Modularity

30% match

100% match70% match

100% match

70% match

50% match

Skills: Forms

App Analysis

Unused Objects Analysis

Reduce

Redundant Objects

Reducing Redundancies Phase

Cha

lleng

es

Page 22: 201103 cuore forms2_adf v0.2

App Analysis

Unused Objects Analysis

Business Logic2DB

Reduce Redundant Objects

The difference between Orders.fmb and a real-life application:

The Investment Preserving Challenge

Business Logic Phase

Cha

lleng

es

Page 23: 201103 cuore forms2_adf v0.2

App Analysis

Unused Objects Analysis

Business Logic2DB

Reduce Redundant Objects

Skills: Forms, PL/SQL

The Investment Preserving Challenge

Business Logic Phase

Cha

lleng

es

Page 24: 201103 cuore forms2_adf v0.2

ADF/ APEX Redesign Phase

The Redesign Challenge

App Analysis

Unused Objects Analysis

Business Logic

Reduce Redundant Objects

ADFRedesign

Forms UpgradeADF AssistantAPEX AssistantPLSQL2Java Code TranslatorBusiness Logic to DBWeb Service Wizard…

Tool-Supported vs. Full Manual Re-Write

PITSS.CONCha

lleng

es

Page 25: 201103 cuore forms2_adf v0.2

Reduce Redundant Objects

PL/SQL syntax → Java syntax Forms bind variables → ADF corresponding structures Forms built-ins → ADF equivalents Database calls → calls to DB Logic Accessors (DBLA)

The Code Artifact Conversion Challenge What a PL/SQL2Java code translator can do:

ADF/ APEX Redesign Phase

App Analysis

Unused Objects Analysis

Business Logic

Reduce Redundant Objects

ADFRedesign

Page 26: 201103 cuore forms2_adf v0.2

App Analysis

Unused Objects Analysis

Business Logic2DB

ADF Redesign

Fine-tuning

Reduce Redundant Objects

The Web Look and Feel Challenge

10 pixelbetween

10 pixelleft

10 pixelbelow

10 pixelright

Corporate GUI Standards

Fine-Tuning Phase

Cha

lleng

es

Page 27: 201103 cuore forms2_adf v0.2

App Analysis

Unused Objects Analysis

Business Logic2DB

ADF Redesign

Fine-tuning

Reduce Redundant Objects

Redesigning the UI to meet Browser StandardsThe Browser Memory Challenge

…do we need on 1 page… … 100 fields? … or 100 records?

Fine-Tuning Phase

Cha

lleng

es

Page 28: 201103 cuore forms2_adf v0.2

Post-Generation Objects Correspondence Report

Manual Adjustments To-Do-List

PLSQL2Java code translator

Guidelines

Service Support

Training

The Fine-Tuning Challenge

App Analysis

Unused Objects Analysis

Business Logic2DB

ADF Redesign

Fine-tuning

Reduce Redundant Objects

Skills: ADF, Java

Fine-Tuning Phase

Cha

lleng

es

Page 29: 201103 cuore forms2_adf v0.2

App Analysis

Unused Objects Analysis

Business Logic2DB

ADF Redesign

Fine-tuning

Maintain Enhance

Reduce Redundant Objects

Conversion project completion

Cost

Time

Manual re-write in e.g. .NET , Java …

PITSS Migration to ADF, APEX, …

1:1 Migration-Toolswithout Forms Preparation

PITSS Upgrade to 11g

Code Maintenance after conversion

The Maintenance Challenge

Upgrade/Migration Approach with PITSS.CON

proprietary components inside? know-how with your company? clear architecture, consistent

development style?

Maintenance and Enhancing Phase

Cha

lleng

es

Page 30: 201103 cuore forms2_adf v0.2

Quality Assurance

Documentation

Iterations

Co-Existence of Technologies/ Partial Projects

Re-Engineering SOA

Forms 11g

ADF

Analysis Dead Code Redundancy BL 2 DB

APEX

PITSS.CON Modernization Process

Managing a successful project

Page 31: 201103 cuore forms2_adf v0.2

Think Big → Start Small → Move Fast Challenge us

Pilot or Full migration projects Trainings, Workshops

Where do we start

Next Steps

Nex

t S

teps

Page 32: 201103 cuore forms2_adf v0.2

UI

Mid

dle

Tie

rB

D

Web ServicesWeb Services

JinitiatorApplet

JinitiatorApplet

Forms ServerForms Server

PL / SQLPL / SQL

JPCJPC

HTMLJavascript

HTMLJavascript

Data Binding & Data ControlData Binding & Data Control

JSF & ADF FacesJSF & ADF Faces

JSFJSF

ADFBusiness Components

ADFBusiness Components

Service Layer

View

Controller

Model( JSR 227 )

Business Services

Data Source

Client

Page 33: 201103 cuore forms2_adf v0.2

Referencias

Page 34: 201103 cuore forms2_adf v0.2

Copyright 2011 PITSS GmbH www.pitss.com

Customer Examples At-A-Glance

US Health Care Provider Oracle Forms 6i to

JDeveloper 11.1.1.3.0 Challenges

Complex User Interface tab pages with complex run-time navigation master-detail-detail-detail on one page

Webutil, Reports, LDAP security 6 Applications ON TIME!!, currently in productive environment

Exa

mpl

es

Page 35: 201103 cuore forms2_adf v0.2

Copyright 2011 PITSS GmbH www.pitss.com

Customer Examples At-A-Glance

USSOCOM

400 Forms 10g to JDeveloper 11.1.1.3.0

Challenges Preferred In-house migration (classified application) Protect business logic from Forms applications

SOCOM chose a tool-based approach allowing re-engineering the Forms application to meet the new ADF architecture.

Exa

mpl

es

Page 36: 201103 cuore forms2_adf v0.2

Copyright 2011 PITSS GmbH www.pitss.com

400 Forms 10g to

JDeveloper 11.1.1.4.0

Challenges Designer-generated modules Very complex user interface Protect business logic from Forms applications

PITSS.CON is specially equipped to manage the migration challenges for designer-generated modules.

Customer Examples At-A-Glance

Airas Intersoft, UK

Exa

mpl

es

Page 37: 201103 cuore forms2_adf v0.2

Copyright 2011 PITSS GmbH www.pitss.com

PITSS Customers

Pro

ject

s

Page 38: 201103 cuore forms2_adf v0.2

Gracias por su atenciónPedro [email protected]

PARA MÁS INFORMACIÓN:

www.atsistemas.com / e-mail: [email protected]

Foro Abierto