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.!
Accepted Solution
Updated: 17 Aug 2022 4:32 EDT
Pegasystems Inc.
GB
@satsihch did you already see
" 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
JP Morgan Chase
US
@MarijeSchillernThank you for sharing those links.
JP Morgan Chase
US
@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 ?