#1. I am not sure the meaning of "client-managed cloud", but we'll be using "CloudSQL" that is Google's general database service (https://cloud.google.com/sql). “User-defined functions (UDFs) are only supported on self-managed databases." statement is not clear to me but is Google's "CloudSQL" self-managed databases?
#2. We can choose whichever type or version as long as Pega Platform supports UDF, such as PostgreSQL v11.
Posted: 1 year ago
Posted: 3 Aug 2022 7:24 EDT
Marije Schillern (MarijeSchillern)
Senior Knowledge Management Specialist
I know PL/Java is a prerequisite to install UDF. My question is whether GCP supports Java so PL/Java and SQLJ schema can work on (PostgreSQL) database. The Platform Support guide does not talk about UDF support. For example, if you look at Amazon RDS section in Platform Support Guide, it says it's ALL supported, but actually UDF does not actually work because in RDS, Java is not supported and hence PL/Java can't be installed. On the other hand, if you use Amazon EC2, UDF works because unlike RDS, EC2 is just a regular server and you can use it like an on-premise server.
Again, my question is whether GCP supports Java so UDF can work. I am not talking about DBMS type or version.