Question

6
Replies
1132
Views
olivierK7667 Member since 2017 2 posts
Personal and Business Computers
Posted: 2 years ago
Last activity: 2 years 7 months ago
Closed
Solved

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-… , 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/deploy… :

" 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***

Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn