Question
UDF and SQLJ SCHEMA inevitably for pega Install ?
Hi,
What is User Defined Functions (UDF) ? What is SQLJ Schema ? We must inevitably install these for the Pega platform Database ?
Can we use Azure PostgreSql Database for Pega install ( without blocked by installing PL:Java for java user-defined fonctions : UDF and execute also install.sql requete to create SQLJ schema ?
I asked these questions because , I want to use Azure PostgreSql Database servers . This permit me to avoid to install virtual servers on azure cloud , and install after community postgresql database server . which saves me time and does not take care of managing database servers .
- On Pega 7.3.1 Install Tomcat PostGreSql guide , it's written :
" Installing PL/Java for Java user-defined functions :
The Pega Platform requires Java user-defined functions (UDFs). To work with PostgreSQL, UDFs
require the PL/Java add-on for PostgreSQL and a new dedicated schema. The new schema, called
SQLJ, is defined for the Pega Platform database.
For PostgreSQL 9.3 and later, the PL/Java module is included in the Pega Platform resource kit.
Before you install the Pega Platform, install the version of PL/JAVA included in your resource kit. If
you do not install and configure PL/Java before you attempt to install the Pega Platform, the Pega
Platform installation fails. Follow the instructions for your platform."
- On this link Deploying Pega Platform on Microsoft Azure:
https://pdn.pega.com/deploying-pega-platform-microsoft-azure/deploying-pega-platform-microsoft-azure , it's mentionned :
" Note : The Azure SQL Database service does not allow installation of user-defined functions (UDFs). Therefore, before you install Pega Platform, set bypass.udf.generation=true
in the setupDatabase.properties file. For more information, see your Pega Platform Installation Guide. "
- On this link also Deploying Pega Platform on Amazon Web Services : https://pdn.pega.com/deploying-pega-platform-amazon-web-services/deploying-pega-platform-amazon-web-services :
" The Amazon RDS service does not allow installation of user-defined functions (UDFs). Therefore, before you install Pega Platform, set bypass.udf.generation=true
in the setupDatabase.properties file. For more information, see your Pega Platform Installation Guide. "
Thank you for yor help
***Edited by Moderator Marissa to update categories***
I too have faced this question and problem during installation with postgres database. It's tedious and time taking. But to answer your questions, as per my knowledge and experience you have to install.
These are necessite for execution of complex Pega's OOTB procedures and functions.
Though, i dont have exact knowledge about Azure product and it's restriction. I could only say, if it's mentioned in the user guide then you have to follow the step by step process.
Let us know, if you could tweak something and able to install and build. And execute application smoothly.