Question
12
Replies
1905
Views
AIG
Posted: May 4, 2017
Last activity: October 16, 2018
Closed
Pega Compatibility with AWS RDS - Oracle
Hello Folks,
We are planning to setup Pega in AWS with the following stack - Tomcat &AWS RDS Oracle. I would like to know the Pega platform compatibility with AWS RDS - Oracle.
- Does Pega/PRPC support AWS RDS Oracle? Has any Clients went with this setup in PROD?
- Does Pega require "Java" to be enabled in the Database either in the current or future versions of Pega?
- I could see the below dependency for enabling Java in DB -
- UDF's require Java to be enabled. Pega uses UDF's only in the reports rules where unexposed properties are used. The work-around for this is to expose the property, and this should address the problem. Are there any other scenarios where Pega uses UDF's and we do not have a workaround?
- AWS RDS does not support Java and UDF's. From the above point, this shouldn't be a show-stopper in moving away from AWS RDS to EC2. Are any Clients using this Stack - Pega + Tomcat + AWS RDS (Oracle/DB2), and is this supported?
***Updated by Moderator: Marissa to add SR Details & update categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Hello,
AWS RDS has one major issue, which is that Pega requires Java in the database to work and AWS RDS does not support it (per https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Oracle.html). Because of this, AWS RDS won't work for Pega, as we use a lot of Java in the database and Pega won't work without it - I believe it won't even install.
What does work is using a full AWS VM, where you can access the underlying OS - this has drawbacks compared to AWS RDS, but it will work if that's what you want. Or PegaCloud, if you're looking at multiple Cloud solutions and not just at AWS.