Does GCP (Google Cloud Platform) support UDF?
This is a simple yes or no question, and this is also equivalent to "Does GCP database support Java". Someone please let me know.
* We know UDF is not a good practice to use, or UDF will be deprecated soon. You do not have to tell me these, and my question is simply yes or no question whether GCP supports UDF or not.
Thanks,
***Edited by Moderator Marije to add Capability tags***
Pegasystems Inc.
GB
@CloeW938 under the Platform Support Guide there is a note:
“User-defined functions (UDFs) are only supported on self-managed databases. See Understanding user -defined functions on Pega Community.”
Please can you clarify the below:
- Are you running a “client-managed cloud” on GCP?
- What type and version of database are you using?
IT Solution Service
SG
#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.
Thanks,
Pegasystems Inc.
GB
@CloeW938 here is the answer to your question.
If you look in the Guide in the Relational Databases section, you will see that Pega supports three databases for Google Cloud Platform: Cloud SQL for PostgreSQL 11, 12, and 13.
Please confirm which version of “CloudSQL” you will be using - you mentioned PostgreSQL v11 .
Here are the important notes for user-defined functions (UDFs).
- For PostgreSQL databases, installation of (and support for) the pljava extension is a prerequisite in order to install the UDFs.
- For Microsoft SQL Server databases, the Common Language Runtime functionality is a prerequisite in order to install the UDFs.
For full details on UDF, see Java user-defined functions in your Pega database.
IT Solution Service
SG
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.
Thanks,
Updated: 3 Oct 2022 9:43 EDT
Pegasystems Inc.
GB
@CloeW938 GCP does not support UDFs for CloudSQL as CloudSQL is a fully-managed relational database service.
User-defined functions (UDFs) are only supported on self-managed databases.
Considering this is really a question for GCP (not Pega) perhaps you could also direct this question to google's support channels?