Unlock the Power of Exodus Converting Oracle Forms

1
Unlock the Power of ExodusConverting Oracle
Forms PL/SQL to Java
Presented to
Presented by Jennifer McNeill, President and CEO
2
Agenda

• About CipherSoft Inc.
• The Business Reasons for migrating to Java
• Oracles Strategic Direction
• Migration Options
• Automatic Migration Goals
• About Exodus
• Conversion Objectives
• Conversion Process
• Run-time Environment
• Migration Questions
• Questions Answers

3
Corporate History

• Named the fastest growing company in Alberta by
  Alberta Venture magazine Grant Thornton
  Chartered Accountants

• Sold joint venture oil gas accounting
  application to Ernst and Young

• Experienced double digit revenue growth each
  year between 1995 2000

• Acquired by Cedar Group PLC, a leader in
  "mid-market" native Oracle Financial Accounting
  Solutions

• Cipher Systems was founded as a conversion
  technology consulting firm

• Owners established CipherSoft Inc. to further
  market develop Exodus

• Developed euro conversion tool

• Development of Exodus began

• Unveiled Exodus to public

1978
1980
1990
1999
1995
2000
2002
2003
2001

• Deloitte Touche selected Cipher as the 50
  fastest growing technology companies in Canada
• Jennifer McNeill, recognized by Chatelaine
  Magazine as the top 100 Female Entrepreneurs in
  Canada

• Selected as top 100 fastest growing companies in
  Canada by PROFIT magazine
• Selected as top 100 Employers by Mediacorp Canada

• Convert legacy systems to open operating
  environments
• Develop market COBOL based software products
• Develop implement business accounting
  applications

• Developed Y2K conversion tool

• Worked jointly with Cedar on development of
  Exodus
• Established conversion facility at Canadian
  Headquarters

• Exodus upgrades
• - JSP files
• - Integration with Oracle JDeveloper

4
Driven with Thought Leadership

• Publications Conferences Memberships

Partners
IBM Business Partner
Oracle Migration Partner
5
The Business Reasons - Why Convert to Java?

• A powerful Object Oriented Programming language
• The "most open" product that is available,
  conforming both to its own standardized (and
  published) specifications as well as with other
  industry standards such as CORBA
• JDBC (Java Database Connectivity) provides a
  standardized interface for Relational databases
  for Java, providing a greater level of database
  independence and portability
• Can eliminate costs/support of proprietary
  licensing
• Platform Database independence

6
The Business Reasons - Why is Java superior?

• Java is currently the only technology that
  provides a fully interactive, GUI interface for
  the Web
• The Java architecture was designed with security
  in mind, and not as an afterthought. This
  provides a simplified and consistent means of
  protecting your assets.
• Java provides features that make programming
  easier as well as more powerful
• multi-threading capabilities
• automatic "garbage collection" (for efficient use
  of memory)
• standardized error trapping and detection
• distributed processing capabilities

7
Oracles Strategic Direction

• CipherSoft is a Global Oracle Migration Partner
  sharing Oracle's vision for an integrated,
  complete and standard development environment
• CipherSoft and Oracle believe strongly, and have
  invested heavily, in the combination of Java,
  SQL, and XML
• Reference SitesCipherSoft is listed in the
  whitepaper Migrating Oracle Forms to J2EE
  http//otn.oracle.com/products/forms/htdocs/FormsJ
  avaSOD.html
• CipherSoft is selected as Migration
  Partners for the Oracle JDeveloper partner
  initiativehttp//otn.oracle.com/products/jdev/ht
  docs/partners/content.html

8
Migration Options

• Rewrite Application
• Programmers often want to throw away code and
  start over. Why? The cardinal fundamental law of
  programming Its harder to read code than to
  write it.
• Programmers tend to write their own functions
  because it's easier and more fun than figuring
  out how the old function works. However, old code
  has been used, tested, and bugs have been found
  and fixed
• Web-enable Forms
• Easy - No change to development style
• Not a real migration
• Manual conversion
• Time consuming, design own architecture from
  scratch, human error issues, lack of resources or
  skill set, disruptions to business operations,
  escalating costs
• Automatic conversion
• Trusted architecture, cost efficient, less time
  intensive, manages risks, less errors, much faster

9
Goals for Automatic Conversion

• Fully maintainable
• Portable
• Contains no wrappers
• All semantic contents converted
• Flexible deployment
• Very little impact on business operations

10
Goals for Automatic Conversion

• Integration option - to integrate with Oracles
  9iAS development environment including
• Full integration with JDeveloper
• Utilization of Oracles UIX and BC4J environment
• Assists in moving applications from Release 3.0
  and later releases into the 9iAS environment
• Provides efficient way to get Forms, Libraries,
  and Procedures into 9iAS environment

11
About Exodus

• Migrates Oracle Forms and PL/SQL applications to
  Java, J2EE, XML and HTML
• 90 faster than manual migration
• 80 cost reduction for the client
• Tool is available for purchase or conversion
  service
