Question
Personal and Business Computers
FR
Last activity: 6 Feb 2018 11:26 EST
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***
Pegasystems Inc.
IN
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.
Personal and Business Computers
FR
Thank you for your response , please can you give me an example of complex Pega's OOTB procedures and functions tha you know ?
- ------------------------------------------------------
About Azure Cloud Pega deployment : https://pdn.pega.com/deploying-pega-platform-microsoft-azure/deploying-pega-platform-microsoft-azure
" 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."
- --------------------------------------------------
About Amazon Cloud AWS Pega deployment : https://pdn.pega.com/deploying-pega-platform-amazon-web-services/deploying-pega-platform-amazon-web-services
"Note : 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."
-------------------
I am not developper and rather someone of the infrastructure, I ask the question to known if it is the obligation to have this functionality installed and activated for Pega Platform.
If these functionalities (UDF) are not important , then I choose Azure Cloud PostgreSqlDatabase servers and set bypass.udf.generation = true in the setupDatabase.properties file to avoid the installation and management of database servers after
Pegasystems Inc.
US
The installation of UDF functions is NOT required. Nothing within the pega platform or any strategic apps should require the use of the UDFs. They are useful to have during development when you are still deciding on what properties are needed in reports. If you are not able to install the UDFs then you will need to expose any property that you want to include in a report. It is not recommended to install UDFs in production as the use of UDFs can cause a performance issue.
https://pdn.pega.com/when-use-%E2%80%94-and-when-not-use-%E2%80%94-unoptimized-properties-reports
Personal and Business Computers
FR
Thank you for your feedbacks,tomorow I will try to install pega platform by using Azure Database Server and setting bypass.udf.generation=true .
we will try this experience and come back to you as possible .
Thanks !
Accepted Solution
Personal and Business Computers
FR
I installed pega platform by using Azure Database Server and setting bypass.udf.generation=true .
It worked,we continuing our test and development
Personal and Business Computers
FR
I confirm you , it work fine . Thank you for your help