Oracle APEX to Java

ORMIT™-APEX: Automated Oracle APEX to Java migration tool

Oracle Repprts to Jasper Reports Migration

The ORMIT™ APEX advantage

SIGNIFICANT COST SAVINGS

0%+

ORMIT's delivers an automated migration or upgrade that can cost up to 90% less time than a manual migration.

ELIMINATES RISKS

0%

RENAPS ORMIT™ APEX eliminates all migration risks associated with a manual migration

CLEANER MAINTAINABLE CODE

0%

ORMIT™ APEX improves code quality and maintainability, thus paves the way for even more savings over time.

NO VENDOR LOCKINS

0%

100% Open source: no licensing, support fees, or vendor lock-ins will ever apply to your migrated applications.

What's the main objective of ORMIT™-APEX ?

Leveraging automation, ORMIT™-APEX helps our customers in their technological transformation to easily migrate from Oracle Apex to Java and remain successful in an ever-changing landscape.

– Patrick Hamou (CEO, RENAPS)

Why should I migrate from Oracle APEX to Java ?

Protect and leverage all past investments in Oracle Apex

Protect and leverage all past investments in Oracle Apex

Standardize/Modernize the enterprise development platform

Standardize/Modernize the enterprise development platform

Based on Java, the third most popular programming language

Based on Java, the third most popular programming language

Enhanced maintainability with flexible components

Enhanced maintainability with flexible components

Enable Oracle Database migration to PostgreSQL

Enable Oracle Database migration to PostgreSQL

No cumbersome licensing or support fees

No cumbersome licensing or support fees

Why is ORMIT™ APEX the most cost effective solution on the market ?

Why is ORMIT™ APEX the most cost effective Oracle APEX migration solution on the market ?

WITHOUT ORMIT™

WITH ORMIT™

WITHOUT ORMIT™

Setup

Setup

Analysis

Analysis

Plan

Plan

Migration

Migration

Pre-deployment Tasks

Pre-deployment Tasks

Testing

Testing

UAT

UAT

WITH ORMIT™

Manual

Automated

Migration project timeline

Setup

Analysis

Plan

Migration

Pre-deployment Tasks

Testing

UAT

WITH ORMIT™

50% to 90% savings

Manual

Automated

Want to see ORMIT™ APEX in action ?

What is included with ORMIT™-APEX?

ORMIT™-APEX is an automated migration solution which offers the following benefits:

  • Automated APEX applications/pages analysis

  • X-Ray scan of Oracle APEX applications

  • Object count analysis

  • Unused objects (dead-code) & redundant code analysis

  • Business logic distribution analysis

  • Runtime references analysis

  • Code clean up & migration preparation

  • Automated PL-SQL migration to Java

  • A detailed roadmap for Oracle APEX migration

  • Existing APEX applications functional and technical improvements

  • Automated Migration

Migrated Oracle APEX applications architecture

Code comparison before and after migration from Oracle APEX to Java

PL/SQL

Java


SELECT 
    "ID_MSG_CONTACT", 
    "NAME", 
    "FL_ACTIF", 
    "GROUP", 
    "TEAM", 
    NVL("CODE_USAG_MOD","CODE_USAG_AJT") CODE_USAG_MOD, 
    NVL("DH_MOD","DH_AJT") DH_MOD
FROM 
    "ELE".
    "MSG_CONTACT"
--Ticket 93820
--where groupe in ('1','2','M','P','E','D','A','S','L')
WHERE 
    groupe in ('1','2','M','P','E','D','A','S','L','Z')
















@Entity
@Table(name="MSG_CONTACT")
public class MsgContact implements Serializable  {
    @Id
    @GeneratedValue(strategy= GenerationType.IDENTITY)
    @Column(name="ID_MSG_CONTACT", unique=true, able=false, precision=12)
    private BigDecimal idMsgContact;
    @Column(name="NAME", able=false, length=50)
    private String name;
    ...
    @Column(name="DH_MOD")
    private LocalDateTime dhMod;
    @Column(name="FONCTION", length=20)
    private String fonction;

    /** Default constructor*/
    public MsgContact() {
    }

…
@Repository
public interface MsgContactRepository  extends JpaRepository{

	public static final String dbQueryContact = "SELECT c "
		+ "FROM MsgContact c "
		+ "where c.groupe IN ('1','2','M','P','E','D','A','S','L','Z') ";  //JPQL
        //--Ticket 93820 
        //--where groupe in ('1','2','M','P','E','D','A','S','L')

…

Javascript from APEX Link Builder URL field

Javascript converted to regular JS source code


javascript:apex.confirm(
    'Confirmer la suppression de la ligne(s) sélectionnée(s)',
    'MULTI_ROW_DELETE'
);









deleteMsgContacts() {
    this.confirmationService.confirm({
        message: 'Confirmer la suppression de la ligne(s) sélectionnée(s)',
        header: 'Confirmation',
        icon: 'pi pi-exclamation-triangle',
        accept: () => {
            ....
            this.messageService.add({ severity: 'success', summary: 'Réussite', detail: 'Contact(s) supprimé(s).', life: 3000 });
        }
    });
}

Looking to migrate your Oracle Database to PostgreSQL ?

See how ORMIT™-Cortex can help

Breaking free from Oracle? Meet the ORMIT™ Migration Suite

ORMIT™-Jasper

ORMIT™-Jasper

Oracle Reports to Java migration (Jasper Reports)

ORMIT™ Cortex

ORMIT™ Cortex

Oracle Database to PostgreSQL migration

ORMIT™ Forms

ORMIT™ Forms

Oracle Forms upgrade to most recent version

ORMIT™ Java

ORMIT™ Java

Oracle Forms to Java automated migration

ORMIT™ Analyzer

ORMIT™ Analyzer

Migration effort analysis tool

ORMIT™ AP

ORMIT™ AP

Oracle Reports to Analytics Publisher migration

ORMIT™ APEX

ORMIT™ APEX

Oracle APEX migration to Java

Why Renaps?

With more than 20 years of experience, RENAPS has positioned itself as a trusted partner of many high profile brands. Our unparalleled knowledge of the ins and outs of Oracle products make us the ideal partner to help you make the most of your Oracle systems.

Why Renaps?Why Renaps?Why Renaps?Why Renaps?Why Renaps?Why Renaps?Why Renaps?Why Renaps?Why Renaps?Why Renaps?Why Renaps?Why Renaps?

Questions ?