Transcript Unlock the Power of Exodus Converting Oracle Forms & PL/SQL to Java Presented to: Presented by: Jennifer McNeill, President and CEO.

Unlock the Power of Exodus
Converting Oracle Forms & PL/SQL to Java
Presented to:
Presented by:
Jennifer McNeill, President and CEO
Agenda
•
•
•
•
•
•
•
•
•
•
•
About CipherSoft Inc.
The Business Reasons for migrating to Java
Oracle’s Strategic Direction
Migration Options
Automatic Migration Goals
About Exodus
Conversion Objectives
Conversion Process
Run-time Environment
Migration Questions
Questions & Answers
Corporate History
 Cipher
Systems
was founded as
a conversion &
technology
consulting firm
 Sold joint

Experienced
venture oil &
double digit
gas accounting revenue growth
application to each year between
Ernst and
1995 & 2000
Young
 Developed
 Named
the fastest
growing company in
Alberta by Alberta
Venture magazine &
Grant Thornton
Chartered
Accountants
 Development
euro
conversion of Exodus
began
tool
1978
1980
 Convert
legacy
systems to open
operating
environments
1990
 Developed
Y2K
conversion
tool
 Develop
& market
COBOL based
software products
 Develop
&
implement business
& accounting
applications
1995
1999
 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
2000
 Selected as top
100 fastest growing
companies in
Canada by
PROFIT magazine
 Selected as top
100 Employers by
Mediacorp Canada
 Acquired by
Cedar Group
PLC, a leader in
"mid-market"
native Oracle
Financial
Accounting
Solutions
 Owners
established
CipherSoft Inc. to
further market &
develop Exodus
 Unveiled
Exodus to
public
2001
2002
2003
 Worked
jointly
with Cedar on
development
of Exodus
 Established
conversion
facility at
Canadian
Headquarters

Exodus upgrades:
- JSP files
- Integration
with Oracle
JDeveloper
Driven with Thought Leadership
Publications
Partners
IBM Business
Partner
Oracle Migration
Partner
Conferences & Memberships
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
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
Oracle’s 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 Sites:
CipherSoft is listed in the whitepaper Migrating Oracle Forms to J2EE:
http://otn.oracle.com/products/forms/htdocs/FormsJavaSOD.html
CipherSoft is selected as Migration Partners for the Oracle JDeveloper
partner initiative:
http://otn.oracle.com/products/jdev/htdocs/partners/content.html
Migration Options
• Rewrite Application
– Programmers often want to throw away code and start over. Why? The cardinal
fundamental law of programming: “It’s 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
Goals for Automatic Conversion
•
•
•
•
•
•
Fully maintainable
Portable
Contains no wrappers
All semantic contents converted
Flexible deployment
Very little impact on business operations
Goals for Automatic Conversion
• Integration option - to integrate with Oracle’s
9iAS development environment including:
– Full integration with JDeveloper
– Utilization of Oracle’s 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
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
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
Conversion Process
Oracle
Form
A.FMB
Web Server
Directory Structure
webapps
demoApp
demoApp-ejb
demoApp-web
JLS
DTM/BC4J
NAV
WEB-INF
classes
LIB
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
Conversion Process
Oracle
Form
A.FMB
Web Server
Directory Structure
webapps
Text
Output
demoApp
demoApp-ejb
A.TXT
demoApp-web
JLS
DTM
DTM/BC4J
Transform
to XML
NAV
Transform
to XML
A. XML
WEB-INF
classes
LIB
Conversion Process
Oracle
Form
A.FMB
Text
Output
PL/SQL
JDBC Java
Converter
(Packages)
Web Server
Directory Structure
webapps
demoApp
demoApp-ejb
EJBs
A.TXT
demoApp-web
JLS
DTM/BC4J
Transform
to XML
Transform
Transform
Transform
to XML
XML
to
XML
to
NAV
WEB-INF
classes
A. XML
LIB
Conversion Process
Oracle
Form
A.FMB
Text
Output
PL/SQL
JDBC Java
Converter
(Packages)
JLS
Generator
(Canvases)
Web Server
Directory Structure
webapps
demoApp
demoApp-ejb
EJBs
A.TXT
demoApp-web
JLSs
JLS
DTM/BC4J
Transform
to XML
NAV
WEB-INF
classes
A. XML
LIB
Conversion Process
Oracle
Form
A.FMB
Text
Output
PL/SQL
JDBC Java
Converter
(Packages)
JLS
Generator
(Canvases)
Web Server
Directory Structure
webapps
demoApp
demoApp-ejb
EJBs
A.TXT
Transform
to XML
DTM/B24J
Generator
(DataBlocks)
demoApp-web
JLSs
JLS
DTM/BC4J
DTMs/BC4Js
NAV
WEB-INF
classes
A. XML
LIB
Conversion Process
Oracle
Form
A.FMB
Text
Output
A.TXT
Transform
to XML
PL/SQL
JDBC Java
Converter
(Packages)
JLS
Generator
(Canvases)
DTM/BC4J
Generator
(DataBlocks)
DTM/BC4J
Navigation
Generator
(Relations)
Web Server
Directory Structure
webapps
demoApp
demoApp-ejb
EJBs
demoApp-web
JLSs
JLS
DTM/BC4J
DTMs/BC4Js
NAV
WEB-INF
NAVs
classes
A. XML
LIB
Conversion Process
Oracle
Form
A.FMB
Text
Output
A.TXT
Transform
to XML
A. XML
PL/SQL
JDBC Java
Converter
(Packages)
JLS
Generator
(Canvases)
DTM/BC4J
Generator
(DataBlocks)
Web Server
Directory Structure
webapps
demoApp
demoApp-ejb
EJBs
demoApp-web
JLSs
JLS
DTM/BC4J
Navigation
Generator
(Relations)
DTM/BC4J
DTMs/BC4Js
NAV
Forms
Class
Generator
(Triggers)
classes
WEB-INF
NAVs
Forms Classes
LIB
Run-Time Environment – Servlet/Applet
Client
(Applet)
Client
(Applet)
JDBC
Messaging
HTTP XML
Messaging
Express
Server
(Servlet)
JNDI
Messaging
Servlet
Resources
EJB
Container
demoApp
demoApp-ejb
Client
(Applet)
Relational
Database
App-web
JLS
DTM/BC4J
NAV
WEB-INF
LIB
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?
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?
Q U E S T I O N S
A N S W E R S
Jennifer McNeill
[email protected]
Office: 403 256 5699 Cell: 403 861 2069
www.ciphersoftinc.com