Is anyone running Pega in AWS using RDS Oracle

Hi Team,

Can some one please shed some light on what’s the impact of running Pega in AWS Cloud using RDS-Oracle which don’t support the User Defined Functions ?

I believe in the RD, it can’t support user defined functions to read from BLOB column? Any other impacts of not having the User defined functions in Oracle?

Thanks in Advance.!

@satsihc6 did you already see

AWS RDS Postgres Installation

" UDF severely degrades the performance and UDF installation is optional. Except for the report definitions(with unexposed properties), there is no other place UDF’s are useful. Hence, you may go ahead without the UDF installation."

Pega Compatibility with AWS RDS - Oracle

Pega installation on AWS Postgres RDS

How to install UDF’s in an Amazon RDS -PostgreSQL instance?

UDF functionality is optional and it is required in case to use the properties that are not optimized [SR-C61814] in reports. So, the Pega recommendation to use the UDF’s in RDS is using PL/V8 scripts. These are not provided as part of the media file. Need to check with your respective Pega account administrator”.

General info: When to use — and when not to use — unoptimized properties in reports

@MarijeSchillern Thank you for sharing those links.

@MarijeSchillern , Helm charts shows only the password based authentication. Can you please suggest how to integrate with the secrets Manager for connecting to the RDS-Oracle other than the “Kubernetes External Secrets” ?

Also, Can you please confirm whether PEGA supports the IAM Authentication (DB Token Generator) to connect to Postgres SQL database ?