Oracle JDE and RDS

Question

Im working with a new customer and we are exploring the option to migrate their JDE application using RDS oracle as DBMS,  Do you know if JD Edwards E1 can use AWS  RDS ?   if so, which is the best migration strategy?

alemenlo · Accepted Answer

You can migrate and run your JD Edwards EnterpriseOne database on Amazon RDS. When migrating to Amazon RDS Oracle

Migration options:
 
*    Using Oracle UBE R98403 for schema creation/conversion and data migration with DMS
*    Using expdp, impdp or a combination with AWS DMS
*   Oracle RMAN also works if same endianess

You will benefit from RDS managed functionality and concentrate in you application

re:Post Agent · Answer

Yes, JD Edwards EnterpriseOne (JDE E1) can use Amazon RDS for Oracle as its database management system. You can migrate and run your JD Edwards EnterpriseOne database on Amazon RDS, which allows AWS to handle backup tasks and high availability setup while you focus on maintaining your EnterpriseOne application and its functionality.

For migrating JD Edwards EnterpriseOne to Amazon RDS for Oracle, there are multiple strategies:

1. Using Oracle Universal Batch Engine (UBE) R98403 for schema and table creation, and using AWS Database Migration Service (AWS DMS) for migration
2. Using database native tools for schema and table creation and using AWS DMS for migration
3. Using database native tools for the full load (existing data) and using AWS DMS for change data capture (CDC) tasks

The hybrid approach (option 3) is often recommended as it combines the strengths of both methods. This approach uses Oracle Data Pump for the full load phase (which is typically faster and automates the creation of secondary database objects like views, indexes, and constraints) and then AWS DMS for ongoing replication. This strategy allows you to:
- Automate the creation of secondary database objects
- Use AWS DMS data validation to ensure your target data matches the source
- Leverage AWS DMS capabilities like data filtering or renaming tables and columns

If your JD Edwards implementation uses Oracle partitioning on critical tables, note that Amazon RDS for Oracle does support partitioning, but you'll need to ensure you have the appropriate Oracle Enterprise Edition licenses for this functionality.

For cases requiring more customization, such as access to the underlying operating system or SYS/SYSTEM user access, you might consider Amazon RDS Custom for Oracle instead of standard Amazon RDS.  
**Sources**  
[Migrate an Oracle JD Edwards EnterpriseOne database to AWS by using Oracle Data Pump and AWS DMS - AWS Prescriptive Guidance](https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-oracle-jd-edwards-enterpriseone-database-to-aws-by-using-oracle-data-pump-and-aws-dms.html)  
[Amazon RDS for Oracle - AWS Prescriptive Guidance](https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-oracle-database/rds-oracle.html)  
[Oracle Partitioning | AWS re:Post](https://repost.aws/questions/QUdXNLEAT7TfWloxxxuuV5gw/oracle-partitioning)  
[Amazon RDS Custom for Oracle - AWS Prescriptive Guidance](https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-oracle-database/rds-custom-oracle.html)  
[Migrating an Oracle Database to Amazon RDS for Oracle - Database Migration Guide](https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatabases.oracle2rds.html)

Oracle JDE and RDS

Add your answer

Relevant content