• Migrates PL/SQL packages and libraries to EJBs
  and can be deployed on any standard web servers
• Supports JSP files, enabling the development of
  dynamic Web sites

12
Conversion Objectives

• N-Tier Architecture
• J2EE Compliant
• XML Driven
• Generic GUI Generation
• Provides clients with the option to integrate
  with JDeveloper or become database independent

13
Conversion Process
Oracle Form A.FMB
Web Server Directory Structure
webapps
demoApp
demoApp-ejb
demoApp-web
JLS
DTM/BC4J
NAV
WEB-INF
classes
LIB
14
Conversion Process
Oracle Form A.FMB
Web Server Directory Structure
webapps
Text Output
demoApp
demoApp-ejb
A.TXT
demoApp-web
JLS
DTM
DTM/BC4J
NAV
WEB-INF
classes
LIB
15
Conversion Process
Oracle Form A.FMB
Web Server Directory Structure
webapps
Text Output
demoApp
demoApp-ejb
A.TXT
demoApp-web
JLS
DTM
Transform to XML
DTM/BC4J
NAV
Transform to XML
WEB-INF
classes
A. XML
LIB
16
Conversion Process
Oracle Form A.FMB
Web Server Directory Structure
PL/SQL JDBC Java Converter (Packages)
webapps
Text Output
demoApp
demoApp-ejb
EJBs
A.TXT
demoApp-web
JLS
DTM/BC4J
Transform to XML
Transform to XML
Transform to XML
NAV
Transform to XML
WEB-INF
classes
A. XML
LIB
17
Conversion Process
Oracle Form A.FMB
Web Server Directory Structure
PL/SQL JDBC Java Converter (Packages)
webapps
Text Output
JLS Generator (Canvases)
demoApp
demoApp-ejb
EJBs
A.TXT
demoApp-web
JLSs
JLS
DTM/BC4J
Transform to XML
NAV
WEB-INF
classes
A. XML
LIB
18
Conversion Process
Oracle Form A.FMB
Web Server Directory Structure
PL/SQL JDBC Java Converter (Packages)
webapps
Text Output
JLS Generator (Canvases)
demoApp
demoApp-ejb
EJBs
A.TXT
demoApp-web
DTM/B24J Generator (DataBlocks)
JLSs
JLS
DTM/BC4J
DTMs/BC4Js
Transform to XML
NAV
WEB-INF
classes
A. XML
LIB
19
Conversion Process
Oracle Form A.FMB
Web Server Directory Structure
PL/SQL JDBC Java Converter (Packages)
webapps
Text Output
JLS Generator (Canvases)
demoApp
demoApp-ejb
EJBs
A.TXT
DTM/BC4J Generator (DataBlocks)
demoApp-web
JLSs
JLS
DTM/BC4J
DTM/BC4J Navigation Generator (Relations)
DTMs/BC4Js
Transform to XML
NAV
NAVs
WEB-INF
classes
A. XML
LIB
20
Conversion Process
Oracle Form A.FMB
Web Server Directory Structure
PL/SQL JDBC Java Converter (Packages)
webapps
Text Output
JLS Generator (Canvases)
demoApp
demoApp-ejb
EJBs
A.TXT
DTM/BC4J Generator (DataBlocks)
demoApp-web
JLSs
JLS
DTM/BC4J
DTM/BC4J Navigation Generator (Relations)
DTMs/BC4Js
Transform to XML
NAV
NAVs
WEB-INF
classes
Forms Class Generator (Triggers)
Forms Classes
A. XML
LIB
21
Run-Time Environment Servlet/Applet
Client (Applet)
JDBC Messaging
HTTP XML Messaging
Relational Database
Express Server (Servlet)
JNDI Messaging
Client (Applet)
Servlet Resources
EJB Container
demoApp
demoApp-ejb
App-web
Client (Applet)
JLS
DTM/BC4J
NAV
WEB-INF
LIB
22
Important Migration Questions

• To ensure that the migration is being converted
  to a true Java or J2EE environment, you should
  ask the following questions
• Is my application being converted to truly
  compliant J2EE code?
• Are we able to purchase the tool, or is this a
  service offering only?
• Where is my conversion to be performed (on-site
  or at the client's site)?
• Are we able to discontinue licensing of Oracle
  Forms and PL/SQL or do I still have to
  license these products?

23
Important Migration Questions

• Is the vendor offering the product or service
  available to assist with any issues and
  training once we migrate to Java?
• What percentage of conversion is automatic (how
  much manual work is involved once it is
  converted)?
• Is the J2EE code "clean", i.e., is it easily
  maintainable once I get into the Java
  environment?
• Does the converted code integrate with
  JDeveloper and utilize the UIX and BC4J
  environment from Oracle?
• Does the converted code allow you to become
  database independent?

24
A
Jennifer McNeilljmcneill_at_ciphersoftinc.com Office
403 256 5699 Cell 403 861 2069 www.ciphersoft
inc.com