upgrade, migrate or evolve - determine the direction for your
TRANSCRIPT
copyright 2010 PITSS America LLC www.pitssamerica.com
Martin DisterheftPresident PITSS America LLC
Upgrade, Migrate or Evolve - determine the direction for your Oracle Forms and Reports Applications
PITSS America LLC
UPNYOUG – March 19th 2010
copyright 2010 PITSS America LLC www.pitssamerica.com
PITSS Company Profile
Founded in 1999
Leading software supplier for managing Oracle Forms and Reports applications. The innovative PITSS.CON software provides functionality for Oracle Forms and Reports applications to
PITSS GmbH Stuttgart, Germany (World Headquarters)PITSS America LLC Troy, MI (United States Headquarters)
Oracle Status
Solid Background, Solid Solutions.
AnalyzeUpgradeMigrate
ReengineerMaintain
copyright 2010 PITSS America LLC www.pitssamerica.com
“…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
copyright 2010 PITSS America LLC www.pitssamerica.com
The worldwide leader in sports entertainment featuring the
broadest portfolio of multimedia sports assets with over 50
business entities.
Real-world ROI: Migration to 10g
Scope
Timelines (in days — estimated and actual)
5 days
Internal
Manual Migration*
PITSS.con Migration
Began UserAcceptance Testing After
Migration to .NET failed
5Yearssaved
Over 1700 FormsMigration Forms 6i to 10g
5.2 man years
* Based on Oracle recommended upgrade duration of 0.75 man days per Form
LEADING SPORTS
NETWORK
copyright 2010 PITSS America LLC www.pitssamerica.com
Agenda
Upgrade, Migrate or Evolve - determine the direction for your Oracle Forms and Reports Applications Risk
De-Supported / Future of Oracle Forms and ReportsOracle Support of Forms and ReportsOracle’s recommended approach for Forms/Report applicationsVulnerabilities / Risks
Upgrade/Migration OptionsManual vs. AutomatedMigration from Forms to ADF/APEX/Java …
Real World ROI with PITSS.CON
copyright 2010 PITSS America LLC www.pitssamerica.com
De-Supported / Future of Oracle Forms and Reports
copyright 2010 PITSS America LLC www.pitssamerica.com
“Oracle is already committing development resources that will take Forms and Reports
through to, at least, 2017. There are no plans to desupport Oracle Forms and Reports after 2017.”
Source: http://www.oracle.com/technology/products/forms/pdf/10g/toolssod.pdf (July 2009)
Future of Oracle Forms and Reports
copyright 2010 PITSS America LLC www.pitssamerica.com
Oracle Forms and Reports 11gActually called Oracle Fusion Middleware 11g Release 1
Released on July 1, 2009
http://www.oracle.com/technology/products/forms/index.html
Future of Oracle Forms and Reports
copyright 2010 PITSS America LLC www.pitssamerica.com
Oracle Support of Forms and Reports
Forms 6i
iDS/iAS (9.0.2)
Developer Suite 10g (9.0.4)
11gR1
Extended Support
Developer Suite 10g Rel 2
copyright 2010 PITSS America LLC www.pitssamerica.com
Oracle Forms Support Timelines
Oracle’s Fusion Middleware Support Timelines
Source : http://www.oracle.com/support/library/brochure/lifetime-support-middleware.pdf (Dec 2009)
2017 and beyond
copyright 2010 PITSS America LLC www.pitssamerica.com
How to get back or stay on a supported platform ?
Today’s Challenges /Questions
“…Should I consider to move away from Oracle Technology?...”
Application Project Manager
“… Can I re-use some of the implemented code-artifacts ?…”
“… I understand ADF is Oracle’s future direction in Fusion Software development –should I start migrating now …”
“…Should I stay with Forms/Reports… ?”
“…Can I implement all the existing Forms functionality with APEX ?… ”
…
copyright 2010 PITSS America LLC www.pitssamerica.com
2.3, 3.0, 4.5, 5.0, 6.0, 6i, 9i
PITSS.CON Software Focus
UnsupportedOracle Forms/ReportsDeployment
10g/11g
SupportedOracle Forms/ReportsDeployment / Web Deployment
Upgrade
Future Architecture (ADF,.)Evolve
Maintain
1
2
3
•Automatedmigration
•Application Re-Engineering
•Maintenance & Development•Application Analysis
Recommended Approach for Forms Applications*1. Move from Client Server to Web2. Upgrade to latest Version3. Interoperate with Java/J2EE or
develop new modules in JDeveloper
*Source: http://www.oracle.com/technology/products/forms/pdf/10g/toolssod.pdf (July 2009)
PITSS.con FunctionalityPITSS.CON Functionality
copyright 2010 PITSS America LLC www.pitssamerica.com
Oracles recommendation to Evolve your Applicationphased Transition
Reduced Risk of Transition failure
Choose your own transfer schedule adjusted to your specific situation (available skills, priorities of ongoing change-requests)
Preparation/Training of Development Team
Evaluate/Setup New infrastructure Architecture
Early End-User involvement in partial Proof of Concepts(No “Big Bang” transition of complete application.)
Benefits of the phased “Way Forward”
copyright 2010 PITSS America LLC www.pitssamerica.com
De-Support
"If you are using unsupported versions of Oracle Forms (earlier than 10.1.2 for non E-Business Suite users) you are no longer benefiting from Oracle's regular patches, including security related patches. It is possible that
your application could therefore be unnecessarily vulnerable to attacks as a result. Another
consideration is that many corporate policies as well as statutory requirements mandate that software used in a
production environment must be eligible for security related patching."
Jan Carlin, Former Principal Product Manager, Oracle Forms – May 2009
copyright 2010 PITSS America LLC www.pitssamerica.com
Risks since de-support of 9i (since Mid 2008)
2 Critical Patch Updates
26 Vulnerabilities
Access Complexity
22 Low
2 Medium
2 High (1 is Remote Exploitable on the Core RDBMS)
De-Support
“IT organizations assume considerable risk with unsupported deployments of Oracle Forms solutions, and risks grows as technology ages.”Mark Driver – Gartner - 2007
copyright 2010 PITSS America LLC www.pitssamerica.com
What Does Unsupported Software Mean?
De-Support
copyright 2010 PITSS America LLC www.pitssamerica.com
De-Support
How much longer will your application continue to run?
Application Software
Operating Software
Hardware
Is a “Change-Freeze” a realistic option?
copyright 2010 PITSS America LLC www.pitssamerica.com
Will Oracle Forms and Reports 6i or 9i work withOracle DB 10g or 11g?
Probably
Maybe
No
The important question:How much longer will your application continue to run?
De-Support
copyright 2010 PITSS America LLC www.pitssamerica.com
Oracle recommends that customers upgrade their Oracle products to the supported versions
Oracle Forms and Reports 6i and 9i are not supported
6i is not certified to run on Oracle DB 10g or 11g
9i is not certified to run on Oracle DB 11g
Every upgrade and patch presents another risk/possibility to your application not working at all
De-Support
copyright 2010 PITSS America LLC www.pitssamerica.com
De-Support
Questions you should ask yourself:
What is the impact to the business if the applications running in the unsupported environment become unavailable?
How long can you tolerate outages?
Are you upgrading other components in your system that might impact the unsupported environment?
What is the probability that these changes may introduce anew problem?
Government regulations might require your industry to stay current in your business enabling software. e.g. could a failure in your unsupported environment lead to a violation of Sarbanes-Oxley or HIPAA ?
copyright 2010 PITSS America LLC www.pitssamerica.com
Migration
Effort to Migrate ManuallyMigrating from 6i to 10g takes .75 to 1.5 man days per object
FMB, MMB, OLB, PLL, RDF
Code changes are at every level throughout the objects
Hundreds of commands are affected
Forms v3.0 de-supported commands are invalid in 10g
If Migrating from earlier versions (2.3, 3.0, 4.0, 4.5, 5.0, 6.0) to 10gMouse Navigation?
Character Mode?
v2 PL/SQL?
copyright 2010 PITSS America LLC www.pitssamerica.com
Migration with PITSS.CON
The Automated Way
MOVIE see www.pitssamerica.com
Or contact
copyright 2010 PITSS America LLC www.pitssamerica.com
PITSS.CON Module
Technology Base
Dynamic Multi-Language
Source Control
Maintenance / Development
Graphical Visual Design
Application Analysis
Application Engineering for SOA
ADF-Assistant
Automatic upgrading / migration
PITSS.CON Lifecycle Management for Oracle Forms
copyright 2010 PITSS America LLC www.pitssamerica.com
PITSS.CON the complete Metadata Repository
Aplication Objects / Code Artifacts
Oracle Forms 4GL
UI
Process
Business Logic
Menu (*.mmb)
Libraries (*.pll / *.olb)
Oracle Reports
Database
DB-Objects
Business Logic (Proc. , Funct. Trigger)
Source Code
SQL / PL/SQL Program
Batch-Jobs
Embedded Code Pro*C, Pro*…..
copyright 2010 PITSS America LLC www.pitssamerica.com
How many attendees have considered to evolve their
Forms Application to ADF,APEX,… ?(away from Oracle Forms ?)
copyright 2010 PITSS America LLC www.pitssamerica.com
From Forms to ADF , APEX, Java EE,…
Forms Application ADF ApplicationAPEX ApplicationJava Application
Benefits Non proprietary Migration of more than just UI objectsAnalysis / Preparation (e.g. removal of Unused Objects )Re‐engineering of Software Architecture for the complete Application
copyright 2010 PITSS America LLC www.pitssamerica.com
Evolve your Application - Preparation is the Key
Analyze your Current Application(Dependencies, complexity of Business-Logic) – prepare for phased approach
Clean-Up / Identify and remove unused Objects/Code Artifacts
Optimize code-re-use (e.g. extract Logic to the DB)
Identify Interaction between UI, Process and Business logic(Relevant to meet new software architecture standards)
…
How good is your Application documented or how good is your insight
Evolve Forms/Reports Applications
copyright 2010 PITSS America LLC www.pitssamerica.com
Forms to ADF Process in PITSS.CON
Web services
Forms Application
UI
process
logic
ADF ApplicationApplication Analysis
Unused Objects Analysis
Business Logic to DB
ADF
Re‐creation
Fine‐tuning
Application Impact
Unused Objects Analysis
BL Assistant
DAL Assistant
Web Services Wizard
PL/SQL2Java
ADF Assistant
copyright 2010 PITSS America LLC www.pitssamerica.com
PITSS.CON ADF-Migration Process
Quality Assurance
Documentation
Iterative Process
Forms Application Repository Metadata ADF Application
Analysis Dead Code Redundancy BL 2 DB ADF Gen Fine Tuning
copyright 2010 PITSS America LLC www.pitssamerica.com
PITSS.CON Accelerates Forms Projects
PITSS.CON automates and accelerates any Oracle Forms Projects
PITSS.CON functionalityReduces Project duration Free up Project BudgetEnsures a higher Quality compared to traditional (manual) approaches
Definition Planning Implementation ProductionPreparation
Traditional
WithPITSS.CON
t
copyright 2010 PITSS America LLC www.pitssamerica.com
specialist provider of information systems focused
on complex areas of healthcare.
Real-world ROI: Migration to 10g
Scope
Timelines (in days — estimated and actual)
PITSS.CON Migration
1Year
Saved
1000 FormsMigration from 6i to 10g
* Based on Mediware’s Internal estimates
“PITSS protects investments in Oracle Forms/Reports applications”
*Manual Migration
“In our case, the PITSS technology saved us significant time and money for our migration from Oracle Forms 6i to 10g. The whole conversion took only about three days versus the eight months we had estimated to do a manual migration. If you’re an Oracle shop, PITSS is definitely the way to go.” – Shri Potdar, Director of Technology, Mediware Information Systems
*Manual Migration Cost $2,000,000.00
1 Man Year
PITSS.CON Migration Cost $80,000.00
3 Days
copyright 2010 PITSS America LLC www.pitssamerica.com
The worldwide leader in sports entertainment featuring the
broadest portfolio of multimedia sports assets with over 50
business entities.
Real-world ROI: Maintenance and Development
Scope
Timelines
1 Month, under $50K
Internal
PITSS.con
6 Months, $250K
80% Savings
Change Channel field from Number(5) to Number(6,1)3 Applications, over 1700 Forms
* Based on Oracle recommended upgrade duration of 0.75 man days per Form
LEADING SPORTS
NETWORK
copyright 2010 PITSS America LLC www.pitssamerica.com
PITSS.CON Proposed Next Steps
Proposed next steps:
Customer specific PITSS.con Live Webinar30 Minute sales-based webinar45-60 Minute technical webinar
Risk-Analysis / Proof of Concept Workshop Free PITSS Application Risk-Analysis done off-site with all Form and Report Objects Free On-Site workshop performed with your own application to Analyze the Application and create a POC prototype.
On-Line Technical Webinars http://www.pitssamerica.com/pitss_webinars.htm
copyright 2010 PITSS America LLC www.pitssamerica.com
PITSS POC workshop proposal
PITSS Proof of Concept Workshop (3-5 days)Analysis of Application to assess upgrade/migration complexityPlanning for required changes / Decision on solution proposalsImplementation of automated upgrade/migration changes
Analysis Planning Implementation Test / ProductionPreparation
PITSS POC Workshop
PITSS provides this 3-5 day on-site workshop at no charge if application can be analyzed on PITSS hardware.Compiled Objects will be provided for testing/evaluation – changed Source-Objects will be provided only after License-purchase
Decision on License Purchase
copyright 2010 PITSS America LLC www.pitssamerica.com
Q & A / Wrap-up
PITSS Contact Information:Americas:
Website: www.pitssamerica.comEmail: [email protected]: +1 248.740.0935
EMEA, Asia/PacificWebsite: www.pitss.comEmail: [email protected]: +49.8171.216210